i have been looking for a way to timestamp my google sheet,

its working if i edit the cell and it work great exactly how i want it, however.

im not the on editing the sheet, its through a 3rd party application that just dumps data into the sheet in the background.

all i want to be able to do is open the sheet after awhile and see when the 3rd party did what etc.

im using createOnchangetrigger which is calling a function to input date into r.offset(0.6) which works fine. but like i say only when i actively go in and change something, not 3rd party :..)

ideally i dont want to look at this sheet, only when someone makes a mistake on 3rd party this collates all the 3rd applications in one place.

  • 1
    Hi and welcome. Not all 3rd party apps are made alike, so it would be best to edit your question to disclose the name of the app, frequency of update and any other relevant info about the app. On a tangent, some 3rd party apps include the ability to insert a timestamp into their update; have you checked with the apps developer about whether/how this is possible in your case? Another approach would be if there is a field that is known to change on update, then a time-driven trigger script might be a better alternative to onChange.
    – Tedinoz
    Dec 21, 2021 at 2:28
  • Checkout the built-in version history (File > Version history)
    – Rubén
    Dec 22, 2021 at 20:35


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy