Google Sheets component failing with "not available" and "too many requests"

Questions
1

Describe the problem/error/question

I keep getting this error, of sending too many read requests to google sheets. I had a few automations, that listed for triggers in google sheets, which I understand could lead to many read requests. But I switched off all those automations and now only have one that runs once an hour and then writes to google sheets. How can it still cause those errors?

What is the error message (if any)?

“Quota exceeded for quota metric ‘Read requests’ and limit ‘Read requests per minute’ of service
‘sheets.googleapis.com’ for consumer ‘project_number:’.”,
“message”: “The service is receiving too many requests from you”

Please share your workflow

I could not share the whole workflow, because the string is too long to be a valid post to this forum

Share the output returned by the last node

Information on your n8n setup

  • n8n version:> [email protected]
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

The only scenario of such behaviour that comes to my mind is when the GSheet node is called too many times because of the many input items while you might need to run the node only once. If that is the case, each node has settings to instruct the node to run once no matter how many input items there are. If you do need to have many iteration of the node you could use Loop with Wait to pause in between iterations.

3

I am having same issue as you with Google Sheets node, which never happened before.
My unprofessional guess is all n8n cloud users share the same quota with Google. Now with more and more users on n8n cloud, the quota 1000 per minute is not enough anymore.

4

Hello

We noticed this issue already and are working on fixing it.

It should be resolved soon!

Thank you all.