How to "Schedule Automatic Backups" of your Google Sheets
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.