Answered

API requests limit when using Google Sheets connector

(0) Share

Report

Posted on by Elowy GrootCRM

157

I'm struggling to find a solution for reading a few hundred rows from four shared Google Sheets. During the flow development, I encounter rate limit errors after a few minutes of work ("Too many requests sent to the Google Sheets API."). Additionally, when I initiate the flow, I quickly hit the rate limit as well.

Has anyone encountered similar issues with this connector? Specifically, any experience with managing the rate limit? Is there an option to pay Google to increase the limit (from the Power Automate connector)?

Thank you for your assistance!

Best regards,

Elowy

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Gdarmon Outlook 372 on at

Like (0)

Report
Copy link

Link copied!

According to Google’s documentation, the Google Sheets API has per-minute quotas that are refilled every minute. For example, there’s a read request limit of 300 per minute per project. If your app sends 350 requests in one minute, the additional 50 requests exceed the quota and generates a 429: Too many requests HTTP status code response.
To manage the rate limit, you can try using an exponential backoff algorithm to retry requests that fail due to rate limiting. An exponential backoff algorithm retries requests using exponentially increasing wait times between requests, up to a maximum backoff time. If requests are still unsuccessful, it’s important that the delays between requests increase over time until the request is successful.

Gill

Was this reply helpful? Yes No
Elowy GrootCRM 157 on at

Like (0)

Report
Copy link

Link copied!

Appreciate it, Gill!

I did come across these limits eventually, but it seems they are (somehow) even more restrictive. Perhaps there are more requests per action under the hood. Even when I make an update call every 2 seconds, it still hits the limits, and, somehow, it gets blocked for several minutes.

I've also incorporated the retry time. However, most of the time you have to endure a prolonged wait before the flow becomes successful.

Once again, thank you for your response!

Was this reply helpful? Yes No