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, please refer to
this user-friendly tutorial.
Submit a request
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.
- In the desktop version of Excel, open the right sidebar menu (Windows) or click the info icon (Mac), then choose Reload.
- 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.
-
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 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.
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.
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):
-
Click Add-ins in the Home tab.
-
Click More Add-ins.
-
Select GPT for Excel Word in the My Add-ins tab.
-
Click Add.
-
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
or0,8
?
-
Check that you have quotation marks around your prompt if it is
not in a cell:
- Error in value
-
Error in Value. A value used in the formula is of the wrong data type.
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
or0,8
?
-
Check that you have quotation marks around your prompt if it is
not in a cell:
- 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
or0,8
?
-
Check that you have quotation marks around your prompt if it is
not in a cell:
- 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.
Solutions:
If you are not using an OpenAI free trial account
Check that your OpenAI organization is correctly set in GPT for Excel:
- Select API keys from GPT for Excel sidebar menu.
- 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:
Click on your user icon in the bottom left corner and select the appropriate organization.
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.
- Go to OpenAI billing settings.
- Add your payment details.
- 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.
- 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 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. -
- 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:
-
Short term: Choose a different model or a model that doesn't require an API key in the model switcher.
-
Long term: Upgrade your OpenAI account to a higher tier.
-
- 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:
-
Short term: Choose a different model or a model that doesn't require an API key in the model switcher.
-
Long term: Upgrade your OpenAI account to a higher tier.
-
Questions
- Is GPT-4o supported?
-
Yes, GPT-4o is supported with and without an API key.
- Can I use my custom GPTs and Assistants?
-
Set up your OpenAI API key and your Assistants will show in the model switcher. You can replicate the configuration of your custom GPTs as Assistants to use them with GPT for Excel. Learn more.
- Can I use local models?
-
Yes, GPT for Excel supports integration with Ollama. Enter the Ollama endpoint URL in the API keys screen, and your local models will show in the model switcher.
For a full list of models supported by Ollama, please refer to the Ollama model library.
- 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 Web browsing bulk tool and the GPT_WEB function, built on Perplexity AI's online models. However, other bulk tools and 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.
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.
Solutions:
If you are not using an OpenAI free trial account
Check that your OpenAI organization is correctly set in GPT for Word:
- Select API keys from GPT for Word sidebar menu.
- 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:
Click on your user icon in the bottom left corner and select the appropriate organization.
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.
- Go to OpenAI billing settings.
- Add your payment details.
- 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.
- 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 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. -
Questions
- How do I install the GPT for Word add-in?
-
Install from Microsoft AppSource:
- Go to the installation page.
- Click Open in Word.
- 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 Quickstart guide.
- 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 GPTs and Assistants?
-
No, GPT for Word doesn't currently support these features, but you can use your OpenAI Assistants with GPT for Excel and GPT for Sheets.
- Can I use local models?
-
Yes, GPT for Word supports integration with Ollama. Enter the Ollama endpoint URL in the API keys screen, and your local models will show in the model switcher.
For a full list of models supported by Ollama, please refer to the Ollama model library.
- 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:
- Open GPT for Sheets in a Chrome Incognito window.
- 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:- To save results permanently and prevent formula reloading, automatically replace formulas with their results (currently reserved to GPT-4 and GPT-4 Turbo models and the GPT_WEB function). You can also manually replace GPT formulas with their results in selected cells or across an entire sheet.
- To store formula results
- Use the cache by default most of the time.
- Alternatively, use Safe mode if you also need to prevent timeouts, notably when you're expecting long generations or using models that are very slow like gpt-4-turbo or gpt-4.
- To prevent new executions, pause GPT formulas.
- To prevent further spending in any of your spreadsheets, turn spending off. Auto-refreshes can still happen and cause data loss but will no longer incur costs. Replace formulas or use safe mode to avoid data loss.
- 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.
- 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.
- Estimate your costs with the Token counter before executing GPT
functions on a large number of cells.
- 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:- To save results permanently and prevent formula reloading, automatically replace formulas with their results (currently reserved to GPT-4 and GPT-4 Turbo models and the GPT_WEB function). You can also manually replace GPT formulas with their results in selected cells or across an entire sheet.
- To store formula results
- Use the cache by default most of the time.
- Alternatively, use Safe mode if you also need to prevent timeouts, notably when you're expecting long generations or using models that are very slow like gpt-4-turbo or gpt-4.
- To prevent new executions, pause GPT formulas.
- To prevent further spending in any of your spreadsheets, turn spending off. Auto-refreshes can still happen and cause data loss but will no longer incur costs. Replace formulas or use safe mode to avoid data loss.
- 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:- Execute a random native formula (such as SUM or CONCAT) in a blank cell, and delete it after.
- Delete the content of the cell and undo the deletion.
- Refresh the spreadsheet.
- 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:
- Choose a model with a faster response time. You can track average response times on our response time tracker.
- Use Safe mode to reduce timeouts.
- Use GPT for Excel to completely avoid timeouts.
- 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:
- Choose a model with a faster response time. You can track average response times on our response time tracker.
- Use safe mode to reduce timeouts.
- Use GPT for Excel to completely avoid timeouts.
- 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:
- Select API keys from the add-on menu.
- 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:
- Click on your user icon in the bottom left corner of your
OpenAI account
page, and select the appropriate organization.
- 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.
- Go to OpenAI billing settings.
- Add your payment details.
- 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.
- 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:
- 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.
- 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. - Verify that you have set an API key.
- 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.
- 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:
- Create a dedicated Chrome profile.
- Create a new spreadsheet.
- Set up your API key.
- 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:
- Create a dedicated Chrome profile.
- Create a new spreadsheet.
- Set up your API key.
- 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:
- Short term: Choose a different model or a model that doesn't require an API key in the model switcher.
- Long term: Upgrade your OpenAI account to a higher tier.
- 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:
- Short term: Choose a different model or a model that doesn't require an API key in the model switcher.
- Long term: Upgrade your OpenAI account to a higher tier.
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 GPTs and Assistants?
-
Set up your OpenAI API key and your Assistants will show in the model switcher. You can replicate the configuration of your custom GPTs as Assistants to use them with GPT for Sheets. Learn more.
- 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:
- Create a dedicated Chrome profile.
- Create a new document.
- Set up your API key in this new document.
- Try submitting a prompt again.
- OpenAI free trial 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:
- 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:
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.
Solutions:
If you are not using an OpenAI free trial account
Check that your OpenAI organization is correctly set in GPT for Docs:
- In Google Sheets, go to Extensions > GPT for Sheets and Docs > Open, then select API keys in the add-on menu.
- 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:
-
Click on your user icon in the bottom left corner and select the appropriate organization.
-
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.
- Go to OpenAI billing settings.
- Add your payment details.
- 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.
- Wait up to 30 minutes for the new API key limit to become active.
- Script error
-
ScriptError: Authorisation is required to perform that action.
Problem: You are likely using multiple Google accounts in the same Chrome session.
Solution:
- Create a dedicated Chrome profile.
- Create a new document.
- Set up your API key in this new document.
- Try submitting a prompt again.
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.
Solution:
- Open GPT for Docs in a Chrome Incognito window.
-
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.
- 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:
-
Go to the installation page.
-
Click Install.
-
Follow the steps until the end.
-
- 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 GPTs and Assistants?
-
No, GPT for Docs doesn't currently support these features, but you can use your OpenAI Assistants with GPT for Sheets and GPT for Excel.
- 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)