This script will automatically save spreadsheet sheets when edited in Google docs.

backup.js

function myOnEdit() {
  var fileId = "1Ly5SSIE9d-b_IA6VxDB1HF3pnf37SPf22KhZVv3PPiVA1w";
  var folderId = "1S1F8NpjOfbxY_4n27llfqh6eOs3Kb1eojaq";
  
  var file = DriveApp.getFileById(fileId);
  var folder = DriveApp.getFolderById(folderId);
  
  var now = new Date();
  var fileNameDate = now.getFullYear() + "-" + zeroPrefix_(now.getMonth()+1) + "-" + zeroPrefix_(now.getDate()) + 'T' + zeroPrefix_(now.getHours()) + ":" + zeroPrefix_(now.getMinutes()) + ":" + zeroPrefix_(now.getSeconds())
  
  // backup file
  if (file && folder) {
    var filename = file.getName() + " - " + fileNameDate;
    file.makeCopy(filename, folder)
  }
}

function zeroPrefix_(s) {
  return ('0' + s).slice(-2);
}

google_drive_auto_backup

This script will automatically save spreadsheet sheets when edited in Google docs. 

Installation:
* Open your google spreadsheet
* Open the script editor by clicking on Tools -> Script Editor
* Paste this code into the script editor

* Change the fileId to file you want to backup, 
eg. https://docs.google.com/spreadsheets/d/1Ly5SSIE9d-b_IA6VxDB1HF3pnf37SPf22KhZVv3PPiVA1w/edit#gid=966474823
the fileId would be: 
1Ly5SSIE9d-b_IA6VxDB1HF3pnf37SPf22KhZVv3PPiVA1w

* Change the folderId to the folder you want to save the backups in, 
eg. https://drive.google.com/drive/folders/1S1F8NpjOfbxY_4n27llfqh6eOs3Kb1eojaq
the folderId would be: 
1S1F8NpjOfbxY_4n27llfqh6eOs3Kb1eojaq

* Select Resources -> Current project's triggers
* Click "Add a new trigger"
* Under the "Run" column select "myOnEdit" and under the "Events" column select "From spreadsheet" and "On edit"
* Click "Save" to close the triggers dialog
* Select File->Save to save the script

Great code! Super simple when there are tons of other alternatives that really do the same but with twice the number of lines!
Very useful. Thank you so much for your contribution

Great code! Super simple when there are tons of other alternatives that really do the same but with twice the number of lines!
Very useful. Thank you so much for your contribution

Thanks for the feedback! Appreciated