Autofill your ranges based on examples with ChatGPT in Sheets!

Опубликовано: 17 Октябрь 2024
на канале: GPT for Work (GPT for Sheets, Docs, Excel, Word)
11,544
89

Sometimes describing what you want in a prompt can be tricky! With the GPT_FILL function of GPT for Sheets, just write a few example rows to show what you expect, and ChatGPT will fill the rest of your list rows according to the defined pattern.


In this video, we present two use cases but you can use GPT_FILL() in Google Sheets to:
clean up your lists
extract entities
classify content and much more… be creative!

📖 Function in this video
Syntax =GPT_FILL(examples, [inputs], [temperature], [max_tokens], [model])

⌚️ TIMESTAMPS
00:00 Unify your data format
00:56 Generate product headlines and tags

▶️ PLAYLIST:
Discover all the functionalities of the GPT for Sheets and Docs add-on:    • All about GPT for Sheets  

------------------------------------------------------------------------------------------
Like ChatGPT? Imagine using it in bulk in Google Sheets or Microsoft Excel and Word! 🤠
Make ChatGPT and other AIs write, rephrase, translate, categorize, extract, reformat, summarize, do research… 1000x faster than you could.

Popular use-cases for Excel and Sheets:
🌍 Translate in bulk
✍️ Create SEO content or ads copy at scale
🗂️ Clean and categorize your PIM or CRM
📊 Analyze survey results or customer feedback
📋 Review / Score a list of leads or candidates
🔍 Automate market research

Why use GPT for Work?
🚫 Stop copy/pasting to and from ChatGPT
⚡ Run up to 1000 prompts per minute
🎛️ Large model choice: GPT-4o, Claude 3.5 Sonnet, Gemini...
🔑 No API key required

Privacy and security:
🔒 Talarian is ISO 27001 certified and GDPR compliant
🛡️ We do not use your content to train models
🔐 Bring your own API key for enhanced privacy

🔔 Don't miss any new feature by subscribing to our channel:    / @gpt4work  

Learn more:
🌐 Website: https://gptforwork.com
💻Install: https://gptforwork.com/install
🚀 Get started: https://gptforwork.com/help/quickstar...
🛟 Help: https://gptforwork.com/help