About GPT for Sheets

GPT for Sheets, built on top of gpt-3.5 and gpt-4 models, lets you use ChatGPT directly within a familiar Sheets environment.

It is extremely powerful at:

• Working with text: Translating, extracting entities, tagging and categorizing, correcting grammar and spelling, and cleaning data.
• Writing text: Creating taglines, headlines, ad copy, product descriptions, subject lines for emails, and drafts for blog posts.

GPT for Sheets provides two key features to improve efficiency: bulk tools for easy, large-scale tasks and GPT functions for flexible, complex operations.

Discover bulk tools

Bulk tools are easy to use and can handle large volume runs of simple prompts. You can run any type of operation on a whole column at once, without writing any formula.

Translation is a perfect use case for bulk tools: just input which column to translate, into which language, and in which column to write the results.

Discover GPT functions

GPT functions allow complex operations that can be chained together for maximum flexibility. 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

Install GPT for Sheets.