ChatGPT for Sheets. Now with Perplexity, Claude, Gemini, Mistral, Dall-E, Replicate, o1-Preview, o1-Mini. Ideal for Lean SEO, Programmatic SEO, Data Enrichment, and Collecting Leads
Unlock the power of GPT-4o, Replicate, GPT-Vision, DALL-E, Claude, Perplexity, Mistral, o1-Preview, o1-Mini, and Gemini AI models directly within Google Sheets. Integrate AI with web access, image generation, data enrichment, programmatic SEO, API integration, scrapping sites, bulk site creation, and Google indexing.
- 1000 queries / month - About 5 million words of gpt-4o inputs & output
- No need for API keys
- SERP function to get top results from the Search
- WEB Scraping functions
- Support 100+ languages
- GPT to get the result of ChatGPT in a single cell
- GPT_TABLE, GPT_LIST to get a table of items from a prompt
- GPT_FORMAT to sanitize your sheet data into the same format
- GPT_EXTRACT to extract entities from your Sheets™ data
- GPT_SUMMARIZE to summarize your sheet content
- GPT_CLASSIFY to classify sheet content into a single category
- GPT_TAG to apply tags to your sheet content
- GPT_TRANSLATE to translate your spreadsheet content
- GPT_CONVERT to convert CSV to HTML to JSON to XML, etc.
- GPT_APPLY to apply any AI processing of you text
- GPT_SPLIT to split your text by phrase, sentence, etc..
$29.99/ mo
- More queries: 15000/ mo
- Access to all Starter features
- NEW: GPT-4o, GPT-4o-Mini
- GPT-4 Vision, DALL-E
- Other AI models: Claude, Mistral, Gemini, Perplexity
- Image generation
- Image vision
- OpenRouter AI
- SERP("docgpt.ai")
- With API() function you can push/pull your content on your site, service from Sheets!
- FLATTEN_JSON() - convert your JSON into table
- WEB Scrapping functions
- Great fit for programmatic SEO
- Great fit for Lean SEO
- You need to set up your API Key
- .
- .
- More queries: Unlimited
- Access to all Pro User features
- NEW: GPT: o1-preview, o1-Mini - [available for Tier 5]
- NEW: REPLICATE() - integrated with Replicate AI service to help you generate images in bulk, using ANY AI model
- Great fit for programmatic SEO
- Great fit for Lean SEO
- Lead and Data Enrichment (Clay Alternative)
- GOOGLE_SEARCH()
- GOOGLE_INDEXING()
- CREATE_FILE()
- Brave Search API (web, videos, discussion) - returns search data for AI (2k /m requests free)
- Get Top Ranking Keywords of Competitors
- Get keyword suggestions, search volume, keyword difficulty
- Get keyword ideas by a keyword
- Get related keywords
- You need to set up your API Key
- CLOUDINARY() - Upload images to file hosting
- No request limits during high-traffic periods
- 2X faster response time
- Priority support
- .
- .
- .
- .
- Save 30%
- 1250 queries/mo - About 7 million words of gpt-4o mini inputs & output
- Access to all features
- No need for API keys
- SERP function to get top results from the Search
- WEB Scraping functions
- Support 90+ languages
- GPT to get the result of ChatGPT in a single cell
- GPT_TABLE to get a table of items from a prompt
- GPT_FORMAT to sanitize your sheet data into the same format
- GPT_EXTRACT to extract entities from your Sheets™ data
- GPT_SUMMARIZE to summarize your sheet content
- GPT_CLASSIFY to classify sheet content into a single category
- GPT_TAG to apply tags to your sheet content
- GPT_TRANSLATE to translate your spreadsheet content
- GPT_CONVERT to convert CSV to HTML to JSON to XML, etc.
- GPT_APPLY to apply any AI processing of you text
- GPT_SPLIT to split your text by phrase, sentence, etc..
- Online Support
- Weekly feature updates
$9.99/ mo
- Save 60%
- More queries: 17000/ mo
- Access to all Professional features
- NEW: GPT-4o, GPT-4o-Mini
- GPT-4 Vision, DALL-E
- Other AI models: Claude, Mistral, Gemini, Perplexity
- Image generation
- Image vision
- OpenRouter AI
- SERP("docgpt.ai")
- With API() function you can push/pull your content on your site, service from Sheets!
- FLATTEN_JSON() - convert your JSON into table
- WEB Scrapping functions
- Great fit for programmatic SEO
- Great fit for Lean SEO
- You need to set up your API Key
- Save 60%
- More queries: Unlimited
- Access to all Pro User features
- NEW: GPT: o1-preview, o1-Mini - [available for Tier 5]
- NEW: REPLICATE() - integrated with Replicate AI service to help you generate images in bulk, using ANY AI model
- Great fit for programmatic SEO
- Great fit for Lean SEO
- Lead and Data Enrichment (Clay Alternative)
- GOOGLE_SEARCH()
- GOOGLE_INDEXING()
- CREATE_FILE()
- REPLACE_TEMPLATE() - Create multiple templated content in Sheets
- Brave Search API (web, videos, discussion) - returns search data for AI (2k /m requests free)
- Get Top Ranking Keywords of Competitors
- Get keyword suggestions, search volume, keyword difficulty
- Get keyword ideas by a keyword
- Get related keywords
- You need to set up your API Key
- CLOUDINARY() - Upload images to file hosting
- No request limits during high-traffic periods
- 2X faster response time
- Priority support
- .
- .
- .
- .
- More queries: Unlimited
- Access to all Business features
- NEW: GPT: o1-preview, o1-Mini - [available for Tier 5]
- Great fit for programmatic SEO
- Great fit for Lean SEO
- Lead and Data Enrichment (Clay Alternative)
- You need to set up your API Key
- No request limits during high-traffic periods
- 2X faster response time
- Priority support
- .
Important!
If you encounter the message: "Authorization is required to perform this action."
- Use a personal Gmail account: If you use a company email (workspace), it may have restrictions on using add-ons. You might need to ask your company's email administrator to configure settings to allow the installation of add-ons. Therefore, it’s recommended to use a personal account. If you need to transfer your subscription, please contact support via chat.
- If you use a personal account and still encounter this issue, simply re-install the add-on.
- For more help, check out the following resources: Troubleshooting Guide, and The model does not exist, or you do not have access to it.
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!
I purchased an annual subscription for the Professional version. Can't tell you how excited I am!
..
A few of our team members recently started using GPT for Sheets as part of their workflow and have been really enjoying it :) Just wanted to reach out first of all and say awesome job! Thanks so much!
-
Step 1Install Add-On
Go to Workspace Marketplace and click on Install button.
-
Step 2Open Google Sheets
Please open a Google Sheets where you want to use the add-on.
-
Step 3Launch the Add-On
Click on Extensions button, choose GPT for Docs Sheets and click Launch.
How to use GPT for Sheets to generate 1000+ SEO titles, meta tag descriptions, content
🎃 Halloween Special! 🎃
To celebrate the spooky season, I am offering a special discount on Annual Enterprise, Professional and Lifetime Plans — available only to the first 20 customers!
Use the code HELLOWEEN-20 at checkout to get 20% off.
Don't miss out! 👻
How to use ChatGPT in Google Sheets for generation 1000+ product descriptions
How to Extract Emails From Instagram, LinkedIn, Twitter (X.com), Facebook with ChatGPT in Google Sheets
Supported Functions
Function | Description |
---|---|
=API(method, url, body, headers) |
Enables you to retrieve and send content across your website, services, WordPress, Twitter, LinkedIn, Airtable, Zapier, or any other platform.. |
=GPT(prompt, [value]) |
Generates text based on the provided prompt using GPT models (GPT-3 or GPT-4). |
=SERP(query) |
Retrieves search engine results pages (SERP) for the specified query. |
=REPLACE_TEMPLATES(template, VAR_1, VAR_2, ...) |
Replaces templated variables in a string with values from specified cells or hardcoded strings, allowing you to create dynamic text by replacing placeholders like , , etc., with corresponding values. |
=CREATE_FILE_ON_DRIVE(fileName, content, MimeType) |
Allows users to create a file in Google Drive with the specified content and MIME type. |
=GOOGLE_RANKED_KEYWORDS(domain, count) |
Fetches the ranked keywords for a specified domain using the DataForSEO API, providing insights into the keywords for which a domain is ranking in Google search results. |
=GOOGLE_SEARCH_API(query, contextId, apiKey, pages) |
Performs a Google Custom Search and retrieves the top search results. Official API from Google! |
=GOOGLE_INDEXING(url) |
Allows site owners to directly notify Google when pages are added or updated. |
=SEO_BLOG(blog title, writing tone, language) |
Generates an SEO-optimized blog post (1k+ words) based on the provided title, writing tone, and language. |
=SEO_STRATEGY(keywords, language) |
Generates a comprehensive SEO strategy based on the provided keywords and language. |
=GOOGLE_KEYWORD_SUGGESTIONS(seedKeyword, login, password) |
Generates keyword suggestions based on a seed keyword using the DataForSEO API, helping you discover related keywords and phrases relevant to your seed keyword. |
=GOOGLE_KEYWORD_IDEAS(seedKeyword, login, password) |
Generates keyword ideas based on a seed keyword using the DataForSEO API, helping you discover new keyword opportunities related to your seed keyword and enhancing your SEO and content strategies. |
=SEO_OUTRANK(url outrank, writing tone, language) |
Analyzes the given URL and provides content recommendations to outrank it in search engine results. |
=BRAVE_SEARCH_WEB(query, subscriptionToken, resultFilter, count, country) |
Fetches search results from Brave's web search API based on the specified query and parameters, useful for data enrichment tasks. Get Free API Key - 2,000 queries per month |
=CLAUDE(prompt) |
Generates text based on the provided prompt using the Claude model. |
=GEMINI(prompt) |
Generates text based on the provided prompt using the Gemini model. |
=MISTRAL(prompt) |
Generates text based on the provided prompt using the Mistral model. |
=GPT_VISION(url, prompt) |
Analyzes an image from the provided URL and generates text based on the prompt. |
=GPT_TAG(text, [tags]) |
Tags the provided text with the specified tags. |
=WEB_URL("https://docgpt.ai") |
Retrieves the URL from the specified web address. |
=WEB_TITLE("https://docgpt.ai") |
Retrieves the title from the specified web address. |
=WEB_DESCRIPTION("https://docgpt.ai") |
Retrieves the description from the specified web address. |
=WEB_H1("https://docgpt.ai") |
Retrieves the first-level heading (H1) from the specified web address. |
=WEB_H2("https://docgpt.ai/") |
Retrieves the second-level heading (H2) from the specified web address. |
=WEB_HEADINGS("https://docgpt.ai") |
Retrieves all the headings from the specified web address. |
=WEB_PARAGRAPHS("https://docgpt.ai") |
Retrieves all the paragraphs from the specified web address. |
=WEB_URLS_DATA(A37:A39) |
Retrieves data from the URLs specified in the range A37:A39. |
=GPT_EXTRACT(text, to_extract) |
Extracts specified information from the provided text. |
=GPT_TRANSLATE(text, target, [source]) |
Translates the provided text to the target language, with an optional source language. |
=GPT_SUMMARIZE(text, [format]) |
Summarizes the provided text, with an optional specified format. |
=GPT_FORMAT(text, source, target) |
Converts the provided text from the source format to the target format. |
=GPT_CLASSIFY(text, categories) |
Classifies the provided text into the specified categories. |
=GPT_FILL(examples, inputs) |
Fills in the blanks in the provided inputs based on the examples given. |
=GPT_LIST(prompt, [value]) |
Generates a list based on the provided prompt. |
=GPT_HLIST(prompt, [value]) |
Generates a hierarchical list based on the provided prompt. |
=GPT_SPLIT(text, split_by) |
Splits the provided text by the specified delimiter. |
=GPT_HSPLIT(text, split_by) |
Splits the provided text hierarchically by the specified delimiter. |
=GPT_APPLY(text, [task]) |
Applies the specified task to the provided text. |
=GPT_TABLE(prompt, headers) |
Generates a table based on the provided prompt and headers. |
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 "," |
=SERP() functions return the top 20 search results from the Search Engine with the URL, meta title, and meta description.
Re-try functions with errors
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_VISION allows the model to take in images and answer questions about them
Syntax | =GPT_VISION(url, prompt) |
---|---|
Copy/paste example | =GPT_VISION("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_VISION(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
Syntax | =GPT_TAG(text, [tags]) |
---|---|
Copy/paste example | =GPT_TAG(A61, "travel, positive, nature, sunset, car, building, ai") |
Copy/paste example | =GPT_TAG(A62, "entertainment, positive, car, building") |
Localization | In some Google Sheets localization, you need to use ";" to separate parameters instead of "," |
GPT_TABLE generates a table with data
Syntax | =GPT_TABLE(prompt, [headers]) |
---|---|
Copy/paste example | =GPT_TABLE("top 10 most popular cities and their population") |
Copy/paste example | =GPT_TABLE("top 10 most popular cities and their population", A1:C1) |
Localization | In some Google Sheets localization, you need to use ";" to separate parameters instead of "," |
GPT_LIST/GPT_HLIST generating a list with data
Syntax | =GPT_LIST(prompt, [value]) |
---|---|
Copy/paste example | =GPT_LIST("top 10 most popular cities") |
Copy/paste example | =GPT_HLIST("top 10 most popular cities") |
Localization | In some Google Sheets localization, you need to use ";" to separate parameters instead of "," |
GPT_SPLIT/GPT_HSPLIT splits text semantically, such as by section, paragraph, sentence, customer...
Syntax | =GPT_SPLIT(text, split_by) |
---|---|
Copy/paste example | =GPT_SPLIT("The sky is blue. The cat purrs softly. The sun shines brightly.", "sentences") |
Copy/paste example | =GPT_HSPLIT("The sky is blue. The cat purrs softly. The sun shines brightly.", "sentences") |
Localization | In some Google Sheets localization, you need to use ";" to separate parameters instead of "," |
GPT_APPLY utilizes the specified task on the provided text, with the default objective being to correct grammar and spelling errors
Syntax | =GPT_APPLY(text, [task]) |
---|---|
Copy/paste example | =GPT_APPLY("He hav a book", "fix grammar and spelling") |
Localization | In some Google Sheets localization, you need to use ";" to separate parameters instead of "," |