53_BackupService.gs

/**
 * BackupService - Serviço de Backup
 * @version 1.0.0
 */

var BackupService = (function() {
  
  var CONFIG = {
    BACKUP_FOLDER_NAME: 'Backups_Sistema',
    MAX_BACKUPS: 10
  };
  
  function createFull() {
    try {
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      var folder = getOrCreateBackupFolder();
      var timestamp = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), 'yyyy-MM-dd_HH-mm-ss');
      var backupName = 'Backup_' + timestamp;
      var backup = ss.copy(backupName);
      var file = DriveApp.getFileById(backup.getId());
      file.moveTo(folder);
      cleanOldBackups(folder);
      return { success: true, backupId: backup.getId(), backupName: backupName };
    } catch (error) {
      return { success: false, error: error.message };
    }
  }
  
  function getOrCreateBackupFolder() {
    var folders = DriveApp.getFoldersByName(CONFIG.BACKUP_FOLDER_NAME);
    return folders.hasNext() ? folders.next() : DriveApp.createFolder(CONFIG.BACKUP_FOLDER_NAME);
  }
  
  function cleanOldBackups(folder) {
    var files = folder.getFiles();
    var backups = [];
    while (files.hasNext()) {
      var file = files.next();
      backups.push({ file: file, date: file.getDateCreated() });
    }
    backups.sort(function(a, b) { return b.date - a.date; });
    for (var i = CONFIG.MAX_BACKUPS; i < backups.length; i++) {
      backups[i].file.setTrashed(true);
    }
  }
  
  function listBackups() {
    try {
      var folder = getOrCreateBackupFolder();
      var files = folder.getFiles();
      var backups = [];
      while (files.hasNext()) {
        var file = files.next();
        backups.push({ id: file.getId(), name: file.getName(), date: file.getDateCreated() });
      }
      return { success: true, backups: backups };
    } catch (error) {
      return { success: false, error: error.message };
    }
  }
  
  return { createFull: createFull, listBackups: listBackups, getOrCreateBackupFolder: getOrCreateBackupFolder };
})();

function autoBackup() {
  BackupService.createFull();
}