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.
Hey, here's my version of the script that lets you back up several files in the same parent backup folder, and keep x backups of these files (it creates a folder in the parent folder for each file you want to backup, and store the different versions of the file in this folder). It works with any file (not just sheets). To use it you just have to create a project and create a trigger for the
run
function.