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.
Is there a (simple) way to integrate the SpreadsheetApp function of getSheetByName to only copy a specific sheet within a spreadsheet?