PUBLIC_google_drive_sheets_backup_files

PUBLIC_google_drive_sheets_backup_files.txt

// Sheet > Extensions > Apps Script
// Add Script
// Add trigger for script
// ------------------------------
// Backup script
function archiveCopy() {
  var file = DriveApp.getFileById("original_file_id_to_backup");
  var destination = DriveApp.getFolderById("backup_folder_name");

  var timeZone = Session.getScriptTimeZone();
  var formattedDate = Utilities.formatDate(new Date(),timeZone,"dd"); // 1 month backup, one per day
  var name = SpreadsheetApp.getActiveSpreadsheet().getName()+"_"+formattedDate;

  // remove old backup
  var allFiles = destination.getFilesByName(name);
  while (allFiles.hasNext()) {
    var thisFile = allFiles.next();
    thisFile.setTrashed(true);
  };

  // make new backup
  file.makeCopy(name,destination); 
}