Read files name inside a folder (Spreadsheet Files Name, ID & SpreadSheet First Sheet Name) Using GAS

Read files name inside a folder (Spreadsheet Files Name, ID & SpreadSheet First Sheet Name) Using GAS

function CollateData() {

  const fls=DriveApp.getFolderById('1OHgxKOzer2GdsBtT8ZcATNeEkHhMraU7').getFiles();

  let fl;

  const ss=SpreadsheetApp.getActiveSpreadsheet();

  const sht=ss.getSheetByName('Sheet2');

  let counter=2;

  let ss2;

  while(fls.hasNext()){

    fl=fls.next();

 

    if(fl.getName()!="Master Sheet" && fl.getMimeType()=="application/vnd.google-apps.spreadsheet"){

      sht.getRange(counter,2).setValue(fl.getId());

      sht.getRange(counter,3).setValue(fl.getName());

      ss2=SpreadsheetApp.openById(fl.getId());

      sht.getRange(counter,4).setValue(ss2.getSheets()[0].getName());

      counter=counter+1;

    }

  }

}