Rate Limits in SheetAI
SheetAI uses AI APIs (OpenAI, Google Gemini, Anthropic, etc.) under the hood. These providers enforce rate limits on how many requests you can make per minute and per day. When you exceed these limits, your formulas will return errors instead of results.
What Are Rate Limits?
Rate limits restrict the number of API calls you can make within a given time window. They exist to prevent abuse and ensure fair usage across all users. In SheetAI, every cell that uses a SheetAI function (like =SHEETAI(), =SHEETAI_LIST(), etc.) makes one or more API calls.
| Limit Type | Typical Threshold | Notes |
|---|---|---|
| Requests per minute (RPM) | 3 - 60 RPM | Depends on the AI model and your API plan tier |
| Requests per day (RPD) | 200 - 10,000+ RPD | Higher tiers and paid API keys get more daily requests |
| Tokens per minute (TPM) | 40,000 - 1,000,000+ TPM | Longer prompts consume more tokens per request |
Common Rate Limit Error Messages
If you hit a rate limit, your SheetAI formulas will show one of these errors in the cell:
Rate limit exceeded. Please try again later.You have sent too many requests in a short time. Wait a minute and try again.
Error 429: Too Many RequestsThe AI provider is rejecting requests because you exceeded your per-minute or per-day quota.
quota exceededYour API key has hit its usage limit for the current billing period.
Request timed outThe server was too overloaded to respond. This can happen during peak usage times alongside rate limiting.
How to Fix and Avoid Rate Limits
1. Process rows in small batches
Instead of filling SheetAI formulas in hundreds of cells at once, work in batches of 10-20 rows at a time. Copy the formula to a small range, wait for results, then move to the next batch.
2. Add delays between requests
If you are using SheetAI with Google Apps Script or automation tools, add a Utilities.sleep(2000) call (2-second delay) between each API call to stay within per-minute limits.
3. Use your own API key
SheetAI's built-in API key is shared across free-tier users, which means stricter limits. Setting up your own OpenAI, Gemini, or Anthropic API key gives you a dedicated rate limit that only you use. See how to create an API key for setup instructions.
4. Upgrade your API plan
Free-tier API keys from OpenAI, Google, and Anthropic have very low rate limits. Adding a payment method or upgrading to a paid API tier significantly increases your requests-per-minute and daily quotas.
5. Prevent unnecessary recalculations
Google Sheets may recalculate SheetAI formulas when the sheet is reopened or edited, consuming your quota. Replace formula cells with their static values (Copy → Paste as Values) once you have the results you need. See preventing formula recalculation for more details.
6. Choose a faster/cheaper model
Larger models like GPT-4 have stricter rate limits than smaller ones like GPT-4o-mini. If speed matters more than quality for your task, switch to a lighter model in the SheetAI sidebar to get higher throughput.
What to Do If You Hit a Rate Limit Right Now
- Wait 60 seconds. Most per-minute rate limits reset after one minute. Simply wait and the formulas will work again on the next recalculation.
- Check your API key usage. Log in to your AI provider dashboard (e.g., OpenAI Usage) and check if you have hit your daily or monthly quota.
- Reduce the number of active formulas. Delete or convert some SheetAI formulas to static values to lower the number of simultaneous API calls.
- Retry in smaller batches. Re-enter your formulas in groups of 5-10 cells instead of all at once.
Still Having Issues?
If you continue to experience rate limit errors after trying the steps above, check common errors or reach out to us at support@sheetai.app with your API provider, model name, and a screenshot of the error.