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());
}