Submit a request

Our support hours are from Monday to Friday:
7:30 PM - 12:00 PM (New York)
1:30 AM - 6:00 PM (Paris)
5:00 AM - 9:30 PM (India)
8:30 AM - 1:00 AM (Tokyo)

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, refer to this user-friendly tutorial.

Billing issues

I have a ChatGPT Plus subscription, but my balance is empty

Problem: You have a ChatGPT Plus subscription, but GPT for Excel still says that your balance is empty.

Solution:

OpenAI's ChatGPT Plus subscription is neither necessary nor sufficient for using the GPT for Work add-ons.

Buy a pack to add money to your balance in GPT for Excel.

I bought a pack but my balance is empty

Problem: You have bought a pack but your balance in GPT for Excel is still 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. Switch to another account if needed.

My packs have disappeared from the tracking screen

Problem: You have bought 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 bought your packs. Switch to another account if needed.

The costs are too high

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. Select Token counter from the add-in menu to access it.
Select a cheaper model after comparing their costs with the Cost estimator.
Set up your own API key to save on total cost.

Installation issues

I can't sign in after installing

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

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 signed in with the wrong Microsoft account

Problem: You signed in with the wrong Microsoft account while installing GPT for Excel and need to switch to the correct one.

Solution:

Open the sidebar menu and click Log out to sign out, then sign in again with the correct account.

I want to uninstall

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

Solution:

To remove the add-in from Excel and Word, follow our uninstallation guide.

I can't uninstall GPT for Excel

Problem: GPT for Excel prompts you to be activated every time you open Excel, which may be caused by remaining GPT formulas in your workbook.

Solution:

To find and remove all GPT formulas in your workbook (the experience might be slightly different on Web version and Mac desktop version):

Press CTRL + F to open the Find and Replace window.
Click Options.
In Find what, enter =GPT.
Set Within to Workbook, and Look in to Formulas.
Click Find All.

You can now locate all GPT formulas and delete them.

Problem: You want to uninstall the add-in, but the Remove option is not available in the add-in Options menu in the Office Add-ins popup.

Solution:

Clear the Microsoft Office cache:

Close all Office applications.
Follow Microsoft's instructions for clearing the cache.
Open Excel and try removing the add-in again.

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 on different Office platforms.

Office for Windows	Office for Mac	Office for the web
Microsoft 365 subscription: Excel: Version 2002 (Build 12527.20092) Retail perpetual: Excel: Version 2002 (Build 12527.20092) Volume-licensed perpetual: Excel 2021: Version 2108 (Build 12527.20092)	Excel: Version 16.35 (Build 20030802)	Excel: Supported

Office for Windows

Office for Mac

Office for the web

Microsoft 365 subscription:

Excel: Version 2002 (Build 12527.20092)

Retail perpetual:

Excel: Version 2002 (Build 12527.20092)

Volume-licensed perpetual:

Excel 2021: Version 2108 (Build 12527.20092)

Excel: Version 16.35 (Build 20030802)

Excel: Supported

Which version of Excel am I using?

GPT function issues

Invalid name

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

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 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 formats for temperature for your locale: `0.8` or `0,8`?

Missing parameter

#ERROR: Missing required arguments categories for function GPT_XXX.

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.

Text values limited to 255 characters

Text values in formulas are limited to 255 characters.

Problem: The text value in your formula is too long and exceeds Excel's 255-character limit.

Solution:

Insert the text into another cell and reference it in your formula, for example, =GPT(A1), where A1 contains the text value.

Cell A1 contains a long prompt, and cell B1 contains =GPT(A1)

Functions are stuck on #BUSY

Problem: GPT functions fail to execute and remain in a #BUSY! state, even after reopening your file or restarting Excel.

Solutions:

Open the GPT for Excel sidebar before using any GPT functions:
- Click GPT for Excel Word in the Home tab.
- Wait for the sidebar to fully load before entering your first GPT formula.
Delete the GPT formula and undo the deletion to run the formula again.
Enter a new GPT formula in a different cell. Subsequent functions typically work correctly.
Use bulk AI tools to avoid this issue in the future, if your use case allows it.

GPT_WEB function is not working

If you're using the GPT_WEB function and experiencing issues, this is likely because:

The GPT_WEB function only works with the Perplexity Sonar model.
If you've selected a non-Perplexity model that uses your own API key, GPT_WEB fails because it tries to use that API key with Perplexity Sonar.

Solutions:

(Recommended)
Select a web-capable model (🌐) from the model switcher and then use the GPT function. Learn more.
```
=GPT("your prompt")
```
You can also use a web-capable model as a parameter in the GPT function. Learn more.
```
=GPT("your prompt", , , "sonar")
```
If you want to keep using the GPT_WEB function, make sure you first select the Sonar model from the model switcher.

Bulk tool issues

The Custom prompt tool is not working: Problem: The Custom prompt bulk tool does not give the desired result, often because the prompt is incomplete or the variables are incorrectly formatted.

Solution:
Review the Custom prompt article for guidance on creating effective prompts and using the tool. If the issue persists, contact support.

API key issues

OpenAI API isn't working

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:

Go to OpenAI billing settings.
Add payment details.
Purchase OpenAI credits.
Go to API keys in GPT for Excel sidebar menu to ensure your OpenAI organization is correctly configured.
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.

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.

Solution:

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.

Rate limit issues

Token limit reached

You are facing one of the following errors:

You have xxx / xxx tokens per minute left for model xxx but your execution requires xxx.
You have xxx / xxx tokens per day left for model xxx.

Problem: You have reached your limit of tokens for the selected model.

Solutions:

Temporary: Choose a different model, or wait until your token limit resets: one minute or 24 hours.
Permanent: Upgrade your OpenAI account to a higher tier, or use models that don't require an API key.

Request limit reached

You are facing one of the following errors:

You have reached your xxx requests per day limit for model xxx.
You have reached your xxx requests per minute limit for model xxx.

Problem: You have reached your limit of requests for the selected model.

Solutions:

Temporary: Choose a different model, or wait until your request limit resets: one minute or 24 hours.
Permanent: Upgrade your OpenAI account to a higher tier, or use models that don't require an API key.

Add-on not working

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 menu to the right of the sidebar (Windows) or click the info icon (macOS), 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.

Office for Windows	Office for Mac	Office for the web
Microsoft 365 subscription: Excel: Version 2002 (Build 12527.20092) Retail perpetual: Excel: Version 2002 (Build 12527.20092) Volume-licensed perpetual: Excel 2021: Version 2108 (Build 12527.20092)	Excel: Version 16.35 (Build 20030802)	Excel: Supported

The add-in requires to	Reason
View your basic profile	Allows the add-in to see your basic profile (name, image, user name).
Maintain access to data you have given it access to	Allows the add-in to access the data (your info and documents), even when you are not currently using it. This does not give the app any additional permissions.

Billing issues

I have a ChatGPT Plus subscription, but my balance is empty: Problem: You have a ChatGPT Plus subscription, but GPT for Word still says that your balance is empty.

Solution:
OpenAI's ChatGPT Plus subscription is neither necessary nor sufficient for using the GPT for Work add-ons.
Buy a pack to add money to your balance in GPT for Word.
I bought a pack but my balance is empty: Problem: You have bought a pack but your balance in GPT for Word is still 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. Switch to another account if needed.
My packs have disappeared from the tracking screen: Problem: You have bought 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 bought your packs. Switch to another account if needed.

Output issues

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.

To stay within the token limit, you can:

In the sidebar, click Clear chat to delete your chat history.
Break up your work into smaller parts.
Select a model with a higher limit.

Responses don't make sense

Problem: The responses you get from GPT for Word don't match your requests.

Solution:

Click on Clear chat to delete your chat history. This deletes previous chat messages that might interfere with your current request.
Refine your prompt and/or select a different model. See our examples for guidance.

API key issues

OpenAI API isn't working

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:

Go to OpenAI billing settings.
Add payment details.
Purchase OpenAI credits.
Go to API keys in GPT for Word sidebar menu to ensure your OpenAI organization is correctly configured.
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.

Rate limit issues

Token limit is reached

You are facing one of the following errors:

You have xxx / xxx tokens per minute left for model xxx but your execution requires xxx.
You have xxx / xxx tokens per day left for model xxx.

Problem: You have reached your limit of tokens for the selected model.

Solutions:

Temporary: Choose a different model, or wait until your token limit resets: one minute or 24 hours.
Permanent: Upgrade your OpenAI account to a higher tier, or use models that don't require an API key.

Request limit is reached

You are facing one of the following errors:

You have reached your xxx requests per day limit for model xxx.
You have reached your xxx requests per minute limit for model xxx.

Problem: You have reached your limit of requests for the selected model.

Solutions:

Temporary: Choose a different model, or wait until your request limit resets: one minute or 24 hours.
Permanent: Upgrade your OpenAI account to a higher tier, or use models that don't require an API key.

Installation issues

I can't sign in after installing

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

Solutions:

Check which versions of Word and which browsers are supported by this extension.
Try using the web version of Word instead of the desktop version.
Try using GPT for Word in a private/incognito window.

I signed in with the wrong Microsoft account

Problem: You signed in with the wrong Microsoft account while installing GPT for Word and need to switch to the correct one.

Solution:

Open the sidebar menu and click Log out to sign out, then sign in again with the correct account.

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 our uninstallation guide.

I can't uninstall GPT for Word

Problem: You want to uninstall the add-in, but the Remove option is not available in the add-in Options menu in the Office Add-ins popup.

Solution:

Clear the Microsoft Office cache:

Close all Office applications.
Follow Microsoft's instructions for clearing the cache.
Open Word and try removing the add-in again.

Office for Windows	Office for Mac	Office for the web
Microsoft 365 subscription: Word: Version 2205 (Build 15202.10000) Retail perpetual: Word: Version 2205 (Build 15202.10000) Volume-licensed perpetual: Word 2024: Version 2205 (Build 15202.10000)	Word: Version 16.61 (Build 22040100)	Word: Supported

The add-in requires to	Reason
View your basic profile	Allows the add-in to see your basic profile (name, image, user name).
Maintain access to data you have given it access to	Allows the add-in to access the data (your info and documents), even when you are not currently using it. This does not give the app any additional permissions.

Billing issues

I have a ChatGPT Plus subscription, but my balance is empty

Problem: You have a ChatGPT Plus subscription, but GPT for Sheets still says that your balance is empty.

Solution:

OpenAI's ChatGPT Plus subscription is neither necessary nor sufficient for using the GPT for Work add-ons.

Buy a pack to add money to your balance in GPT for Sheets.

I bought a pack but my balance is empty

Problem: You have bought a pack but your balance in GPT for Sheets is still 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. Switch to another account if needed.

My packs have disappeared from the tracking screen

Problem: You have bought 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 bought your packs. Switch to another account if needed.

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.

Solutions:

GPT for Sheets offers a variety of options to control recalculations:

To save results permanently and prevent formula reloading, replace GPT formulas with their results in selected cells or across an entire sheet.
To store results, enable the cache.
To prevent new executions in your spreadsheet, disable GPT formulas.

GPT function issues

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.

Solutions:

Try the following solutions:

In the original spreadsheet:
1. Execute any native formula, such as CONCAT or SUM, in an empty cell. Delete the formula when done.
2. Delete the content of one cell containing a stuck formula and undo the deletion.
3. Wait up to 24 hours.
In a new spreadsheet:
1. Create a new blank spreadsheet.
2. In the menu bar, select Extensions > GPT for Sheets and Docs > Enable GPT functions.
3. To test that GPT functions work, enter =GPT("hello") in any cell and check that the formula generates a proper "hello" response.
4. If the GPT function worked as expected, delete the formula and copy the contents of the original spreadsheet into the new spreadsheet.
5. Disable GPT functions in the original spreadsheet. This prevents unexpected costs when the functions suddenly become unstuck, which usually happens within 24 hours.

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 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 your free trial. Check your permissions in the spreadsheet to ensure you can execute GPT functions.

Script error

ScriptError: Authorisation is required to perform that action.

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

Solution:

Create a dedicated browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
Create a new spreadsheet.
Set up your API key in this new spreadsheet.
Try a GPT function again.

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 text if it's 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 formats for temperature for your locale: `0.8` or `0,8`?

Error: #NAME? Unknown function

Error: #NAME? Unknown function: 'GPT'

Problem: This error is caused by one of the following:

The GPT for Sheets and Docs add-on is not installed.
GPT functions have not been enabled in the spreadsheet.
Google Sheets has stopped recognizing GPT functions in the spreadsheet.

Solutions:

Try the following solutions in order:

In the menu bar, select Extensions and check for GPT for Sheets and Docs. If the add-on is not listed, install it.
Enable GPT functions:
- If you're the creator of the spreadsheet: In the menu bar, select Extensions > GPT for Sheets and Docs > Enable GPT functions.
- If you're not the creator of the spreadsheet: Ask the creator to enable GPT functions for you, or make a copy of the spreadsheet for yourself.
Reload the add-on for the spreadsheet:
1. In the menu bar, select Extensions > Add-ons > Manage add-ons.
2. In the list of installed apps, find GPT for Sheets and Docs and click its options button.
3. In the options menu, unselect and select Use in this document.
Try the same solutions as in Functions are stuck on 'Loading'.

Formula parse error

Formula parse error.

Problem: Your formula contains a structural or syntax error, making it uninterpretable by Google Sheets.

Solutions:

Check that you have quotation marks around your text if it's 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 formats for temperature for your locale: `0.8` or `0,8`?

Missing parameter

Error: Please set required parameter text in GPT_XXX() 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.

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.

Solutions:

GPT for Sheets offers a variety of options to control recalculations:

To save results permanently and prevent formula reloading, replace GPT formulas with their results in selected cells or across an entire sheet.
To store results, enable the cache.
To prevent new executions in your spreadsheet, disable GPT formulas.

Response is cut or incomplete

Problem: The response you get seems to be incomplete.

Solution:

You need to increase the cut-off limit.

My results refreshed and I lost data

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

Solution:

You can recover your data by using the version history of your Google spreadsheet.
You can also take steps to prevent this situation from recurring.
GPT for Sheets offers a variety of options to control recalculations:
- To save results permanently and prevent formula reloading, replace GPT formulas with their results in selected cells or across an entire sheet.
- To store results, enable the cache.
- To prevent new executions in your spreadsheet, disable GPT formulas.

GPT_WEB function is not working

If you're using the GPT_WEB function and experiencing issues, this is likely because:

The GPT_WEB function only works with the Perplexity Sonar model.
If you've selected a non-Perplexity model that uses your own API key, GPT_WEB fails because it tries to use that API key with Perplexity Sonar.

Solutions:

(Recommended)
Select a web-capable model (🌐) from the model switcher and then use the GPT function. Learn more.
```
=GPT("your prompt")
```
You can also use a web-capable model as a parameter in the GPT function. Learn more.
```
=GPT("your prompt", , , "sonar")
```
If you want to keep using the GPT_WEB function, make sure you first select the Sonar model from the model switcher.

Request timed out / Exceeded max execution time

Your request has timed out. Select a faster model, or reduce the Max response tokens parameter if possible.

Exceeded maximum execution time.

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:

Choose a model with a faster response time. You can track average response times on our response time tracker.
Set the cut-off limit to a lower value.
Keep the cache enabled so that you can retry formulas that timed out without additional costs.
Use GPT for Excel to completely avoid timeouts.

The model you are using is very slow at the moment

The model you are using is very slow at the moment which could result in timeouts. We canceled your executions to save you costs. Please try again with a faster model or at a later time.

Problem: You have reached the limit of 10 timeout errors in the past minute with the same model. 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:

Choose a model with a faster response time. You can track average response times on our response time tracker.
Set the cut-off limit to a lower value.
Keep the cache enabled so that you can retry formulas that timed out without additional costs.
Use GPT for Excel to completely avoid timeouts.

Bulk tool issues

Cannot use GPT for Sheets because you are not the owner: Problem: You have opened a spreadsheet that you do not own, and you can't launch GPT for Sheets sidebar from it.

Solution:
Make a copy of the spreadsheet for yourself. Learn more about how it works on shared spreadsheets.
Bulk tool stuck on "Running...": Problem: You click Run, but the Bulk tool stays stuck on "Running..." and does not complete the task.

Solution:
Click Stop in the sidebar to cancel the current run and then restart it. If the issue persists, contact support.
The Custom prompt tool is not working: Problem: The Custom prompt bulk tool does not give the desired result, often because the prompt is incomplete or the variables are incorrectly formatted.

Solution:
Review the Custom prompt article for guidance on creating effective prompts and using the tool. If the issue persists, contact support.

API key issues

OpenAI API isn't working

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:

Go to OpenAI billing settings.
Add payment details.
Purchase OpenAI credits.
Select API keys from the add-on menu to ensure your OpenAI organization is correctly configured.
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.

I've 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.

Solution:

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.

Rate limit issues

Service invoked too many times

Error: You've exceeded the Google Sheets external service calls daily limit (20K for Gmail accounts, 100K for Google Workspace accounts). Consider using bulk tools, which are not subject to this limit, for high volume.

Problem: You have reached your daily quota of calls to an external service from your Google account.

Quota for gmail.com accounts: 20k / day
Quota for Google Workspace accounts: 100k / day

Google's rate limits apply to all add-ons and scripts, not just ours. If you use multiple scripts or add-ons, your usage counts towards the same rate limits. It is not possible to increase them as explained here.

Solution:

Quotas reset every 24 hours, so wait for the end of this period to regain access.
Use bulk tools to bypass this error, as they are not subject to Google's rate limits.
You can use GPT for Excel instead, as this add-in is not affected by Google's rate limits.

Token limit is reached

You are facing one of the following errors:

You have xxx / xxx tokens per minute left for model xxx but your execution requires xxx.
You have xxx / xxx tokens per day left for model xxx.

Problem: You have reached your limit of tokens for the selected model.

Solutions:

Temporary: Choose a different model, or wait until your token limit resets: one minute or 24 hours.
Permanent: Upgrade your OpenAI account to a higher tier, or use models that don't require an API key.

Request limit is reached

You are facing one of the following errors:

You have reached your xxx requests per day limit for model xxx.
You have reached your xxx requests per minute limit for model xxx.

Problem: You have reached your limit of requests for the selected model.

Solutions:

Temporary: Choose a different model, or wait until your request limit resets: one minute or 24 hours.
Permanent: Upgrade your OpenAI account to a higher tier, or use models that don't require an API key.

Add-on not working

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 browsing session.

Solution:

Create a dedicated browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
Create a new spreadsheet.
Set up your API key in this new spreadsheet.
Try a GPT function again.

Sidebar is blank

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

Solution:

Open GPT for Sheets in a private browsing window.
If the sidebar loads successfully, check the following:
- Ensure that you are not using multiple Google accounts in the same browser session. If you are, create a new browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
- 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, submit a support request.

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 spreadsheet may cause this problem.

Solution:

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

The add-on requires to	Reason
View and manage documents that this application has been installed in	We need to be able to inject responses in the Google documents that you launch the add-on in.
View and manage spreadsheets that this application has been installed in	We need to be able to inject results in the Google spreadsheets in which the GPT functions are enabled.
See, edit, and delete all your Google Sheets spreadsheets (with bulk tools)	We need to interact with the spreadsheets to access and modify the content of the cells when you're using bulk tools.

Problems

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 API key.

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

Solution:

Create a dedicated browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
Create a new document.
Set up your API key in this new document.
Try submitting a prompt again.

Solutions:

Go to OpenAI billing settings.
Add payment details.
Purchase OpenAI credits.
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.
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.

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

Solutions:

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.

Script error

ScriptError: Authorisation is required to perform that action.

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

Solution:

Create a dedicated browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
Create a new document.
Set up your API key in this new document.
Try submitting a prompt again.

Requests per day limit reached

You are facing one of the following errors:

You have reached your xxx requests per day limit for model xxx.
You have reached your xxx requests per minute limit for model xxx.

Problem: You have reached your limit of requests for the selected model.

Solutions:

Temporary: Choose a different model, or wait until your request limit resets: one minute or 24 hours.
Permanent: Upgrade your OpenAI account to a higher tier.

Tokens per day limit reached

You are facing one of the following errors:

You have xxx / xxx tokens per minute left for model xxx but your execution requires xxx.
You have xxx / xxx tokens per day left for model xxx.

Problem: You have reached your limit of tokens for the selected model.

Solutions:

Temporary: Choose a different model, or wait until your token limit resets: one minute or 24 hours.
Permanent: Upgrade your OpenAI account to a higher tier.

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.

Solution:

Open GPT for Docs in a private browsing window.
If the sidebar loads successfully, check the following:
- Ensure that you are not using multiple Google accounts in the same browser session. If you are, create a new browser profile on Google Chrome, Microsoft Edge, or Apple Safari.
- 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, submit a support request.

My response is cut or incomplete

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

Solution:

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.

I want to uninstall

Problem: You are not using the add-on in Docs or Sheets, and you want to uninstall it.

Solution:

To remove the add-on from Docs and Sheets, follow our uninstallation guide.

If none of the listed solutions addresses your issue, reach out to our support team for further assistance.

Submit a request

Frequently Asked Questions

Billing issues

Installation issues

GPT function issues

Bulk tool issues

API key issues

Rate limit issues

Add-on not working

More questions

Billing issues

Output issues

API key issues

Rate limit issues

Installation issues

More questions

Billing issues

GPT function issues

Bulk tool issues

API key issues

Rate limit issues

Add-on not working

More questions

Problems

More questions