Skip to main content

Overview of GPT for Sheets

Google logoInstall GPT for Sheets and Docs

GPT for Sheets is a Google Sheets add-on that integrates the power and intelligence of generative AIs directly into the Sheets user interface. Use your favorite AI to generate, rewrite, translate, categorize, extract and otherwise process text in bulk – at machine-powered scale and speed.

GPT for Sheets can execute up to 360 prompts per minute and reliably process up to 200,000 rows in one go.

GPT for Sheets

Use cases​

Here are a few common use cases that you can easily handle with GPT for Sheets:

  • Analyze customer sentiment by categorizing reviews and support requests based on criteria relevant to you.

  • Clean up your customer relationship management (CRM) data with deduplication, recategorization, and reformatting.

  • Generate SEO-optimized product descriptions from product specifications.

  • Grade, score, and qualify sales leads in a consolidated prospecting spreadsheet.

  • Rewrite website copy to conform to copywriting best practices.

  • Translate product descriptions to multiple target languages while observing appropriate localization conventions.

  • Write and understand spreadsheet formulas like a pro.

Features​

GPT for Sheets provides the following main features for using AI in spreadsheets:

Bulk tools​

Bulk tools allow you to run prompts on an entire spreadsheet column at once without writing any formulas. You configure and run bulk tools from the add-on sidebar.

GPT for Sheets provides dedicated bulk tools for selected use cases, such as classification, translation, and web search, as well as a generic bulk tool for custom prompts.

Bulk tools in the sidebar

Use bulk tools if:

  • You want to perform bulk operations on columns (row-by-row).

  • You are working with thousands of rows.

  • You do not want to write formulas.

The following video shows you how to translate text with the Translate bulk tool. You simply select the column you want to translate, enter the target language, and select the column where you want to place the translations. You do not need to define any other settings if the default setup meets your needs.

GPT functions​

GPT functions are custom Sheets functions that allow you to run AI prompts from inside spreadsheet cells. GPT functions work exactly like native Sheets functions in that you can nest them and combine them with other functions.

GPT for Sheets provides dedicated GPT functions for selected use cases, such as classification, summarization, translation, and web search, as well as a generic GPT function for all other use cases. You can define function-specific parameters to further refine how the AI generates responses. You can find a list of all available functions with usage examples in the add-on sidebar.

List of GPT functions

Use GPT functions if:

  • You're comfortable using spreadsheet formulas and functions.
  • You're experimenting and exploring what you can do with GPT for Sheets.
  • You're working with up to a few hundred cells.
  • You need the precise control provided by the GPT function parameters.
  • You need the flexibility of nested formulas or of combining GPT functions with native functions.

The following video shows you how to translate text in bulk with the GPT_TRANSLATE function.

Formula assistant​

The formula assistant allows you to generate Sheets formulas based on plain-language descriptions of what you want to achieve. You can also use the formula assistant to explain existing formulas (in English).

The formula assistant is available in the add-on sidebar, both under Bulk tools and GPT functions.

Formular assistant in the sidebar

Use the formula assistant if:

  • You need help with creating formulas.

  • You want to understand what an existing formula does.

Benefits​

  • Prompt AIs directly from inside your spreadsheets. No more copy-pasting between Sheets and AI chatbots like ChatGPT.

  • Run prompts in bulk, at scale, and at lightning speed. Execute up to 360 prompts per minute and reliably process up to 200,000 rows in one bulk operation.

  • Apply ready-made tools to specific use cases. Translate, classify, extract, reformat, and more.

  • Choose from a large selection of AI models. Use models from OpenAI, Google, Mistral, Anthropic, and Perplexity. You can even connect to local models with Ollama or use your own OpenAI Assistants.

  • Bring your own API key to get more features at reduced cost. You do not need your own key to use GPT for Sheets, but using your own key gives you access to more models, affords you more control and privacy, and you pay a reduced service fee.

What's next​

On this page