I got this Process where it involves reading and writing into google sheets many times. sometimes the proceess runs smoothly without any erros but sometimes, i get this error called Number of ApI calls to google sheets exceeded and i get a project number. To solve this, I added 60 seconds delay between some reading and writing google sheet activities. but the dull side for this solutions is that it takes too much time. Is there any way to increase the number of calls can be made to the sheets ? please help out here !
The rate limit is imposed by Google Sheets API, so it’s google where you can seek for help. Here’s an article on their docs that might help: Usage limits | Google Sheets | Google for Developers
Hi George,
Quick question about this, since we are facing the same issue.
On the Usage limits that you referred, it says that “Depending on your project’s resource usage, you might want to request a quota increase.”
Since the integration is managed by UiPath, I assume that the project exists on the UiPath infra and that it would be through that project that one could raise a rate increase request.
Please help me to understand if I missed the point here, but it seems that a Google admin from our organization for example, wouldn’t be able to request such limit to be raised, no?
Hi @bhaskar, did you end up finding the solution?
In order to have control over the Usage limits, use your own application in Integration Service and not the UiPath one which may be used by multiple users at the same time.
If even in your custom application, you have the same issue, either you are retrying after a period of time when that usage limit is refreshed, or you can get in contact with Google to increase that limit for you.
Hi Marian,
This limit is impacting the process as it is slowing down our process, I am keen to get this sorted, thanks for your reply.
The issue that I have is that in every documentation I read they point us to request the rate increase within a Google Cloud project that is hitting the endpoint.
So I am afraid that they might need to know which project needs to have the rate increased.
Could you point us any documentation that indicates otherwise, that we have to reach out to google via a support ticket to get the rate increased for the whole organization and not for a particular project?
Thanks in advance
If you are using your custom application in Google Cloud Console, download the Fiddler Classic in the Studio/Robot machine.
Start the capturing in the Fiddler
Replicate the behavior of the process
Stop the Fiddler capturing
Observe the Rest API call that has throws that limit error.
Observe in the RAW request the details of the project
There you will see the exact project and other useful details.
Then you can go to your Google Cloud Console project admin and check further with Google.
Let me know if you were able to find those details in the Fiddler.