ChatGPT in Google Sheets™ and Docs™. Get the full power of AI for inspiration data cleaning, classification, extraction, translation, edition, summarization, writing directly in your Sheets™ and Docs™
Listing updated:September 26, 2023
Works with:
4M+
Overview
GPT for Sheets™ and Docs™ is an AI writer for Google Sheets™ and Google Docs™. 
It enables you to use ChatGPT and other generative AI models directly directly in Google Sheets™ and Docs™. 

Models available include OpenAI GPT-3.5 and GPT-4 as well as Anthropic Claude. 
You can use it for all sorts of tasks on text: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining, etc 
If ChatGPT was GPT for Chat, you can think of GPT for Sheets™ as SheetGPT.

In Sheets, the default model for all functions is now gpt-3.5-turbo.
In Docs, the default model for all functions is now gpt-3.5-turbo-16k.
You can select the model you want depending on cost, latency and capability in the sidebars

Website: https://gptforwork.com (learn how to use GPT for work)
How to set up: https://gptforwork.com/help/gpt-for-sheets/setup/create-openai-api-key
Video tutorials: https://www.youtube.com/@gptforwork/playlists

Mentioned by Marc Andreessen as a "killer app": https://twitter.com/pmarca/status/1632855301648183296?s=20

This add-on brings ChatGPT and Claude AI power to Google Sheets™ by exposing many simple custom functions: 
GPT to get the result of ChatGPT in a single cell
GPT_LIST to get multiple result in a column (one item per cell)
GPT_TABLE to get a table of items from a prompt
GPT_FILL to fill a range from examples
GPT_FORMAT to sanitize your spreadsheet data into the same format
GPT_EXTRACT to extract entities from your Sheets™ data
GPT_EDIT to edit your spreadsheet content
GPT_SUMMARIZE to summarize your spreadsheet content
GPT_CLASSIFY to classify spreadsheet content into a single category
GPT_TAG to apply tags to your spreadsheet content
GPT_TRANSLATE to translate your spreadsheet content
GPT_CONVERT to convert from table to csv to html to json to xml, etc
GPT_MAP to map values from two columns
GPT_SPLIT to split text semantically, such as by section, paragraph, sentence, customer…

This add-on will help you achieve some tasks such as:
- generating blogposts ideas
- writing whole paragraphs or procedures
- cleaning up lists of names, adresses, emails or companies, dates, currency amounts, phone numbers
- classifying lists of reviews with sentiment analysis or feature categorization
- summarizing reviews
- writing responses to online comments
- trying different versions of a prompt quickly
- working on ad copy (PPC, Google ads, Facebook ads)
- working on SEO metadata (titles, descriptions)
- working on landing page copy
- managing and cleaning product catalogs for e-commerce stores (Shopify and Amazon)
- translations

Docs:
- outlining a piece of content
- expanding a piece of content
- writing emails or blogs
- summarizing notes
- translating content
- changing the style of content

In addition, this add-on will let you experiment easily with hyperparameters:
- temperature
- model (including fine-tuned models in Sheets™)
- maxTokens

This add-on is completely free to use while in beta. You only need to pay OpenAI's or Anthropic's API cost. You will need to insert your OpenAI or Anthropic api key. This is not covered by ChatGPT Plus/Pro subscriptions.
All the details are on our website: https://gptforwork.com

Please note that we recommend you write your letters to your grandmother by yourself with pen and paper, the slides are just provided as a cheeky examples of what can be achieved with this tool :)

This product is brought to you by talarian.io, maker of YAMM, Form Publisher and Awesome Table, which are some of the most popular add-ons of the Google Workspace Marketplace.

Talarian is not affiliated with OpenAI or Anthropic
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
GPT for Sheets™ and Docs™ will ask for the permissions shown below. Learn more
GPT for Sheets™ and Docs™ will need access to your Google account
This will allow GPT for Sheets™ and Docs™ to :
View and manage documents that this application has been installed in
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu