gas_all_files_in_google_drive_folder.gs

// replace your-folder below with the folder for which you want a listing
function listFolderContents() {
  var id = 'xxxxx';
  
  var folders = DriveApp.getFolderById(id).getFolders()
  Logger.log(folders);
  while (folders.hasNext()) {
    var folder = folders.next();
    Logger.log(folder.getName());
    var contents = folder.getFiles();
  
    var folderlisting = 'listing of folder ' + folder.getName();
    var ss = SpreadsheetApp.create(folderlisting);
    var sheet = ss.getActiveSheet();
    sheet.appendRow( ['name', 'link'] );
    
    var file;
    var name;
    var link;
    var row;
    while(contents.hasNext()) {
      file = contents.next();
      name = file.getName();
      link = file.getUrl();
      sheet.appendRow( [name, link] );     
    }      
  }
  
};