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.
I’m experiencing the same issue. I frequently hit Google Sheets quota limits even though I’m only making a relatively small number of requests. It’s been a recurring problem and still persists today. I’d really appreciate an update from the n8n team on when this is expected to be fixed, or if there’s any official workaround planned.
Latest development: quota limits happen more and more often. Now it’s in almost every run of Google Sheets Node, no matter how small alteration it is about. Setting node’s retry helps a bit. But it makes one execution last much longer time.
Ongoing Google Sheets API Quota Issues on n8n Cloud
We are experiencing persistent Google Sheets API quota exceedance errors, similar to those reported in this thread. Our workflow runs hourly via Schedule Trigger and includes 6 appendOrUpdate operations, each with 1 item input, yet fails with “Quota exceeded for quota metric ‘Write requests’ and limit ‘Write requests per minute per user’ of service ‘sheets.googleapis.com’ for consumer ‘project_number:1037940517691’”. Errors occur at Google Sheet Nodes with no output data.
So far, we have spent over 6 hours debugging, adding Wait nodes (120-720 seconds delays) to space writes, but the issue remains unresolved. Google Cloud Console shows 0% usage, suggesting shared quotas on n8n Cloud. Please, confirm if this is the case and provide an update on fixes or workarounds, especially the HTTP node approach with Google OAuth2 credentials suggested by @Samyyy.
I tried adding wait time, also turned on Retry at Failure. But this error just happens randomly. Now I have to say Google Sheets on n8n is almost not usable any more. I am considering to get rid of n8n cloud or Google Sheets.
Same here. We are on a Starter Plan for a year, and the Google Sheets workflow is our only active one. If this does not work, what is the point?
It is disappointing to see that one of the most popular integrations (according to the n8n website footer) is broken, and yet no one from n8n support is stepping in to clarify the issue, provide a timeline for a fix, or suggest workarounds.
let us know if not
.