[GPT for Sheets] 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.
- 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 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.
- Temporary: Choose a different model, 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.
- Temporary: Choose a different model, 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.