Google Sheets - Quota exceeded for quota metric

Questions
1

Hi,

I ran into some issues with the Google Sheets Node. This happened in several workflows but currently I’m working on a workflow where I get data from a Google Sheet via the Google Sheets node. I enrich the data via another tool (works like a charm) and then I want do update the sheet via Google Sheet node with “append or update row”. Since I do this for several rows the whole workflow is in a loop.

Before the Google Sheet nodes I already implemented a wait node with a 10 MINUTE wait to not run into quota exceeding - however I still get it, latest with the 10th object in the loop.

How is this possible? I cannot see how this workflow exceeds the read and write quote for Google Sheets indicated on the Google website. Because I also have no other workflows active/running at the same time.

Has anybody experienced the same problem? And found a solution?

Cheers,
Dom

2

This issue has disturbed google sheets node on n8n cloud for some time. It doesn’t matter how much quotas you actually want to use, you always run into this limit. We are still waiting for fix.

1 Like
3

okay thanks for the info. how long has the issue been reported / are you waiting for a fix?

might need to switch to another database if this keeps happening. Like this automation workflows with google sheets are useless.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.