Leverage the GPT, Claude, Mistral, and Gemini AI models within Google Sheets to seamlessly incorporate the power of GPT-3, GPT-4, Claude, and Gemini directly into your spreadsheets. Enjoy a seamless experience straight out of the box, without the hassle of dealing with API keys. Setup is simple and hassle-free.
I purchased an annual subscription for the Professional version. Can't tell you how excited I am!
Ryan Hotchkiss - Senior Digital Marketing Manager
I've employed this add-on within Sheets to craft SEO-focused product descriptions, meta descriptions, and meta titles for more than 300 products. It's been a lifesaver!
Vice President of Human Resources at iLoveToCreate
Get Started
Step 1
Install Add-On
Go to Workspace Marketplace and click on Install button.
How to use GPT for Sheets to generate 1000+ SEO titles, meta tag descriptions, content
How to use ChatGPT in Google Sheets for generation 1000+ product descriptions
Scraping WEB functions: Content, title, description, h1, h2, paragraphs, fetch in bulk
Use GPT function to create and rewrite content
Syntax
=GPT(prompt, [value])
Copy/paste example
=GPT("Write a tagline for BMW")
Copy/paste example
=GPT("Write a tagline for", B5)
Copy/paste example - arrays
=GPT(A1:B4)
Copy/paste example - several cells
=GPT(A1 & B4)
Localization
In some Google Sheets localization, you need to use ";" to separate parameters instead of ","
Use GPT function to improve product description
Syntax
=GPT(prompt, [value])
Copy/paste example
=GPT("Make shorter this product name max 3 words", A16)
Copy/paste example
=GPT("Make this product name more for Ebay customers", A22)
Localization
In some Google Sheets localization, you need to use ";" to separate parameters instead of ","
Use GPT function for generation SEO metadata
Syntax
=GPT(prompt, [value])
Copy/paste example
=GPT("Write Responsive Display Google Ads description: ", "Travel Agency")
Localization
In some Google Sheets localization, you need to use ";" to separate parameters instead of ","
Use GPT_IMAGE allows the model to take in images and answer questions about them
Syntax
=GPT_IMAGE(url, prompt)
Copy/paste example
=GPT_IMAGE("https://static.nike.com/a/images/t_PDP_1728_v1/f_auto,q_auto:eco/b7d9211c-26e7-431a-ac24-b0540fb3c00f/air-force-1-07-mens-shoes-jBrhbr.png", "Write a short description for this product")
Copy/paste example
=GPT_IMAGE(A1, A2)
Localization
In some Google Sheets localization, you need to use ";" to separate parameters instead of ","
Use GPT_TRANSLATE function to translate your text into 90+ languages
Syntax
=GPT_TRANSLATE(text, target, [source])
Copy/paste example
=GPT_TRANSLATE(A30, "norwegian","english")
Localization
In some Google Sheets localization, you need to use ";" to separate parameters instead of ","
Use GPT_EXTRACT emails, first names, last names, countries...
Syntax
=GPT_EXTRACT(text, to_extract)
Copy/paste example
=GPT_EXTRACT(A43,"email address")
Copy/paste example
=GPT_EXTRACT(A50,"phone number")
Copy/paste example
=GPT_EXTRACT(A57,"country")
Localization
In some Google Sheets localization, you need to use ";" to separate parameters instead of ","
Use GPT_CLASSIFY to make sentiment analysis for comments, feedbacks, text
Syntax
=GPT_CLASSIFY(text, categories) ➡️
Copy/paste example
=GPT_CLASSIFY(A54,"very positive, positive, neutral, negative, very negative")
Localization
In some Google Sheets localization, you need to use ";" to separate parameters instead of ","
Use GPT_TAG - Categorize or classify text with tags, keywords