GPT for Google Sheets, Docs AI, Slides, Forms

GPT for Google Sheets

Leverage the GPT for Google Sheets to seamlessly incorporate the power of GPT-3.5 and GPT-4 directly into your Google Sheets. Works out of the box. No need for API keys.

Find perfect plan
Annually Monthly
Starter
$15.99/ per month
  • 500 queries / month
  • No need for API keys
  • Support 40+ 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..
  • No need API keys
  • Online Support
  • Weekly feature updates
Professional
$11.17/ per month
Billed $133.99 annually
  • Save 30%
  • 500 queries / month
  • Access to all features
  • No need for API keys
  • Support 40+ 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..
  • No need API keys
  • Online Support
  • Weekly feature updates
⭐⭐⭐⭐⭐ Rated 4.8/5 out of 200+ reviews and 700K+ installs
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

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")
Localization In some Google Sheets localization, you need to use ";" to separate parameters instead of ","

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_TRANSLATE function to translate your text into 40+ 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 ","