Google Sheets blocks my workflow (Even with Wait nodes)

[albertocabasvidani]

Google Sheets keeps blocking my workflows—even with multiple Wait nodes—with the error:
“The service is receiving too many requests from you.”

The parent and sub-workflows have many Google Sheets nodes.

I added several Wait blocks (with a wait time of 60-240 seconds) to slow things down, but the error keeps happening.
Is there a way to prevent this?

These are the nodes that more often generate the error:

Information on your n8n setup

• n8n version: 1.102.4
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main): For now click on EXECUTE WORKFLOW
• Running n8n via (Docker, npm, n8n cloud, desktop app): Cloud
• Operating system:

[fahmiiireza]

Hi there, there are couple of things that can trigger the error here, let me discuss it starting from the first image that you share

so, as you can see on ur first image, after the loop node, you are reading a sheet, where if the sheet has 100 row, then it will return 100 items as response, which means, on the next google sheet node, it will be triggered 100 times

so your wait node here is pointless, because thats how n8n runs their node, if theres a 100 items coming from the previous node, then the next node will be triggered 100 times in a short amount of time, which what makes you receive the rate limit error on this first image

and on the second image, its kind of the same issue, but it just happens because of a different node, i would say on the second imaage, it happens because of the Split Out node, after the facebook node, because the split out node, turns 1 Item into multiple item, so let’s say theres only 1 item in facebook node, the split out can split it into 100 items lets say

so when it goes to the sheet node, it gets triggered a 100 times

which again, will trigger the error that you currently facing

the solution to this, is to add another loop before every sheet node where before the sheet node there’s a lot of item
something like this

[fahmiiireza]

how is it goin @albertocabasvidani , if i help solve the issue please mark my answer as the solution