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:October 2, 2023
Works with:
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: (learn how to use GPT for work)
How to set up:
Video tutorials:

Mentioned by Marc Andreessen as a "killer app":

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_TRANSLATE to translate your spreadsheet content
GPT_CLASSIFY to classify spreadsheet content into a single category
GPT_EXTRACT to extract entities from your Sheets™ data
GPT_SUMMARIZE to summarize your spreadsheet content
GPT_FORMAT to sanitize your spreadsheet data into the same format
GPT_EDIT to edit your spreadsheet content
GPT_TAG to apply tags to your spreadsheet content
GPT_MATCH to match values from two columns
GPT_SPLIT to split text semantically, such as by section, paragraph, sentence, customer…
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

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

- 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:

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, 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
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
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Home Theater Huntsman
April 24, 2023
not working. Your OpenAI API key is invalid or has been revoked. Please make sure that you copied it correctly, or follow our guide to create a new API key.". I cant use it
Is this review helpful?
Profile Picture
Paula Ocampo
April 4, 2023
For a number of different keys I created it says "Your OpenAI API key is invalid or has been revoked. Please make sure that you copied it correctly, or follow our guide to create a new API key.". I cant use it
Is this review helpful?
Profile Picture
Simran D
August 3, 2023
GPT for Sheets is an absolute game-changer! This user-friendly tool harnesses AI power to simplify complex data tasks in Google Sheets. Its natural language processing, data analysis, and cleansing capabilities are spot-on, providing quick, accurate results. With GPT for Sheets, I saved time and gained valuable insights effortlessly. Highly recommended!
Is this review helpful?
Profile Picture
Peter Sottile
July 26, 2023
I tried using the GPT_CLASSIFY function to classify menu items in restaurants into about 200 different food categories. Even doing one item at a time the output would get stuck in loading and could not produce a result, except for a few items. Meanwhile the GPT api fees stacked up while the prompt was still loading and never producing a result.
Is this review helpful?
Profile Picture
June 14, 2023
In conclusion, caring for senior dogs requires our attention, understanding, and proactive efforts. By addressing their unique needs, such as regular vet check-ups, balanced nutrition, exercise, and mental stimulation, we can enhance their quality of life and ensure a happy and fulfilling aging process. Modifying the home environment to accommodate their comfort, recognizing and managing age-related health issues, and providing a calm and stress-free atmosphere further contribute to their well-being. Remember, our senior dogs have given us unconditional love and companionship throughout their lives, and it's our responsibility to reciprocate by offering them the care and attention they deserve in their golden years. Let us celebrate the beautiful bond we share with our senior dogs and cherish every moment we have with them. Share your own experiences and tips for caring for senior dogs in the comments below, and let's continue to learn from each other and make a positive difference in the lives of our beloved furry friends.Certainly! Here are some frequently asked questions (FAQs) related to caring for senior dogs and their answers: Q1: How often should I take my senior dog to the veterinarian for check-ups? A1: It is recommended to take your senior dog for regular check-ups at least twice a year. Regular veterinary visits help monitor their overall health, detect any potential issues early on, and ensure they receive the necessary preventive care. Q2: What are some signs that my senior dog may be experiencing arthritis? A2: Signs of arthritis in senior dogs include difficulty getting up, stiffness, limping, reluctance to engage in physical activities, and changes in gait. If you notice any of these signs, consult with your veterinarian for proper diagnosis and treatment options. Q3: How can I help my senior dog maintain a healthy weight? A3: To help your senior dog maintain a healthy weight, feed them a balanced and portion-controlled diet based on their specific nutritional needs. Avoid overfeeding and provide regular exercise that suits their abilities. Consult with your veterinarian for personalized guidance. Q4: Are there any specific dietary recommendations for senior dogs? A4: Senior dogs often have different nutritional requirements. They may benefit from a diet that is lower in calories but still provides adequate protein, healthy fats, and easily digestible carbohydrates. Consider discussing specialized senior dog food or supplements with you
Is this review helpful?
Profile Picture
Ernesto Cuadros-Vargas
August 12, 2023
=GPT_Translate() function does not work. I just followed your example. It says that function does not exist.
Is this review helpful?
Profile Picture
Ralf Seybold
June 29, 2023
Had some problems with copied sheets. Well worthy tool that I like. But you need to setup tokens at OPEN AI. This makes a small answer rapidly to 5 USD. But if you know what you want to do, this can be of much help. If they reduce the problems with sheets, then this is really great.
Is this review helpful?
Profile Picture
Ester Joy Agudo
May 14, 2023
GPT for Sheets and Docs are both very helpful plug-ins that you'll need if you're looking for a way to integrate GPT into your workflow! If you want to streamline processing your records and creating content at scale, this app is for you. There are neat formulas you can use to replace the usual complicated built-in ones (e.g., Extract formula). There's a bit of a learning curve, but with all the tutorials and videos available, you can easily learn how to use the plug-ins so you get closer to your goal of working smarter, and not harder. Yes, there are some glitches and limitations, but apps aren't perfect. I also really appreciate how their dev team took the time to respond promptly to my query about a specific error. Thank you so much for creating this!
Is this review helpful?
Profile Picture
Shiva Kakkar
March 3, 2023
I just keep getting an error when trying to set the API key "ScriptError: Authorization is required to perform that action." Can you look into it?
Is this review helpful?
Profile Picture
Anno Torr
April 21, 2023
GPT for Sheets™ is such a great app! I’ve used it to create a rather complex Google Sheet of information for content creators and it is working brilliantly! Stan's training videos helped tremendously in showing how to use it, and I found it easy to learn and tweak prompts to improve the results. I found it quick and easy to install and set up and when I submitted a query via their form, Stan replied within a day and was very helpful. Going forward, this really reassured me of excellent support when I need it. I’m now using this Chrome extension to build a second Google sheet/ChatGPT integration, helping me create products I didn’t even dream of just a month ago!! I have yet to try the G. Docs integration but am looking forward to that with great eagerness! Thanks, Stan.
Is this review helpful?
1-10 of 105
Clear search
Close search
Google apps
Main menu