How to check Google Sheet Api quota

Hi all, is there any way to check how many request I did for the Google Sheet API?

I use Oauth2 Sheet Api to authorize the HTTP and Sheet Node, and it is not connected to a specific project. Can I check the quota use under this situation? is there a way to increase the quota?

And below are some of the errors I encountered. I believe they are mostly because of the quota usage and I have tried to apply wait node to decrease the calling frequency and retry them for a few times. Is there any other way to fix them or improve the stability of the flow?

  • 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’.

  • Service unavailable - try again later or consider setting this node to retry automatically (in the node settings) The service is currently unavailable.

  • The service was not able to process your request
    Internal error encountered.

    500 - "{\n \"error\": {\n \"code\": 500,\n \"message\": \"Internal error encountered.\",\n \"status\": \"INTERNAL\"\n }\n}\n"
    Request
    { "headers": { "accept": "application/json,text/html,application/xhtml+xml,application/xml,text/*;q=0.9, image/*;q=0.8, */*;q=0.7", "Authorization": "**hidden**" }, "method": "GET", "uri": "https://sheets.googleapis.com/v4/spreadsheets/13cww-QPXZgPi_g8AE/values/SUMMARY!A:A", "gzip": true, "rejectUnauthorized": true, "followRedirect": true, "resolveWithFullResponse": true, "followAllRedirects": true, "timeout": 300000, "encoding": null, "json": false, "useStream": true }
    

I believe you can check the request rate in the Services and APIs in the associated Google Cloud Project.

That is the issue. when authorizing n8n oauth2 credential, I just login the google account and didn’t link the credential to any of the project, and I can not locate which project is calling the sheet api.

So that I understand, the issue is you have too many Google Cloud projects to figure out which was used or none at all and thus the request cannot be associated with any specific one?

yeah that’s almost what I mean. Is there a way to associate the api usage to a specific project so that I can better control the quota use, either increasing or monitoring.

My idea is getting an access token each execution and use the token to call the api instead of using the n8n credential. But I have some human in loop node and the token may expire before getting response from human.

For the question I finally found that we can define more customized Oauth2 credential such as Google Oauth2 instead of Google Sheet Credential, allowing the credential connecting with specific project and client. Thus showing the detailed calling of api at Google Cloud Dashboard.

But this seems only works for HTTP node, and Google Sheet node has to authorize by logging in without binding a client id.

1 Like

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