My sheet gets updated automatically every five minutes. How can I save the previous data, i.e., data just before each update, so that I can keep all data. I also want to make a line graph which automatically redraws after each update, every 5 minutes. Note: if you need my google sheet I will share it with you.


1 Answer 1


You will need an Apps Script function that periodically stores archival copies of the data. The function should run on a time-driven trigger.

To exclude data that has already been archived, insert a helper sheet, and use the =filter(isna(match())) pattern to only get rows that are present in the data but not in the archive. Then point your archival function to the helper sheet.

See these scripts for sample code:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.