Classify data in Google Sheets with ChatGPT
👉 Get the GPT FOR SHEETS AND DOCS add-on: https://workspace.google.com/marketpl...
Thanks to the GPT_CLASSIFY() function, classify your Google Sheets data in a jiffy ! 💨 This video explains how to easily assign categories to your spreadsheet data. Predefine the categories and let the magic of ChatGPT happens 🪄
Once you entered the desired categories in your spreadsheet, select them and the function will automatically assign one category by row.
👉 If you need to assign more than one tag to your data rows please ckeck out our video about the GPT_TAG() function : • Make ChatGPT tag your data in Google Sheet...
📖 Function in this video
Syntax: =GPT_CLASSIFY(text, categories, [temperature], [max_tokens], [model]) - model by default: gpt-3.5-turbo
Copy/Paste exemple: =GPT_CLASSIFY(""banana"", ""fruit, vegetable"")
Copy/Paste exemple with custom temperature, max_tokens and model parameters:
=GPT_CLASSIFY(""banana"", ""fruit, vegetable"", 0.7, 200, text-curie-001)
▶️ PLAYLIST:
Discover all the functionalities of the GPT for Sheets and Docs add-on: • All about GPT for Sheets
📥 List of all available functions and template of examples to download : https://support.gptforwork.com/hc/en-...
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback , we'll be happy to answer : https://forms.gle/QLtQMdhoResxQ2bDA
------------------------------------------------------------------------------------------
GPT for Sheets and Docs is an AI writer and assistant for Google Sheets and Google Docs. The add-on brings the power of OpenAI GPT-3 models (including gpt-3.5-turbo) directly into Google Sheets and Docs for your convenience. It is like using ChatGPT directly in your Google workspace! Don't mess with apps script anymore, just download the add-on !
💡 More resources and examples on our website: https://gptforwork.com/
🔔 Don't miss any new feature by subscribing to our channel: / @gptforwork
------------------------------------------------------------------------------------------
This channel is brought to you by TALARIAN: https://talarian.io/
Check out our other productivity tools for Google Workspace:
🚀 YAMM : https://yamm.com/
🔥 AWESOME TABLE : https://awesome-table.com/
🤖 FORM PUBLISHER : https://form-publisher.com/