This tutorial demonstrates how to use Google Apps Script to:
-
Create copies of the Google Sheet in the desired destination folder automatically at set intervals.
-
Append the time stamp with each backup file's name.
-
Adjust time trigger for backing up every day/hour/minute.
In case useful: creates a copy of the sheets and copy/paste only values.
This script replaces formula with calculated static values.
Huge sheet? -> might run into execution time limit (which is 6 minutes for consumer accounts). Because script reads and writes each cell individually.
If =IMPORTRANGE() is buggy, resulting in #REF! -> try following and ensure that, original spreadsheet (is fully loaded and all IMPORTRANGE functions have completed loading their data before you run this script + source and target spreadsheet have same structure and sheet names.