Submit a request

Check your "Spam" folder in case our responses go to Spam. You can create a new filter (Filters and Blocked Addresses) in your Gmail settings for our domain gptforwork.zendesk.com and select "Never send it to Spam".
For more information, please refer to this user-friendly tutorial.

Frequently Asked Questions

Problems

I bought a pack but my balance is empty

Problem: You have purchased a pack in GPT for Excel, but your balance is empty.

Solution:

Click on your balance in GPT for Excel and check that you are using the Microsoft account with which you have purchased your pack.

My packs have disappeared

Problem: You have purchased packs and used GPT for Excel but now all your packs have disappeared from the usage tracking screen.

Solution:

Click on your balance in GPT for Excel and check that you are using the Microsoft account with which you have purchased your packs.

Sidebar is blank, or fails to load
Error loading Add-Ins

Problem: GPT for Excel sidebar fails to load, or remains blank.

Solutions:

  • In the desktop version of Excel, open the right sidebar menu (Windows) or click the info icon (Mac), then choose Reload.
  • Restart Excel, create a new workbook and launch the add-in again by clicking GPT for Excel Word in the Home tab.
My balance is going down too fast

Problem: Your consumption is higher than you expected and you wish to spend less money on GPT function executions.

Solutions:

  • Estimate your costs with the Token counter before executing GPT functions on a large number of cells.

    token counter screenshot
  • Select a cheaper model after comparing their costs with the Usage cost calculator. Click Buy a pack from the sidebar menu to access it.

    calculator screenshot
  • Set up your own OpenAI API key to save 50% on total cost.

I want to uninstall

Problem: You are not using the add-in in Excel or in Word, and you want to uninstall it.

Solution:

To remove the add-in from Excel and Word, follow the steps described in our uninstallation article.

I can't sign in after installing

Problem: You have installed GPT for Excel and you have trouble signing in with Microsoft.

sign in screenshot

Solutions:

  • Check which versions of Excel and which browsers are supported by this extension.

  • Try using the web version of Excel instead of the desktop version.

  • Try using GPT for Excel in a private/incognito window.

I've entered my OpenAI API key and it's not working

Problem: You have entered an OpenAI API key in the GPT for Excel sidebar and you cannot use it.

Solutions:

  • While you have entered your OpenAI API key, you also need to purchase a pack in GPT for Excel to use GPT functions within a Microsoft Excel workbook. Learn more.
  • If you have purchased a pack in GPT for Excel and it's still not working, then you can check if your OpenAI API key is valid by trying the solutions in Your API key is too limited

Errors

Add-in not supported

This add-in is only supported with your Microsoft 365 subscription license and is not supported with your Office license.

The following table lists the minimum versions of Microsoft Excel supported by the GPT for Excel add-in, according to your version of Office.

Office on Windows
  • - Microsoft 365 subscription
  • - retail perpetual Office 2016 and later
Office on Windows
(volume-licensed perpetual)
Office on Mac Office on iPad Office on the web Office Online Server
Excel Version 2002 (Build 12527.20092) Excel 2021 Version 2108 (Build 12527.20092) Excel 16.35 Not supported Supported Not supported
Invalid name

#NAME? Invalid Name Error. The formula contains unrecognized text.

invalid name error screenshot

Problem: The GPT functions aren't recognized by Excel.

Solutions:

  • Check that GPT for Excel is installed on the current Microsoft account.

  • Click GPT for Excel Word in the Home tab to enable the GPT functions.
  • If the problem persists, try activating the add-in (the experience might be slightly different for Mac users):
    1. Click Add-ins in the Home tab.

    2. Click More Add-ins.

    3. Select GPT for Excel Word in the My Add-ins tab.

    4. Click Add.

    5. Click GPT for Excel Word in the Home tab and click Retry errors in GPT for Excel sidebar.

  • Use the add-in on the Web version of Excel (see supported versions).
Invalid parameter

Error: Invalid xxx parameter.

Problem: The error indicates a formatting issue or an unreadable parameter within the formula.

Solutions:

  • Check that you have quotation marks around your prompt if it is not in a cell:
    =GPT("hello")
    =GPT(A1)
    =GPT(hello)
  • Check that your parameters are in the correct order. See the function list.
  • Check that all parameters (even optional ones) are added as empty when there is another parameter coming after them:
    GPT_TRANSLATE(A2, "french", , "Avoid passive voice")
  • Check that you are using the right parameter separator for your locale: , or ;?
  • Check that you are using the correct number format for temperature for your locale: 0.8 or 0,8?
Error in value

Error in Value. A value used in the formula is of the wrong data type.

wrong data type screenshot

Problem: Your formula can't be interpreted by OpenAI.

Solutions:

  • Check that you have quotation marks around your prompt if it is not in a cell:
    =GPT("hello")
    =GPT(A1)
    =GPT(hello)
  • Check that your parameters are in the correct order. See the function list.
  • Check that all parameters (even optional ones) are added as empty when there is another parameter coming after them:
    GPT_TRANSLATE(A2, "french", , "Avoid passive voice")
  • Check that you are using the right parameter separator for your locale: , or ;?
  • Check that you are using the correct number format for temperature for your locale: 0.8 or 0,8?
Formula parse error

Problem: Your formula can't be interpreted by Microsoft Excel.

Solutions:

  • Check that you have quotation marks around your prompt if it is not in a cell:
    =GPT("hello")
    =GPT(A1)
    =GPT(hello)
  • Check that your parameters are in the correct order. See the function list.
  • Check that all parameters (even optional ones) are added as empty when there is another parameter coming after them:
    ✅ GPT_TRANSLATE(A2, "french", , "Avoid passive voice")
  • Check that you are using the right parameter separator for your locale: , or ;?
  • Check that you are using the correct number format for temperature for your locale: 0.8 or 0,8?
Required parameter in GPT function

Please set required parameter in GPT_XX() function

Problem: One of the parameters in your GPT formula is required and hasn't been set.

Solution:

Check which parameters are required for the GPT function you are using and adjust the formula as needed.

Your API key is too limited

Problem: If your OpenAI organization is using a free trial, the rate limits of your API key will be too low to be used in GPT for Excel.

api key too limited screenshot

Solutions:

If you are not using an OpenAI free trial account

Check that your OpenAI organization is correctly set in GPT for Excel:

  1. Select API keys from GPT for Excel sidebar menu.
  2. Enter your OpenAI organization ID in the format org-xxxxxxxxxxx and click Save. This step is crucial if you are part of multiple organizations, as it ensures that billing for usage in GPT for Excel is attributed to the appropriate account.

Important Note: To check if the organization you are using has remaining credits, follow these steps:

  1. Click on your user icon in the bottom left corner and select the appropriate organization.

  2. Go to Billing settings to check if you have remaining credits.

If you are using an OpenAI free trial account

  • Option 1: Continue without and API key. This option is suitable for immediate use and if using your API key is not a priority. Select Continue without API key to clear it from GPT for Excel. Learn more about billing.
  • Option 2: Buy OpenAI credits for increased API rate limits.
    1. Go to OpenAI billing settings.
    2. Add your payment details.
    3. Purchase OpenAI credits starting at $5 to upgrade your account from the Free tier to Tier 1. This change increases your rate limit from 3 to 3,500 requests per minute with the gpt-3.5-turbo model. Note that TPM (Tokens Per Minute) limitations still apply, and further tier progression is necessary for greater TPM access.
    4. Wait up to 30 minutes for the new API key limit to become active.
OpenAI API not working with your key
openai api not working screenshot

Problem: While your OpenAI API key is recognized as valid, it is not working due to one or more of the following reasons:

  • You haven't purchased OpenAI credits (if you're on a prepaid billing plan).

  • You haven't added a payment method to your OpenAI account (if you're on a legacy monthly billing plan).

  • Your default OpenAI organization isn't correctly set.

  • You have added a payment method or purchased OpenAI credits within the last 30 minutes and you still get this message.

Solutions:

  1. Go to OpenAI billing settings.

  2. Add payment details.

  3. Purchase OpenAI credits.

  4. Go to API keys in GPT for Excel sidebar menu to ensure your OpenAI organization is correctly configured.

  5. Wait up to 30 minutes for your OpenAI API key to become active.

Solution for immediate use:

If immediate use is needed and using your API key is not a priority, select Continue without API key to clear it from GPT for Excel. Learn more about billing.
Requests per day limit reached

You have reached your xxx requests per day limit

Problem: You have reached your limit of requests per day (RPD) for the selected model.

Solutions:

Tokens per day limit reached

You have xxx / xxx tokens per day left

Problem: You have reached your limit of tokens per day (TPD) for the selected model.

Solutions:

Questions

Is GPT-4o supported?

Yes, GPT-4o is supported with and without an API key.

Can I use my custom GPT and Assistants API?

Unfortunately the current OpenAI API, used by GPT for Excel, does not support these features.

Which browsers are compatible with GPT for Excel?

GPT for Excel is compatible with the following browsers:

  • Microsoft Edge on Windows and Chrome are highly recommended for the best experience

  • Firefox

  • Safari on Mac

Is GPT for Excel connected to the web?
Yes, GPT for Excel can search the web to provide up-to-date information with the GPT_WEB function, built on Perplexity AI's online models. However, other functions in GPT for Excel are not web-connected.
How is my data processed? Is it used to train models?
  • We do not read or store any data from your workbook that you do not use as an input.
  • We send your inputs to the relevant AI provider’s API and we display the resulting outputs in your workbook.
  • If you use a model with your own API key, we do not log or store any of the inputs submitted or outputs received.
  • If you use a model without your own API key, we log all the inputs and outputs for support purposes for a duration of 30 days. We then store them for 5 years to comply with applicable law, enforce our terms and policies, keep our Service safe and for product improvement purposes (excluding the training of any language model).
  • Whether you use a model with or without your own API key, Talarian does not use your inputs and outputs to train language models.

To check the AI provider’s models available with or without your own API key, please see our list of supported models.

More information on how we use your data in our Terms of Service, Privacy Policy and DPA.

More information on AI providers’ use of content is available on their relevant terms, as detailed in our Terms of Service.

Problems

I bought a pack but my balance is empty

Problem: You have purchased a pack in GPT for Word, but your balance is empty.

Solution:

Click on your balance in GPT for Word and check that you are using the Microsoft account with which you have purchased your pack.

My packs have disappeared

Problem: You have purchased packs and used GPT for Word but now all your packs have disappeared from the usage tracking screen.

Solution:

Click on your balance in GPT for Word and check that you are using the Microsoft account with which you have purchased your packs.

My response is cut or incomplete

Problem: The response you get from GPT for Word seems truncated.

Solution: Models have a maximum token limit, which is the maximum total number of tokens that can be used in both the input and the response. This means models may not provide complete responses to long queries or when a large portion of text is selected as input. Check the token count for your input in GPT for Word sidebar.

tokens left image

To stay within the token limit, click on Clear chat to delete your chat history or break up your work into smaller parts. You can also select a model with a higher limit (context window).

I want to uninstall

Problem: You are not using the add-in in Word or Excel, and you want to uninstall it.

Solution: To remove the add-in from Word and Excel, follow the steps described in our uninstallation article.

Errors

Your API key is too limited

Problem: If your OpenAI organization is using a free trial, the rate limits of your API key will be too low to be used in GPT for Word.

api key too limited screenshot

Solutions:

If you are not using an OpenAI free trial account

Check that your OpenAI organization is correctly set in GPT for Word:

  1. Select API keys from GPT for Word sidebar menu.
  2. Enter your OpenAI organization ID in the format org-xxxxxxxxxxx and click Save. This step is crucial if you are part of multiple organizations, as it ensures that billing for usage in GPT for Word is attributed to the appropriate account.

Important Note: To check if the organization you are using has remaining credits, follow these steps:

  1. Click on your user icon in the bottom left corner and select the appropriate organization.

  2. Go to Billing settings to check if you have remaining credits.

If you are using an OpenAI free trial account

  • Option 1: Continue without and API key. This option is suitable for immediate use and if using your API key is not a priority. Select Continue without API key to clear it from GPT for Excel. Learn more about billing.
  • Option 2: Buy OpenAI credits for increased API rate limits.
    1. Go to OpenAI billing settings.
    2. Add your payment details.
    3. Purchase OpenAI credits starting at $5 to upgrade your account from the Free tier to Tier 1. This change increases your rate limit from 3 to 3,500 requests per minute with the gpt-3.5-turbo model. Note that TPM (Tokens Per Minute) limitations still apply, and further tier progression is necessary for greater TPM access.
    4. Wait up to 30 minutes for the new API key limit to become active.
OpenAI API not working with your key
openai api not working screenshot

Problem: While your OpenAI API key is recognized as valid, it is not working due to one or more of the following reasons:

  • You haven't purchased OpenAI credits (if you're on a prepaid billing plan).

  • You haven't added a payment method to your OpenAI account (if you're on a legacy monthly billing plan).

  • Your default OpenAI organization isn't correctly set.

  • You have added a payment method or purchased OpenAI credits within the last 30 minutes and you still get this message.

Solutions:

  1. Go to OpenAI billing settings.

  2. Add payment details.

  3. Purchase OpenAI credits.

  4. Go to API keys in GPT for Word sidebar menu to ensure your OpenAI organization is correctly configured.

  5. Wait up to 30 minutes for your OpenAI API key to become active.

Solution for immediate use:

If immediate use is needed and using your API key is not a priority, select Continue without API key to clear it from GPT for Word. Learn more about billing.

Questions

How do I install the GPT for Word add-in?
Install from Microsoft AppSource:
  1. Go to the installation page.
  2. Click Open in Word.
  3. Follow the steps until the end.

Learn more in Install GPT for Word

I have installed GPT for Word, how do I start?

Now that GPT for Word is installed, you can launch it from Microsoft Word Home tab and start chatting with your Word documents. Learn more in our Get started.

Is GPT-4o supported?

Yes, GPT-4o is supported with and without an API key.

Is the GPT for Word add-in free to use?
No, there is no free plan. There is a free trial.
Do I need an API key?
No. This add-in offers models that do not require an API key. See the full list here.
How can I ask questions about my document?
Select some text or the whole document for GPT for Word to take it into account along with your questions in the chat message.
How is my data processed? Is it used to train models?
  • We do not read or store any data from your document that you do not use as an input.
  • We send your inputs to the OpenAI API and we display the resulting outputs in your document.
  • We do not log or store any of the inputs submitted or outputs received.
  • Talarian does not use your inputs and outputs to train language models.

To check the AI provider’s models available with or without your own API key, please see our list of supported models.

More information on how we use your data in our Terms of Service, Privacy Policy and DPA.

More information on AI providers’ use of content is available on their relevant terms, as detailed in our Terms of Service.

Can I use my custom GPT and Assistants API?

Unfortunately the current OpenAI API, used by GPT for Word, does not support these features.

Which versions of Word are supported by this add-in?
Office on Windows
  • - Microsoft 365 subscription
  • - retail perpetual Office 2016 and later
Office on Windows
(volume-licensed perpetual)
Office on Mac Office on iPad Office on the web Office Online Server
Word Version 2205 (Build 15202.10000) Not supported Word 16.61.401.0 Not supported Supported Not supported
Which browsers are compatible with GPT for Word?
GPT for Word is compatible with the following browsers:
  • Microsoft Edge on Windows and Chrome are highly recommended for the best experience
  • Firefox
  • Safari on Mac

Problems

I bought a pack but my balance is empty

Problem: You have purchased a pack in GPT for Sheets, but your balance is empty.

Solution:

Click on your balance in GPT for Sheets and check that you are using the Google account with which you have purchased your pack.

My packs have disappeared

Problem: You have purchased packs and used GPT for Sheets but now all your packs have disappeared from the usage tracking screen.

Solution:

Click on your balance in GPT for Sheets and check that you are using the Google account with which you have purchased your packs.

Sidebar is blank

Problem: GPT for Sheets sidebar fails to load, or remain blank.

Solution:

  1. Open GPT for Sheets in a Chrome Incognito window.
  2. If the sidebar loads successfully, check the following:
    • Ensure that you are not using multiple Google accounts in the same Chrome session. If you are, create a new profile using this guide.
    • Clear the cache and cookies on your browser.
    • Disable any extension on your regular browser that may be preventing GPT for Sheets from launching. You can troubleshoot this by disabling one by one the extensions, reloading your Google spreadsheet and trying to launch the sidebar again.

If the problem persists, please let us know by submitting a support request.

Formulas are reloaded when I open, reload or edit the spreadsheet

Problem: Google Sheets automatically reloads all formulas every few hours. This includes GPT formulas and can lead to unexpected costs and result changes.

Important note: Sorting, filtering, moving columns or rows will reload ALL formulas and generate unexpected costs. Replace formulas with values before moving things around.

Solution:
GPT for Sheets offers a variety of options to control GPT formulas. These options vary based on the model in use and your preference for a temporary or permanent solution:

My balance is going down too fast

Problem: Your consumption is higher than you expected and you wish to spend less money on GPT function executions.

Solutions:

  • Estimate your costs with the Token counter before executing GPT functions on a large number of cells.
    token counter calculator
  • Select a cheaper model after comparing their costs with the Usage cost calculator. Click Buy a pack from the sidebar menu to access it.
  • Set up your own OpenAI API key to save 50% on total cost.
I have entered my OpenAI API key and it's not working

Problem: You have entered an OpenAI API key in the GPT for Sheets sidebar and you cannot use it.

Solutions:

  • While you have entered your OpenAI API key, you also need to purchase a pack in GPT for Sheets to use GPT functions within a Google spreadsheet. Learn more.
  • If you have purchased a pack in GPT for Sheets and it's still not working, then you can check if your OpenAI API key is valid by trying the solutions in Your API key is too limited.
I get charged when I'm not using GPT for Sheets

Problem: Google Sheets automatically reloads all formulas every few hours. This includes GPT formulas and can lead to unexpected costs.

Solution:
GPT for Sheets offers a variety of options to control GPT formulas. These options vary based on the model in use and your preference for a temporary or permanent solution:

Response is cut or incomplete

Problem: The response you get seems to be incomplete.

Solution:
You need to increase the maximum response size. Learn more here.

Functions are stuck on "Loading"

Problem: GPT functions fail to execute and remain in a loading state.

Functions sometimes get stuck on loading for unknown reasons, it is a bug in Google Sheets/Google Apps Script, as per the official issue tracker. In most cases, functions start working again within 24 hours.

Solution:
The workarounds below should be tried in order:

  1. Execute a random native formula (such as SUM or CONCAT) in a blank cell, and delete it after.
  2. Delete the content of the cell and undo the deletion.
  3. Refresh the spreadsheet.
  4. Make a copy of the spreadsheet. Pause the original spreadsheet to avoid incurring unexpected costs if it suddenly gets unstuck.
Menu only shows "Help"

Problem: When you click Extensions > GPT for Sheets and Docs, the only option you see is Help. It may be due to accessing the Extensions menu too quickly after opening your document or spreadsheet.

Solution:
Refresh your page, wait 30 seconds, then try to access the Extensions menu again.

Errors

Exceeded maximum execution time

Exceeded maximum execution time (line […]).

Problem: Your request exceeded the 30-second limit allowed by Google Sheets functions. This is more likely to happen during peak times when the servers of the model providers (such as OpenAI) are experiencing high demand.

The response time can vary based on the specific model you are using and the time of usage.

Solutions:

Your request has timed out

Your request has timed out. To prevent timeouts, go to: Extensions > GPT for Sheets > Open > GPT formulas controls > enable safe mode (line 5373).

Problem: Your request exceeded the 30-second limit allowed by Google Sheets functions. This is more likely to happen during peak times when the servers of the model providers (such as OpenAI) are experiencing high demand.

Solutions:

Your API key is too limited

Problem: If your OpenAI organization is using a Free trial, the rate limits of your API key will be too low to be used in GPT for Sheets.

Solutions:

If you are not using an OpenAI free trial account

Check that your OpenAI organization is correctly set in GPT for Sheets:

  1. Select API keys from the add-on menu.
  2. Enter your OpenAI organization ID in the format org-xxxxxxxxxxx and click Save. This step is crucial if you are part of multiple organizations, as it ensures that billing for usage in both GPT for Sheets and GPT for Docs is attributed to the appropriate account.

Important note: To check if the organization you are using has remaining credits, follow these steps:

  1. Click on your user icon in the bottom left corner of your OpenAI account page, and select the appropriate organization.
  2. Go to Billing settings to check if you have remaining credits.

If you are using an OpenAI free trial account

  • Option 1: Continue without an API key.
    This option is suitable for immediate use and if using your API key is not a priority. Select Continue without API key to clear it from GPT for Sheets. Learn more about billing.
  • Option 2: Buy OpenAI credits for increased API rate limits.
    1. Go to OpenAI billing settings.
    2. Add your payment details.
    3. Purchase OpenAI credits starting at $5 to upgrade your account from the Free tier to Tier 1. This change increases your rate limit from 3 to 3,500 requests per minute with the gpt-3.5-turbo model. Note that TPM (Tokens Per Minute) limitations still apply, and further tier progression is necessary for greater TPM access.
    4. Wait up to 30 minutes for the new API key limit to become active.
OpenAI API not working with your key

Problem: While your OpenAI API key is recognized as valid, it is not working due to one or more of the following reasons:

  • You have not added a payment method to your OpenAI account (applicable to old OpenAI accounts).
  • You have not purchased OpenAI credits (applicable to new OpenAI accounts).
  • Your OpenAI organization is not correctly set in GPT for Sheets.
  • You have added a payment method or purchased OpenAI credits within the last 30 minutes and you still get this message.

Solution:

  1. Go to OpenAI billing settings.
  2. Add payment details.
  3. Purchase OpenAI credits.
  4. Select API keys from the add-on menu to ensure your OpenAI organization is correctly configured.
  5. Wait up to 30 minutes for your OpenAI API key to become active.

Solution for immediate use:

If immediate use is needed and using your API key is not a priority, select Continue without API key to clear it from GPT for Sheets. Learn more about billing.

Additional configuration required

Additional configuration required. Open the sidebar: Extensions > GPT for Sheets™ and Docs™ > Open.

This issue has two possible causes. See the table below for solutions to each:

Problem Solution
The system cannot connect to the model provider because there is no API key or the API key provided is invalid.
  1. Verify that you have set an OpenAI API key.
  2. If your spreadsheet is on a Shared Drive, the API key must be set by the spreadsheet's Creator. For other spreadsheets, the Current Owner should set the API key. Learn more.
  3. Use a model that doesn't require any API key.
GPT functions are not working if the sidebar has not been initially opened (for new users). Open the GPT for Sheets sidebar to activate the credits of your free trial. Check your permissions in the spreadsheet to ensure you can execute GPT functions.
Error: #NAME? Unknown function

Error: #NAME? Unknown function: 'GPT'

Problem: GPT functions have not been enabled in your spreadsheet.

Ensure that GPT for Sheets and Docs extension is installed on your account. If it doesn't appear in the Extensions menu, install it using the account you are currently operating.

Solution:

  • If you are the Creator of the spreadsheet, enable GPT functions by going to Extensions > GPT for Sheets and Docs > Open in your spreadsheet.
  • If you're not the creator of this spreadsheet, request assistance from the creator or make a copy of the spreadsheet for yourself.
Script error

ScriptError: Authorisation is required to perform that action.

Problem: You are likely using multiple Google accounts in the same Chrome session.

Solution:

  1. Create a dedicated Chrome profile.
  2. Create a new spreadsheet.
  3. Set up your API key.
  4. Try a GPT function again.
Multiple Google accounts error

You seem to be logged in to multiple Google accounts in your browser.

Problem: You are likely using multiple Google accounts in the same Chrome session.

Solution:

  1. Create a dedicated Chrome profile.
  2. Create a new spreadsheet.
  3. Set up your API key.
  4. Try a GPT function again.
Requests per day limit reached

You have reached your xxx requests per day limit.

Problem: You have reached your limit of requests per day (RPD) for the selected model.

Solutions:

Tokens per day limit reached

You have xxx / xxx tokens per day left.

Problem: You have reached your limit of tokens per day (TPD) for the selected model.

Solutions:

Questions

Is GPT-4o supported?

Yes, GPT-4o is supported with and without an API key.

Can I buy for my team?

This is currently not possible on a self-serve basis. It will be soon. In the meantime, please contact support and detail which account will be buying and the list of users.

Can I use my custom GPT and Assistants API?

Unfortunately the current OpenAI API, used by GPT for Sheets, does not support these features.

Which browsers are compatible with GPT for Sheets and Docs?

GPT for Sheets and Docs is compatible with the following browsers:

  • Chrome (highly recommended for the best experience)
  • Firefox
  • Microsoft Edge (for Windows users)
  • Safari (for Mac users)
Is GPT for Sheets connected to the web?
Yes, GPT for Sheets can search the web to provide up-to-date information with the GPT_WEB function, built on Perplexity AI's online models. However, other functions in GPT for Sheets are not web-connected. You can also scrape web pages directly from Sheets.
How is my data processed? Is it used to train models?
  • We do not read or store any data from your spreadsheet that you do not use as an input.
  • We send your inputs to the relevant AI provider’s API and we display the resulting outputs in your spreadsheet.
  • If you use a model with your own API key, we do not log any of the inputs submitted or outputs received.
  • If you use a model without your own API key, we log all the inputs and outputs for support purposes for a duration of 30 days. We then store them for 5 years to comply with applicable law, enforce our terms and policies, keep our Service safe and for product improvement purposes (excluding the training of any language model).
  • In our Sheets integration only, if you use the cache, we store your GPT function executions for 30 days, encrypted end-to-end, so you can reload results without incurring costs.
  • Whether you use a model with or without your own API key, Talarian does not use your inputs and outputs to train language models.
  • To check the AI provider’s models available with or without your own API key, please see our list of supported models.

    More information on how we use your data in our Terms of Service, Privacy Policy and DPA.

    More information on AI providers’ use of content is available on their relevant terms, as detailed in our Terms of Service.

    Who can execute GPT functions in a shared Google spreadsheet?

    After the Creator of a Google spreadsheet enables GPT functions, any user with Editor's access to the spreadsheet can execute them. Learn more.

    Errors

    Set OpenAI API key

    Please set OpenAI API key in Extensions menu > GPT for Sheets™ and Docs™ > Set API keys

    Problem (1): You haven't set any API key in GPT for Docs.

    Solution: Create and set up an OpenAI API key. You can also set up an Anthropic API key.

    Problem (2): You're using multiple Google accounts in the same browser session.

    Solution:

    OpenAI free trial expired
    openai api key expired

    Problem: The OpenAI free trial period associated with your account may have expired.

    Warning:

    • ChatGPT Plus/Pro subscriptions don't cover the use of OpenAI APIs, used by GPT for Docs.

    • Verifying your account with a phone number that hasn’t been used before is necessary to benefit from a free trial.

    Solutions:

    1. Go to OpenAI billing settings.
    2. Add payment details.
    3. Purchase OpenAI credits.
    4. In Google Sheets, go to Extensions > GPT for Sheets and Docs > Open, then select API keys in the add-on menu to ensure your OpenAI organization is correctly configured.
    5. Wait up to 30 minutes for your OpenAI API key to become active.
    Your document or selection is too long

    Your document or selection is too long to be processed in one shot or your max response length is too high.

    error image

    Problem: You have requested GPT for Docs to process a portion of text that exceeds the token limit set for your input size.

    Solutions:

    Models have a maximum token limit, which is the maximum total number of tokens that can be used in both the input and the response. This means models may not provide complete responses to long queries or when a large portion of text is selected as input.

    To stay within the token limit, you can:

    • Highlight a smaller portion of text in your document
    • Reduce the value of Max response tokens
    • Select a model with a higher limit (context window)
    API key limited by OpenAI

    Your API key is limited to 3 requests per minute by OpenAI. Set up a payment method on OpenAI platform in order to increase your rate limit.

    Problem: If your OpenAI organization is using a free trial, the rate limits of your API key will be too low to be used in GPT for Docs.

    limited docs screenshot

    Solutions:

    If you are not using an OpenAI free trial account

    Check that your OpenAI organization is correctly set in GPT for Docs:

    1. In Google Sheets, go to Extensions > GPT for Sheets and Docs > Open, then select API keys in the add-on menu.
    2. Enter your OpenAI organization ID in the format org-xxxxxxxxxxx and click Save. This step is crucial if you are part of multiple organizations, as it ensures that billing for usage in both GPT for Docs and GPT for Sheets is attributed to the appropriate account.

      Important Note: To check if the organization you are using has remaining credits, follow these steps:

      1. Click on your user icon in the bottom left corner and select the appropriate organization.

      2. Go to Billing settings to check if you have remaining credits.

    If you are using an OpenAI free trial account

    Buy OpenAI credits for increased API rate limits.

    1. Go to OpenAI billing settings.
    2. Add your payment details.
    3. Purchase OpenAI credits starting at $5 to upgrade your account from the Free tier to Tier 1. This change increases your rate limit from 3 to 3,500 requests per minute with the gpt-3.5-turbo model. Note that TPM (Tokens Per Minute) limitations still apply, and further tier progression is necessary for greater TPM access.
    4. Wait up to 30 minutes for the new API key limit to become active.
    Script error

    ScriptError: Authorisation is required to perform that action.

    error screenshot

    Problem: You are likely using multiple Google accounts in the same Chrome session.

    Solution:

    Problems

    Menu only shows "Help"

    Problem: When you select Extensions > GPT for Sheets and Docs, the only option you see is Help. Accessing the Extensions menu immediately after opening your document may cause this problem.

    Solution: Refresh your page, wait 30 seconds, then try to access the Extensions menu again.

    Sidebar is blank

    Problem: GPT for Docs sidebar is blank, or fails to load.

    empty sidebar image

    Solution:

    1. Open GPT for Docs in a Chrome Incognito window.
    2. If the sidebar loads successfully, check the following:
      • Ensure that you are not using multiple Google accounts in the same Chrome session. If you are, create a new profile using this guide.
      • Clear the cache and cookies on your browser.
      • Disable any extension on your regular browser that may be preventing GPT for Docs from launching. You can troubleshoot this by disabling one by one the extensions, reloading your Google document and trying to launch the sidebar again.
    If the problem persists, please let us know by submitting a support request.
    My response is cut or incomplete

    Problem: The response you get from GPT for Docs seems truncated.

    Solution: Models have a maximum token limit, which is the maximum total number of tokens that can be used in both the input and the response. This means models may not provide complete responses to long queries or when a large portion of text is selected as input.

    To stay within the token limit, you can:

    • Highlight a smaller portion of text in your document
    • Reduce the value of Max response tokens
    • Select a model with a higher limit (context window)

    Questions

    How do I install the GPT for Docs add-on?

    Install from Google Workspace Marketplace:

    1. Go to the installation page.

    2. Click Install.

    3. Follow the steps until the end.

    Learn more.

    Is the GPT for Docs add-on free to use?
    Yes, GPT for Docs is currently available for free, but you need to bring your OpenAI or Anthropic API key and pay the OpenAI or Anthropic API cost.
    Do I need an API key?
    Yes, you need to create and set up an OpenAI API key in GPT for Docs to access the models available in your OpenAI account.

    You can also set up an Anthropic key.

    Is GPT-4o supported?
    Yes, GPT-4o is supported, provided that this model is available in your OpenAI account. To check if you have access, go to the OpenAI playground and check if you can select GPT-4o there.
    Can I use my custom GPT and Assistants API?

    Unfortunately the current OpenAI API, used by GPT for Docs, does not support these features.

    How is my data processed? Is it used to train models?
    • We do not read or store any data from your document that you do not use as an input.
    • We send your inputs to the relevant AI provider’s API and we display the resulting outputs in your document.
    • We do not log or store any of the inputs submitted or outputs received.
    • Talarian does not use your inputs and outputs to train language models.

    To check the AI provider’s models available with or without your own API key, please see our list of supported models.

    More information on how we use your data in our Terms of Service, Privacy Policy and DPA.

    More information on AI providers’ use of content is available on their relevant terms, as detailed in our Terms of Service.

    Which browsers are compatible with GPT for Docs?
    GPT for Docs is compatible with the following browsers:
    • Chrome (highly recommended for the best experience)
    • Firefox
    • Microsoft Edge (for Windows users)
    • Safari (for Mac users)