Use discount coupon BLACKFRIDAY2024_LIFETIME - 50% off lifetime plan | BLACKFRIDAY2024_YEARLY - 30% off yearly subscription | Last day of discount! 🎉

GPT for Google Sheets, Docs AI, Slides, Forms

ChatGPT for Sheets. Now with Perplexity, Claude, Gemini, Mistral, Dall-E, Replicate, o1-Preview. Ideal for Lean SEO, Programmatic SEO, Data Enrichment, Collecting Leads, Mail Merge. Apollo, Prospeo integration (Clay alternative).

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, bulk email sending (Mail Merge), and Google indexing. Apollo and Prospeo integration for retrieving contacts by domain, and obtaining LinkedIn information/emails by URL (alternative to Clay).

⭐⭐⭐⭐⭐ Rated 4.8/5 out of 1000+ reviews and 1M+ installs

During purchase, please use the same email you will use in Google Sheets, preferably a personal (not company) email.

Find perfect plan
Annually Monthly
Starter
$19.99/ mo
  • 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..
Pro User
EXPERT

$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
  • .
  • .
Business
POPULAR
$39.99/ mo
  • More queries: Unlimited
  • Access to all Pro User features
  • NEW: GPT: o1-preview, o1-Mini
  • Place enriching tool using Google Maps
  • EMAIL_SEND() - Bulk email sending
  • Apollo integration - get contacts by a domain
  • Prospeo integration - get emails by a domain
  • Prospeo - get linkedin and emails by a url
  • 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
  • .
  • .
  • .
  • .
Professional
$11.17/ mo
Billed $133.99 annually
  • 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
Pro User
POPULAR

$9.99/ mo

Billed $119.99 annually $360
  • 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
Enterprise
UNLIMITED
$19.99/ mo
Billed $199.99 annually $480
  • Save 60%
  • More queries: Unlimited
  • Access to all Pro User features
  • NEW: GPT: o1-preview, o1-Mini
  • Place enriching tool using Google Maps
  • EMAIL_SEND() - Bulk email sending
  • Apollo integration - get contacts by a domain
  • Prospeo integration - get emails by a domain
  • Prospeo - get linkedin and emails by a url
  • 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
  • .
  • .
  • .
  • .
Lifetime
$299 / once
  • 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
  • .
⭐⭐⭐⭐⭐ Rated 4.8/5 out of 500+ reviews and 1M+ installs
Install GPT for Sheets
💡️️️️ How to set up your API Key

Important!

If you encounter the message: "Authorization is required to perform this action."

  1. 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.
  2. If you use a personal account and still encounter this issue, simply re-install the add-on.
  3. For more help, check out the following resources: Troubleshooting Guide, and The model does not exist, or you do not have access to it.
gpt for sheets
Basic Template & Creation multiple product descriptions at once
gpt for sheets
Lead Enrichment - generate leads from data
template for data enrichment, extracting emails from social media
Place enriching tool using Google Maps
gpt for sheets | Create Unique Up-to date content in bulk
Create Unique Up-to date content in bulk
template for data enrichment, extracting emails from social media
Extracting emails from social media
gpt for sheets - template for programmatic seo
Programmatic seo | Generate 30 SEO-optimized pages at once
gpt for sheets | social media post generator with ai
AI Social Media Generator
gpt for sheets | google indexing from google sheets
Notify Google when pages are added
clay for sheets | Clay alternative for retrieving emails by domain, and LinkedIn information and emails by LinkedIn URL
Clay alternative (Apollo, Prospeo integration) for retrieving emails by domain, and LinkedIn information and emails by LinkedIn URL
Get Top Ranked Keywords for competitors, pull keywords suggestions in bulk, ahref alternative, semrush
Get Top Ranked Keywords for competitors, keywords suggestions. Ahref and SemRush in Sheets
docgpt ai feedback

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

docgpt ai feedback

I purchased an annual subscription for the Professional version. Can't tell you how excited I am!

.
.

Ryan Hotchkiss - Senior Digital Marketing Manager

docgpt ai feedback

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!

Dee - founder at the Pearl Lemon Group

Get Started

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

How to Extract Emails From Instagram, LinkedIn, Twitter (X.com), Facebook with ChatGPT in Google Sheets

gpt for 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.

Scraping WEB functions: Content, title, description, h1, h2, paragraphs, fetch in bulk

gpt for sheets

Use GPT function to create and rewrite content

Chat GPT in Google Sheets for creation and rewriting 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.

Chat GPT in Google Sheets - retry functions with errors

Re-try functions with errors

Chat GPT in Google Sheets - retry functions with errors

Use GPT function to improve product description

GPT function for improving product description for online stores - Ebay, Amazon, Shopify
Change writing tone inside GPT for Sheets
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

GPT function for Sheets to generate 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

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

GPT_TRANSLATE function to translate your metadata, description, sites in Google Sheets
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...

GPT_EXTRACT function 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

GPT_CLASSIFY 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

GPT_TAG helps to categorize and classify text
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 ","