cover
💥

Google API error - [429] Quota exceeded of service 'sheets.googleapis.com'

Why this error?

The Google API limits the number of read and write operations per minute per user.

You are very likely to reach that limit with automation, especially when automations trigger all at once at the very same time. Which happens if you have never changed the default schedule time (7:30am) when you create a bot or a megabot.

Google API is used by millions of sites. We put limits and quotas on API requests to protect the system from receiving more data than it can handle, and to ensure an equitable distribution of the system resources. The limits and quotas are subject to change.

source: Limits and Quotas on API Requests - google.com

How to fix it?

To fix this, I suggest you update your bots / megabots scheduling a little.

Go though your bots and megabots and space out their schedules a bit. Something like:

  • 7:00am
  • 7:05am
  • ...
  • 7:30am

Cheers,

François.