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 }