Menu
Calls like spreadsheets.batchUpdate and spreadsheets.values.batchUpdate can take multiple update actions in a single call.
I read about google sheets api usage limits at https://developers.google.com/sheets/api/limits, however it is not clear if these calls would count as one or multiple requests. Could you explain?
Thanks
307
We've increased the cell limit in Google Sheets from up to five million cells to up to ten million cells. This limit applies to new, existing, and imported files.
Google Spreadsheets are extremely powerful and convert very well from Excel, but they do have some limitations: Up to 10 million cells for spreadsheets that are created in or converted to Google Sheets. 40,000 new rows at a time. Maximum number of columns of 18,278 columns.
At spreadsheets.batchUpdate and spreadsheets.values.batchUpdate, even when multiple requests are included in one batch request of batchUpdate, the request uses only one API.
For example, when 10 requests are included in the request body of batchUpdate and the request body is run by batchUpdate, only one API is used.
About the maximum requests in one batchUpdate, I have never investigated this. But in my experience, when I had used 100,000 requests in one batchUpdate, I could confirm that the script worked fine.
If I misunderstood your question, I apologize.
79
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
