Auto Backup Google Sheets

Auto Backup for Google Sheets ensures your spreadsheet data is automatically saved at regular intervals. It helps prevent data loss, maintains version history, and allows easy recovery in case of accidental changes. Ideal for businesses and individuals who want secure, hands-free backups stored in Google Drive or other locations

Step 1: Click on the Copy button to copy the code snippet.
Step 2: Paste the copied code into your project’s script editor.

Apps Scripts Blog

Read Blog

AppSScript Code

function createBackup() {
  // Get the active spreadsheet
  var spreadsheet = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/1cdLeAOOVQyYYtjoMViEWr-8RW6yEdhfNjLynCsdpz6E/edit?gid=0#gid=0');
 
  // Name of the backup folder
  var folderName = "Backup youtube videos";
 
  // Get the root folder of the user's Google Drive
  var folders = DriveApp.getFoldersByName(folderName);
 
  // If folder doesn't exist, create it
  var folder;
  if (folders.hasNext()) {
    folder = folders.next();
  } else {
    folder = DriveApp.createFolder(folderName);
  }
 
  // Create a formatted timestamp with date and time
  var now = new Date();
  var formattedDate = Utilities.formatDate(now, Session.getScriptTimeZone(), 'yyyy-MM-dd HH-mm-ss');
 
  // Create a backup copy of the spreadsheet in the backup folder
  var backupFileName = spreadsheet.getName() + " Backup " + formattedDate;
 
  var backup = spreadsheet.copy(backupFileName);
 
  // Move the backup to the folder
  var file = DriveApp.getFileById(backup.getId());
  folder.addFile(file);
  DriveApp.getRootFolder().removeFile(file);  // Remove from root folder
   
  // Store backup link and date in the active sheet
  var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
 
  // Get backup sheet link
  var backupLink = file.getUrl();
 
  // Append the date and backup link to the active sheet
  activeSheet.appendRow([formattedDate, backupLink]);
 
  Logger.log("Backup created and stored in " + folder.getName());
}