blessanm86

function importCSVFiles()
{
  var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  Logger.log(`Active Spreadsheet: ${ss.getName()}`);
  
  const rootFolderId = '1EDAXA7TbzCnzmczRMHD_LxoF0yopS5D2';                  // Root folder
  const csvFolderName = 'Data';                                              // Folder containing csv files and the Archive folder
  const archiveFolderId = '1clsKkp0bauYkbg0uQj8LfaHIQIrpJWO8';               // Archive Folder
  const destinationSheetName = 'final';                                      // destination sheet in spreadsheet