Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is Google Sheets API's Sheets automatically updated

I have a thread containing an infinite loop that should always be looking at the most recent version of a Google Sheet.

How much to recreate each iteration to ensure that my reference to it is updated?

  • The NetHttpTransport?
  • The Sheets object?
  • The Sheets#spreadsheets call?
  • The Sheets.Spreadsheet#values call?
  • Nothing, all parts of the API are always up-to-date?

I wasn't able to find anything in Javadoc.

like image 975
AAM111 Avatar asked Mar 26 '26 16:03

AAM111


1 Answers

There's a usage limit which is ~ 1 request per second per user:

This version of the Google Sheets API has a limit of 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. Limits for reads and writes are tracked separately. There is no daily usage limit.

As @TheMaster comment, API should be ~ always up-to-date,

You may use also Apps Script triggers:

you can only do it with the help of Apps Script. You can use a trigger here to detect if something is change in your spreadsheet.

like image 128
user7294900 Avatar answered Mar 29 '26 06:03

user7294900



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!