Links:
- GPT for Docs, Slides, Forms
- GPT for Sheets
- GPT for Gmail
- Google Slides AI
- Quiz Maker AI
- Translate and Rephrase Slides in 1 click
RECOMMENDATION: The best way to ensure optimal performance with Google Add-Ons is by using the Google Chrome browser. This helps bypass any potential issues that may arise from compatibility with other browsers.
Errors
Name #ERROR or the function return #ERROR everytime
Reason
You have installed other GPT add-ons that use the same ‘GPT()’ function name, resulting in a conflict
Solution
- Please remove all other add-on that provides AI/GPT functions, refresh the page, re-run the add-on, click on ‘Refresh Account’ button
Only shows ‘Help’
Reason
If you navigate to Extensions > GPT for Docs, Sheets, Docs, Forms, Slides - you might notice that the only available option is Help. This issue could occur if you access the Extensions menu immediately upon opening your spreadsheet
Solution
- Please refresh your page, wait for 30 seconds, and then attempt to access the Extensions menu again
ScriptError: Authorisation is required to perform that action
ScriptError: Authorisation is required to perform that action
Reason
You use a company email account, you need to use a personal email or ask admin to allow execution addons You used multiple Google accounts in the same Chrome session
Solution #1
- Use Personal Email
Solution #2
- Create a new Chrome profile
- Create a new spreadsheet
- Try a GPT function again
Solution #3
- Clean up cookies in your browser
- Login again in Google account
- Uninstall and Install again the add-on
Solution #4
- Ask admin of the workspace account to allow execution add-ons
Exceeded maximum execution time
Exceeded maximum execution time (line […]).
Reason
Your inquiry has surpassed the 30-second threshold permitted by Google Sheets functions. This occurrence is more probable during peak periods when the servers of model providers, like OpenAI, are under heavy demand
Solutions
- Update arguments and try again (add a space, make it shorter to trigger calling again)
- The request is too long, please make shorter argument and expected output
Open the sidebar: Extensions > GPT for Sheets, Docs, Slides, Forms > Launch
Reason
You need to do initiation set up, it could be done via launching the sidebar.
Solutions
- Click on Extensions > GPT for Sheets, Docs, Slides, Forms > Launch
#NAME? Unknown function
Error: #NAME? Unknown function: 'GPT'
Reason
GPT functions have not been enabled in your spreadsheet with the Add-On. You have other GPT add-ons in you spreadsheet
Solutions
- Remove other add-ons that use GPT functions
- Click on Extensions > GPT for Sheets, Docs, Slides, Forms > Launch
Multiple Google accounts error
You seem to be logged in to multiple Google accounts in your browser.
Reason
You used multiple Google accounts in the same Chrome session.
Solution #1
- Create a new Chrome profile
- Create a new spreadsheet
- Try a GPT function again
Solution #2
- Clean up cookies in your browser
- Login again in Google account
- Uninstall and Install again the add-on
Service invoked too many times
Exception: Service invoked too many times for one day
Reason
You have exhausted your daily allowance of calls to an external service through your Google account
Solution
-
Quotas reset every 24 hours, so please wait the day or use different account
- Quota for gmail.com accounts: 20k / day
- Quota for Google Workspace accounts: 100k / day
Requests per day limit reached
Requests per day limit reached
Reason
You have reached your requests per day from OpenAI side
Solution
- Wait 1-24h and try again
Formula parse error
Formula parse error
Reason
There appears to be a structural or syntax error in your formula, rendering it unreadable by Google Sheets
Solutions
- Check that you have quotation marks
✅ =GPT("hi")
,✅ =GPT(C1)
,❌ =GPT(hi)
- Check that your arguments are in the correct order
- 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.001
or0,001
Sidebar is blank
Reason
Fails to load the add-on
Solutions
- Clear the cache and cookies on your browser and run again
- Open the add-on in Incognito profile
- Re-login to the account
- Uninstall/ Disable other add-on that provides GPT functions
Formulas are reloaded when I edit, open the spreadsheets, tabs
Reason
Google Sheets refreshes all formulas automatically every few hours, including GPT formulas, which may result in unexpected expenses and alterations in outcomes
Solution
- Replace formulas with their results
- Use provided buttons in the sidebar to replace’ ‘selected range’ or ‘replace all gpts’
GPT functions are stuck on “Loading”
Reason
GPT functions fail to execute
Solution
- Remove other add-on that provided GPT functions and re-launch
- Change argument values (add a space, comma etc)
- Make it shorter
- Make expected result shorter
- Refresh the page and re-launch the sidebar
I charged when I anm not using GPT for Sheets
Reason
Google Sheets automatically re-load all formulas every some period of time
Solutions
- Replace formulas with their results
- Use provided buttons in the sidebar to replace’ ‘selected range’ or ‘replace all gpts’
My results reloaded and results are changed, lost
Reason
Google Sheets automatically re-load all formulas every some period of time
Solutions
- Replace formulas with their results
- Use provided buttons in the sidebar to replace’ ‘selected range’ or ‘replace all gpts’