Use ChatGPT in Google Sheets and Docs
Supports all models: GPT-4 (if you have access), ChatGPT (gpt-3.5-turbo) and GPT-3
- Clean lists, extract entities, convert formats
- Edit, summarize, translate, classify
- Generate ad creative, taglines, subject lines, outlines, blogs, emails
Our GPT functions are perfect for short text in Sheets.
Our Docs integration and presets are great for long form content.
Works with all base and fine-tuned models.
The add-on is free! The only cost is OpenAI.
GPT for Sheets and Docs:
one add-on that works with both
Killer app! https://t.co/melWoHJ38h
— Marc Andreessen (@pmarca) March 6, 2023
Clean lists
GPT for Sheets simple and intuitive's GPT_FILL function makes it easy to quickly clean and standardize any list of data. You only need to show it a few examples of what you want and it will replicate the same format throughout your data set - perfect for mass cleaning!
Generate tags
GPT for Sheets helps you generate product tags quickly, to power your product tags library. Dynamically create custom tags for your products, saving you time in making your products easier to find.
Generate ad copy, taglines, titles
GPT for Sheets can help you create eye-catching, on-brand ad copy, taglines, and subject lines that will engage your customers. Unlock the power of GPT to conveniently and quickly generate compelling marketing content for your business.
Generate a description
GPT for Sheets can help you create high-quality, compelling product descriptions quickly and easily for your entire catalog, directly in your spreadsheet. It makes PIM a dream.
Generate an outline
GPT for Docs can help you quickly generate an outline, saving you time and energy to focus on crafting an engaging, captivating story. Let GPT provide you with the structure and you provide the creativity, to create a blog post outline that will captivate and engage your readers.
Generate a blog post, email, speech
GPT for Docs can generate any kind of copy, short or long, on any topic, in any style, very quickly. 1000 blog posts of 1000 words will cost you roughly $27 in API calls.
Recap a meeting, summarize notes
GPT for Docs can help you save time by automatically creating summaries for your meetings so you can quickly recap important points and action items with your team in efficient and understandable ways.
Rephrase in perfect English
GPT for Docs can rewrite your emails or documents in flawless English. Stop looking unprofessional because of your language skills!
Frequently Asked Questions
- What is ChatGPT?
ChatGPT is an artificial intelligence chatbot developed by OpenAI and launched in November 2022. Its performance at understanding and writing text and code was so far beyond anything that had existed before that it immediately acquired hundreds of millions of users.
- What is the difference between GPT-3, GPT-4 and ChatGPT?
ChatGPT is based on the GPT-3.5-turbo OpenAI model, which has been built upon the GPT-3 family of models but specifically trained for conversational use. GPT-3.5-turbo is roughly 3 times faster than GPT-3. It was made available via API on March 1st, 2023, and at a price 10x cheaper than the best GPT-3 model (Davinci / text-davinci-003).
GPT-4 is the latest ChatGPT model released by OpenAI, improving upon GPT-3.5-turbo. It has better reasoning capabilities to solve complex problems and can take from 6000 to 25000 words of context, which is much larger than the previous limit of 3000 words. It is however slower and significantly more expensive.
Even if ChatGPT GPT-3.5 is typically more verbose and more specifically trained for chat interfaces it is still incredibly good at responding to precise commands, on par with DaVinci. Given its speed and cost advantages over GPT-3 and GPT-4, we have decided to integrate ChatGPT as the default model in all GPT for Sheets and Docs.
The GPT-4 API was released on March 14th, 2023. GPT-4 models are the most recent OpenAI models: with advanced reasoning capabilities and broader general knowledge, GPT-4 models give more synthetic and factual responses than ChatGPT.
- How do I integrate ChatGPT with Google Sheets?
- Install the GPT for Sheets and Docs add-on
- Create a new Google spreadsheet
- Set up your Open API key
- Go to Extensions > GPT for Sheets and Docs > Enable GPT functions
- Enter a GPT function in a cell to start prompting ChatGPT from Google Sheets!
Get more detailed instructions here.
- How do I add ChatGPT to Google Docs?
- Install the GPT for Sheets and Docs add-on
- Create a new Google document
- Set up your Open API key
- Go to Extensions > GPT for Sheets and Docs > Launch sidebar
- Enter a prompt in the sidebar or in the document to start prompting ChatGPT from Google Docs!
Get more detailed instructions here.
- Can ChatGPT help with Google Sheets?
ChatGPT can help you with the following tasks in Google Sheets:
- Data preparation: data cleaning, extraction, mapping, formatting, small edits
- Analysis: summarization, categorization, classification
- Text generation: writing, translating, editing
GPT for Sheets will help you call ChatGPT in bulk in Google Sheets so that you can apply prompts to many items at once or in sequence.
- How do I integrate GPT-3 or GPT-4 with Google Sheets?
The GPT for Sheets and Docs extension lets you choose the model you want to use for each GPT function. As a result, you can select a GPT-3 or GPT-4 model if you prefer that over the ChatGPT model.
To select a GPT-3 or GPT-4 model in Sheets, specify the model technical name (e.g. “text-davinci-003” or “gpt-4”) as the last parameter of the GPT function.
- How do I add GPT-3 or GPT-4 to Google Docs?
The GPT for Sheets and Docs extension lets you choose the model you want to use for each GPT function. As a result, you can select a GPT-3 or GPT-4 model if you prefer that over the ChatGPT model.
To select a GPT-3 or GPT-4 model in Docs, select the model technical name (e.g. “text-davinci-003” or “gpt-4”) in the models dropdown in the sidebar.