Backup Google Sheets Daily

Code.gs

//Credit Reserved to : 
//Abhijeet Chopra
//26 February 2016
//URL : https://gist.github.com/abhijeetchopra/99a11fb6016a70287112
//~~ Herman 18122018


function makeCopy() {
  //Time stamp generation. Storing variable in formatted date as days, dd-MM-YYY
  const formattedDate = Utilities.formatDate(new Date(),"GMT+10:00", "EEE, d MMM yyyy");
  
  //Get name of original file and appending date at the end as name.
  const saveAs = "Copy "+ SpreadsheetApp.getActiveSpreadsheet().getName() + " " + formattedDate;
  
  // Get folder destination by ID :
  const destinationFolder = DriveApp.getFolderById("1iPMY2be4cSQe0J6W-Bkw8asA6RFP-PG6");
  
  DriveApp.getFileById(SpreadsheetApp.getActiveSpreadsheet().getId()).makeCopy(saveAs, destinationFolder);
}