Power Platform Community Forum Thread Details

I'm encountering a throttling error in my Power Automate flow when inserting rows into a Google Sheet. The error message is:

Alert: Your operation has been throttled.
Looks like your flow's operation is hitting an action limit designed to protect the connector service being called.

Flow Structure

Trigger: Recurrence
Step 1: Run a Query Against a dataset (0.6 sec)
Step 2: Parse JSON (0 s)
Step 3: Apply to Each (Iterates over 545 items)
- Action: Insert row into Google Sheets
- Error Code: 429 (Throttling)
- Duration: ~10 minutes before failure

What I’ve Tried

Verified that the loop is inserting rows one-by-one, which likely exceeds the rate limit.
The error message suggests the connector is being protected from overload.

Please assist in avoiding Throttling Error in Power Automate Flow – Code 429 with Google Sheets Connector

Categories:

Building flows

Hey @CU29100525-0,

Your trigger is recurrent how often does it run?

Here is a link to the trhotteling liit of this connector: Google Sheets - Connectors | Microsoft Learn .

As you can see there the limit is at 100 calls for 5 minutes (=300 seconds).

One workaround is to force your flow to pause between calls.
You can do this by adding a Delay action after each call.
The delay should be around 4 seconds, since 300 ÷ 100 = 3 (one call every 3 seconds).
To stay on the safe side, 4 seconds is better.

A better long-term solution would be to:

Reduce the number of items your flow processes, or
Adjust your trigger so it changes less data at once.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!