It’s my first question on the forum. If I seem stupid, my apology.
I use n8n.cloud. I notice lately my workflow with Google Sheets node more and more often ran into the error “The service is receiving too many requests from you” as below. Even for one single execution within 10 minute. It never happened before until recently. The project number mentioned 498586711441 here is not created by me, and my own project in Google Cloud console showed no usage at all. I guess somehow n8n.cloud users share the 1k/minute quota. Am I right?
Hi thanks for the update! Looking forward to the fix.
Perhaps allowing n8n.cloud users use their own API credentials (via Google Cloud Console) is a not-bad idea, so that everyone uses their own quota.
I have the same issue. There are no loops in my workflow, and only a couple of simple Google Sheets nodes with max 2 filters. No idea why it’s exceeding the quota. No way I’m requesting over 100 requests a minute (or 8k which should be the limit)
You can try http node and call with google sheet api.
When creating credential, use google oauth 2 credential that can link to a client id and client secret instead of using google sheet oauth2 credential, which only asking you to login to assign credential.
Then when you calling the api, the quota usage will be shown on your google cloud dashboard. and it does not exceed the quota and the error does not happen on my side for now.
I think they definitely mix up the quota usage for different executions, even for different users, cuz this error also happens when you only do very few rows’ modification.
This only works with Http, cuz sheet node only supports Google Sheet Oauth2 credential while Http node supports Google Oauth2 credential which is more general and you can link it with a client id.
This issue doesn’t appear until now, only thing is you need to replace all of the sheet nodes with http node.