Skip to main content

About GPT for Sheets

GPT for Sheets is an AI writer and assistant for Google Sheets. It lets you use ChatGPT directly in Google Sheets. You could think of it as SheetGPT. It is built on top of OpenAI ChatGPT, GPT-3 and GPT-4 models. It also supports Anthropic Claude models.

GPT for Sheets is extremely powerful at:

Working with textWriting text
  • Cleaning data
  • Fixing grammar and spelling
  • Extracting entities
  • Tagging and categorizing
  • Translating
  • Taglines, headlines
  • Ad copy
  • Product descriptions
  • Subject lines, emails
  • Outlines, blogposts

Discover GPT functions​

Install and launch GPT for Sheets to access its functions, tailored for different use cases.

Discover them by typing =GPT_ in a cell.
GPT_LIST, GPT_FILL, GPT_TABLE and GPT_SUMMARIZE are particularly well suited to Google Sheets.

Why use GPT for Sheets instead of ChatGPT?​

ChatGPT is a chatbot interface, which is great to learn and play with GPT. But you probably do most of your work in real document editors like Google Sheets because your data is already in Google Sheets.

Using GPT for Sheets will save you a lot of time by allowing you to:

  • Get many variations quickly
  • Apply prompts to Sheets tabular data and get results as tables
  • Structure your prompts in Google Sheets
  • Save answers in Sheets for easier retrieval
  • Avoid constant copy/pasting in ChatGPT
  • Benefit from all the Google Sheets features, including real-time collaboration
What's next

Create a tagline for an ice-cream shop directly from a Google spreadsheet.

On this page