Skip to main content

Questions for Sheets

What does GPT for Sheets mean?

GPT for Sheets means generative pre-trained transformers for Google Sheets. Generative pre-trained transformers are the type of models that work best with textual content. And have been popularized by ChatGPT. If ChatGPT is GPT for Chat, then GPT for Sheets is SheetGPT.

How can I use ChatGPT from Google Sheets?

After you’ve installed the GPT for Sheets and Docs add-on:

  1. Create a new Google spreadsheet.
  2. Set up your API key if not done yet.
  3. Enter a GPT function in a cell.
Where can I find the list of available GPT functions?

The list along with full documentation and video tutorials is available in our reference page.

Who can use the GPT functions in my Google spreadsheet?

Anybody who is an editor can use the GPT functions. All usage will incur to the API key of the owner/creator of the spreadsheet.

What do you do with the data in my documents?
  • We log the prompt parameter strictly for product improvement purposes.
  • We don't log the value parameter.
  • The full set of parameters is sent to the OpenAI API to get the response.
  • The rest of your spreadsheet data is never read nor stored on our servers.

More details in our Privacy Policy and DPA.

Is the GPT for Sheets and Docs extension free to use?

Yes, the extension itself is free to use, and the existing basic functionality (Sheets GPT functions and basic Docs integration) will remain free for API key users. We will introduce some paid features in the future.

This extension is built on the OpenAI API which is not free though it has a free trial.

Your usage of the OpenAI API through our add-on is not free, and its pricing is entirely decided by OpenAI. However, it is very cheap since the new gpt-3.5-turbo model was released. You can easily estimate your costs on our pricing calculator.

You will need your own OpenAI API key to use this extension, and you will need set up a paid account with them if your free trial is expired, inactive or not working.

Warning

Please note that ChatGPT Plus/Pro subscriptions don't cover the use of OpenAI APIs.

My OpenAI API free trial is expired or inactive even though I've never used it...

You can double check if it is indeed expired by trying to run a prompt on the official playground.

Your OpenAI free trial will not work if you have already used the phone number with which you verified your OpenAI account for another OpenAI account. Creating a new account with a new phone number should provide you with a working free trial.

Warning

ChatGPT Plus/Pro subscriptions don't cover the use of OpenAI APIs.

I have a ChatGPT Plus subscription, why do I need to set up a paid OpenAI account?

Unfortunately ChatGPT Plus subscriptions do not include paid access to OpenAI APIs or to the OpenAI playground.

You will have to set up a paid account in the OpenAI platform dashboard even if you have a ChatGPT Plus subscription.

How can I monitor and control OpenAI API costs?

The OpenAI API pricing model is Pay as you go. There is no upfront or monthly cost.

You can review your usage in the OpenAI dashboard usage section.

You can easily set a spending limit in the OpenAI dashboard billing section.

The OpenAI API is very cheap since the new gpt-3.5-turbo model was released. You can easily estimate your costs on our pricing calculator.

Which GPT models can I use?

GPT for Sheets and Docs works with all base text OpenAI models (including GPT-4 if you have access) and fine-tuned models. The default model of the extension is text-davinci-003 as it offers the best compromise by far between costs, speed and quality.

Which natural languages can I use?

OpenAI’s GPT models work in many languages, but deliver best results in English. All we can say is try it. It is usually better to prompt in the language you want the response to be. In any case, avoid mixing languages in a prompt.

Who are these extensions made by?

These extensions are made by Talarian. Talarian is a profitable company established in 2015, specialized in Google add-ons and Microsoft add-ins. There are around 40 people working at Talarian.

Talarian is ISO27001 certified.

How do you keep my OpenAI API key secure?

Your API key never touches our servers. It is stored in your Google account in a dedicated secure container. Once set, it won’t be visible to anyone.

Who can set up an OpenAI API key?

You can set your API key only on a file that you own, or that you created if it is stored in a Shared Drive. You only need to set it once.

What permissions are required by the Google add-on?

The add-on requires the following Google Drive permissions:

  • View and manage documents that this application has been installed in
  • View and manage spreadsheets that this application has been installed in
PermissionReason
View and manage documents that this application has been installed inWe need to be able to inject GPT responses in the Google documents that you launch the add-on in.
View and manage spreadsheets that this application has been installed inWe need to be able to inject GPT responses in the Google spreadsheets that you launch the add-on in.
How do I install the GPT for Sheets and Docs add-on?

Install from the Google Workspace Marketplace:

  1. Go to the installation page.
  2. Click on the blue Install button.
  3. Follow the steps until the end.

Learn more: Install GPT for Sheets and Docs

What is the difference between GPT-3, ChatGPT and GPT-4?

ChatGPT is based on the OpenAI model gpt-3.5-turbo.

OpenAI APIs provide access to the ChatGPT model in addition to GPT-3 models, which are less verbose, and sometimes easier to prompt for specific tasks and formats. GPT for Sheets and Docs offers all those models, and defaults to ChatGPT as it is the cheapest and fastest model with quality comparable to the best GPT-3 model (text-davinci-003).

Now, OpenAI APIs also provide access to the GPT-4 models. They can follow complex instructions in natural language and deal with longer text content than GPT-3 and GPT-3.5 models. GPT-4 models are however much more expensive than ChatGPT.

How do I get support?

We recommend checking our troubleshooting errors page.

If it doesn’t help, please let us know by submitting a support request so we can assist you further.