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 ; ...