Update_Sheet.txt

function Update_Sheet() {
  var destinationFolder = 'ADD YOUR FOLDER ID HERE'; // Google Drive Folder ID where the sheet should be saved
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var s=ss.getActiveSheet();
  var spreadsheet = SpreadsheetApp.getActive();
  var spreadsheetname = spreadsheet.getName();
  spreadsheet.getRange('A2:F10000').activate();
  spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
  var c=s.getRange('A2').activate();
  var fldr=DriveApp.getFolderById(destinationFolder);
  var files=fldr.getFiles();
  var names=[],f,str;
  while (files.hasNext()) {
    f=files.next();
    str='ArrayFormula(split("' + f.getUrl() + '|' + f.getName() + '|' + f.getDateCreated() + '|' + f.getLastUpdated() + '|' + f.getMimeType() + '|' + spreadsheetname + '","|"))';
    names.push([str]);
  }
  s.getRange(c.getRow(),c.getColumn(),names.length).setFormulas(names);
};

// Function to move the Google Sheet to the specific folder in Google Drive
function moveSheetToFolder(sheetId, folderId) {
  var file = DriveApp.getFileById(sheetId);
  var folder = DriveApp.getFolderById(folderId);

  // Remove the file from its previous folder(s) and add to the new folder
  var parents = file.getParents();
  while (parents.hasNext()) {
    var parent = parents.next();
    parent.removeFile(file);
  }

  // Add file to the new folder
  folder.addFile(file);
}