How can we see the quota used when we use the google sheet node on n8n cloud hosted and not self hosted?

adam_starta · May 27, 2025, 11:14am

Hey, guys hope you doing well. I have a problem in my google sheet node this is a hosted in n8n. I got this error

The service is receiving too many requests from you

Quota exceeded for quota metric ‘Read requests’ and limit ‘Read requests per minute’ of service ‘sheets.googleapis.com’ for consumer ‘project_number:498586711441’.

My question are ff:

how can we see the quota used when we use the google sheet node?
how does the quota work?
Why do we get quota limit on this workflow where we do only 4 rows append. as you can see it says read limit
Where can we see the quota status? how much we used?
Do we have to use the http request node for that?

darrell_tw · May 27, 2025, 12:07pm

There are several reasons

Not only n8n is using the GCP project. Maybe there are other service using as well.
Google Sheet API Quota
Using Http Request node is the same as using Google Sheet node. Both of them are using the same Google Sheet API.

adam_starta · May 27, 2025, 12:23pm

currently check the google console account of that email uses the google sheet node

I can’t see any logs here.

adam_starta · May 27, 2025, 12:51pm

Additional info: all our workflows are hosted in n8n Cloud, not self-hosted. Therefore, I don’t think we can access Google Sheets API quota usage directly since you never set a client id or client secret of a google console project in the google sheet n8n credential. Is there a good way to handle this, or another method to monitor our quota usage? only other option i see is to use the http request node with a bearer token from the google console project. then you would be able to see the usage

Chaima_Belkacem · May 27, 2025, 12:58pm

Hello Adam. In the page you just shared on the screenshot, you can click on the chart next to the three dots on the right and see how many requests you have made up to now and all the details.

Also you can ask google to increase you the quota by clicking the 3 dots .

Also as i can see , your read request is 60. per user/minute, it should be more otherwise you will have quota limit exceeded on n8n google sheet node.

In my case i am using 600 request user/ minute as i am treating a large file.

adam_starta · May 27, 2025, 1:08pm

Hi Chalma, thank you for the reply. My question is this: are you using an HTTP Request node to call the Google Sheets API or the built-in Google Sheets node? And is your workflow hosted on n8n?

Chaima_Belkacem · May 27, 2025, 1:10pm

I am using the built-in Google Sheets node and it’s self hosted wf in n8n

adam_starta · May 27, 2025, 1:11pm

When n8n is not self hosted does it use n8n own google console project?

Chaima_Belkacem · May 27, 2025, 1:18pm

It is the same page of google cloud api you shared in the screenshot above

Or you can find all metrics here : https://console.cloud.google.com/apis/api/sheets.googleapis.com/metrics

Let me know if you were able to find it

adam_starta · May 27, 2025, 1:21pm

You can connect your project because it’s self-hosted, right? If it isn’t, can we still monitor usage? I saw this thread (https://community.n8n.io/t/do-n8n-cloud-users-share-google-sheets-quota/73596/2) but haven’t received an answer. My goal is to view the quota usage in the Google Console for our n8n Cloud–hosted workflows. Currently, I believe I need to use an HTTP Request node, since it’s the only way to reference the client ID and client secret for a specific project.

Chaima_Belkacem · May 27, 2025, 1:25pm

My project on google clound is independent from n8n.

I created my project on google cloud and used the secret key and client to connect to the api of google sheet , so only google sheet credentials are mine i didn’t need a http request .

If you can share how you are connectint to google sheet maybe i can help you better.

adam_starta · May 27, 2025, 1:29pm

Create a credentials
Select google sheets OAuth2 API
Connect Using OAuth2
Sign in with Google

You can check the image below for your reference.

Chaima_Belkacem · May 27, 2025, 1:33pm

So this is independent from n8n , the error your encountring is related to your GCP.

Have you checked the sextion Measured value in your Google cloud project

adam_starta · May 27, 2025, 1:37pm

We have multiple projects in the Google Console, but n8n Cloud doesn’t let you enter your own client ID and secret, so it can’t know which project’s quota to use. I believe n8n uses the same credentials for everyone.

adam_starta · May 27, 2025, 1:45pm

I think, to be able to see quota inside google console for n8n cloud hosted, you currently have to use the http request node. Maybe somebody of the n8n staff can confirm this.

darrell_tw · May 27, 2025, 1:46pm

In this case. Yes there is no much we can do.

I remembered this kind of issue happened before.

They should already patch a fix. Maybe the same issue happens.

adam_starta · May 27, 2025, 2:10pm

okey thanks, i think i will switch then to n8n self hosted to fix this problem.