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.
I could not find any solution for Google Apps Script. The only thing I could find is this: https://stackoverflow.com/questions/58708728/apply-original-comments-in-a-copied-document