7

I am trying to fetch data from a google sheet using Google sheet API V4. Is it possible anyhow to know if someone has saved a data or made changes on the sheet? Based on that I want to make call to the api to get the data? More like I am trying to keep my application synced with the google sheet. As soon as someone update the data, my application gets updated too. I am using Nodejs. How do I do that? Thanks in advance

Linda Lawton - DaImTo
  • 106,405
  • 32
  • 180
  • 449
Subhendu Kundu
  • 3,618
  • 6
  • 26
  • 57
  • 4
    Unfortunately, this is not possible using Google Sheets API. You may want to check this [pending feature request](https://issuetracker.google.com/issues/36759149). Try using Drive API - [Detect Changes](https://developers.google.com/drive/v3/web/manage-changes) or [Apps Script - Simple Trigger OnChange()](https://developers.google.com/apps-script/guides/triggers/) for workaround. Hope this helps. – Mr.Rebot May 18 '17 at 16:09
  • You could create a schedule to download the sheet every minute and compare it with the previous to check for changes. – kemp Apr 21 '21 at 12:51

0 Answers0