How to quickly map data in Google Sheets with ChatGPT
👉 Get the GPT FOR SHEETS AND DOCS add-on: https://workspace.google.com/marketpl...
Our new function = GPT_MAP() makes data mapping super easy! 🔛 Just select the columns you want to map and ChatGPT will automatically match similar values. You can even adjust the similarity threshold to make it more or less strict. Learn how to use it inside Google Sheets in this video.
📖 Function in this video
Syntax: =GPT_MAP(search_keys, range, [confidence], [stats]) - model by default: gpt-3.5-turbo
Confidence: set a similarity threshold. Must be comprised between 0 and 1.
Stats: "true" to display similarity score
▶️ 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://gptforwork.com/help/gpt-for-s...
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback , we'll be happy to answer: https://support.gptforwork.com/hc/en-...
------------------------------------------------------------------------------------------
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/