You’re offline. This is a read only version of the page.
103
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
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!
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
Share
Report
All responses (
Answers (
