GPT for Google Sheets, Docs AI, Slides, Forms

ChatGPT for Sheets. Now with Perplexity, Claude, Gemini, Mistral, Dall-E, Replicate, o1-Preview, o1, o1-mini, o1-preview, o3-mini, o3-mini-high. Ideal for Lean SEO, Programmatic SEO, Data Enrichment, Lead Research, Mail Merge. Hunter, Apollo, Prospeo, LeadMagic, MailChimp integration (Clay alternative).

Unlock the power of GPT-4o, Replicate, GPT-Vision, DALL-E, Claude, Perplexity, Mistral, o1, o1-mini, o1-preview, o3-mini, o3-mini-high, 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. Lead Research - Hunter, Apollo, LeadMagic 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
  • 🚀 AI Powerhouse: Support ALL AI models with web access: GPT, Perplexity, Claude, Gemini, Mistral.
  • ⚡ Automated Page Generation: Create 1000+ SEO-optimized pages in just 1 click (Programmatic SEO and Lean SEO).
  • 📤 Bulk Email Simplified: Send personalized email campaigns at scale with EMAIL_SEND().
  • 📺 YouTube Data Integration: Search and analyze YouTube channels, creators, and videos directly in Sheets with YOUTUBE_SEARCH(), YOUTUBE_CHANNEL(), and YOUTUBE_VIDEO() functions.
  • 🔎 Scrape Emails and Leads from Google Search: Use clever operators with =SERP() to extract data like emails and social profiles for outreach. For example: =SERP("site:instagram.com Yoga gmail.com").
  • 🔍 Google Maps Integration: Analyze competitors and customer reviews directly in Sheets for smarter decision-making.
  • 🌍 Data Enrichment Made Easy: Enrich leads using integrations with Google Maps, Hunter, Apollo, Prospeo, LeadMagic, MailChimp, Google Search, and AI models with web access.
  • 🌍 Integrate Any Service: Use the API() function to seamlessly connect any of your services with Sheets.
  • 📈 Sales Optimization: Enrich domain lists with emails, phones, LinkedIn URLs, and other data for personalized cold outreach with Apollo, LeadMagic and Prospeo integrations.
  • 💼 LinkedIn Enrichment: Enrich LinkedIn URLs with emails, phones, and other data for personalized cold outreach with Hunter, Apollo, LeadMagic, MailChimp, Gmail and Prospeo integrations.
  • 🔗 Google Indexing: Use GOOGLE_INDEX() to request indexing of your URLs in bulk directly from Sheets.
  • 🎨 SMM at Scale: Generate AI images in bulk with DALL-E and REPLICATE (supports over 100+ AI models for image generation).
  • 🖼️ Extract Data from Images: Use GPT_VISION to extract data from images, PDFs, and more.
  • 🌐 Website Scraping Simplified: Combine AI and built-in functions like WEB_CONTENT(site), WEB_H1, and WEB_PARAGRAPHS to extract and process content from websites.
  • 📱 SMM Made Easy: Create 1000+ posts for LinkedIn, Twitter, Instagram, Reddit, YouTube, and more, in minutes.
  • 🔍 SEO That Works: Access tools for keyword research, search volume, and competitor analysis (alternative to SemRush, Ahrefs).
  • 🔧 Clay Alternative: Simplified and powerful tools for lead and data enrichment.
  • ✍️ Automate Content Creation: Use CREATE_FILE() and REPLACE_TEMPLATE() to generate and store ready-made files in bulk directly from Sheets.
  • ☁️ Seamless Uploads: Upload images and content with Cloudinary integration—no limits, no downtime.

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

Find perfect plan
Annually Monthly

I’m actively adding new features to make this app even better. The price is going up every 30 sales, but if you buy now I will lock in your rate!

Starter
$24.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, o1-mini, o1-preview, o3-mini, o3-mini-high
  • Place enriching tool using Google Maps
  • Youtube Data integration - Search YouTube creators and videos
  • EMAIL_SEND() - Bulk email sending
  • Apollo, Hunter integration - get contacts by a domain
  • Prospeo integration - get emails by a domain
  • Prospeo - get linkedin and emails by a url
  • LeadMagic integration
  • MailChimp integration for sending emails
  • 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, o1-mini, o1-preview, o3-mini, o3-mini-high
  • Place enriching tool using Google Maps
  • Youtube Data integration - Search YouTube creators and videos
  • EMAIL_SEND() - Bulk email sending
  • Apollo, Hunter integration - get emails by a domain
  • Prospeo integration - get emails by a domain
  • Prospeo - get linkedin and emails by a url
  • LeadMagic integration
  • MailChimp integration for sending emails
  • 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
$399 / once
  • More queries: Unlimited
  • Access to all Business features
  • NEW: GPT: o1, o1-mini, o1-preview, o3-mini, o3-mini-high
  • 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 (Hunter, Apollo, Prospeo, LeadMagic 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

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 ","