Rate Limiting & Google API Quota

SheetBridge enforces rate limits on API requests to prevent abuse and ensure fair usage. Rate limits are applied per bridge owner (user account).

API Rate Limits

The rate limits depend on your authentication method:

  • OAuth Authentication: 30 requests per minute
  • Service Account: 60 requests per minute

Google API Quota

SheetBridge proxies requests to Google Sheets API, which has its own quota limits. If Google's API returns a rate limit error (429), SheetBridge will:

  • Return a 429 status code with rate_limited: true in the error response
  • Include details about the rate limit in the error message
  • Automatically retry queued operations when quota becomes available

Handling Rate Limits

When you receive a 429 response, the error will include:

{
  "error": "Rate limit exceeded",
  "rate_limited": true,
  "message": "Additional details about the rate limit"
}

Best Practices

  1. Use Service Accounts - They provide higher rate limits (60 vs 30 requests/minute)
  2. Implement Retry Logic - Add exponential backoff when receiving 429 responses
  3. Batch Operations - Group multiple operations when possible
  4. Cache Responses - Cache frequently accessed data to reduce API calls

Related Topics


Powered by Converge