App Icon
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:June 1, 2023
Works with:
2M+
Overview
GPT for Sheets™ and Docs™ is an AI writer for Google Sheets™ and Google Docs™. It enables you to use ChatGPT directly in Google Sheets™ and Docs™. It is built on top OpenAI ChatGPT, GPT-3 and GPT-4 models. 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.

The default model for all functions is now ChatGPT gpt-3.5-turbo.
Other base models can be chosen, including GPT-4 if you have access.

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

The possibilities of OpenAI's ChatGPT and GPT-3 in your documents are almost endless. 

This add-on brings ChatGPT and GPT-3's 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

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. You only need to pay OpenAI's API cost. You will need to insert your OpenAI 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
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
Reviews
Language:
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?
Yes
No
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?
Yes
No
Profile Picture
Stella Davila
June 5, 2023
This app is incredible. It is saving me so much time and trouble from copy and pasting into my Google doc. I can’t wait to test it for Google sheets. Looking forward to the ideas it will give me right in the Google tools so I don’t have to keep exiting, go to copy and then come back and paste. Or type for that matter! Thank you!! I had no issues connecting it to my paid API account. All I had to do was be patient and let everything update. Cheers!
Is this review helpful?
Yes
No
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?
Yes
No
Profile Picture
Planet Wireless
April 11, 2023
GPT for Sheets is an amazing tool that has simplified the process of generating natural language text from Google Sheets data. The integration with ChatGPT is seamless, and the user interface is user-friendly, making it easy for anyone to use. The customization options available are impressive, allowing users to tailor the generated responses to their specific needs. The tool's ability to learn from user feedback is a significant advantage, improving the quality of the generated text over time. Overall, GPT for Sheets is a game-changer, saving time and increasing efficiency in data analysis. Highly recommended!
Is this review helpful?
Yes
No
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?
Yes
No
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?
Yes
No
Profile Picture
Super Male
May 7, 2023
it was so great i now worship it as some new age God! i also named my first born after the delevoper.
Is this review helpful?
Yes
No
Profile Picture
Joan Margau
April 7, 2023
Started using GPT for Docs and was pleasantly surprised. Excellent responses to my crafted questions relevant to the subject I am writing about. Normally it would take three, or more, hours of research to curate information, document it, and then supplement the text with the research.GPT respoded in less than a minute. I edited and used the response material as I would not use the response verbatim. The GPT response also generated relevant new concepts I had not thought to include. Use it! It works.
Is this review helpful?
Yes
No
Profile Picture
Douglas Ring
March 23, 2023
I recently installed the ChatGPT add-on for Google Sheets™ and Docs™, and I'm genuinely impressed! The installation process took me less than five minutes, and with my API key in hand, I eagerly dived into exploring its capabilities on some test data. I found the demos and documentation to be incredibly helpful and thorough, making it easy for me to navigate my way around the tool. As I poked around out of curiosity, I was delighted to see how powerful and insightful this add-on can be, especially for someone running a solo business with limited time. When I had a question, the developer's prompt response via email reassured me that there's excellent support backing this fantastic tool. ChatGPT is truly a game-changer, enabling users to analyze data and gain insights that would otherwise be challenging to obtain. In today's fast-paced world, adopting innovative tools like ChatGPT can make all the difference in staying ahead. So, don't hesitate! Install ChatGPT for Google Sheets™ and Docs™, and join the ranks of those making history by harnessing the power of artificial intelligence to revolutionize their work.
Is this review helpful?
Yes
No
1-10 of 90
Search
Clear search
Close search
Google apps
Main menu