STEP-1 : Open your spreadsheet
STEP-2 : Click Tools menu
STEP-3 : Click script editor
STEP-4 : Add this code
-------------------------------------
*Note: Create in your google My Drive a folder name 'Backup' the backup file will save in your Backup folder.
// Make copy of current spreadsheet with backup name.
function SpreadSheetBackup() {
// Get current spreadsheet.
var ss = SpreadsheetApp.getActiveSpreadsheet();
// spreadsheet with date.
var file = DocsList.getFileById(ss.getId());
var bssName = Utilities.formatDate(new Date(), "GMT", "yyyyMMdd");
var fileCopied = file.makeCopy(bssName);
// Make sure all the formulae have been evaluated...
SpreadsheetApp.flush();
// Go to the (collection) a specified folder
var folder = DocsList.getFolder('Backup');
fileCopied.addToFolder(folder);
// and remove it from your root folder
fileCopied.removeFromFolder(DocsList.getRootFolder());
}
-------------------------------------
STEP-5 : Click Resources menu
STEP-6 : Click Current project's triggers
STEP-7 : Select Run 'SpreadSheetBackup'
STEP-8 : Select Events 'Time-driven'
