https://floffi.media/en/web/create-list-of-files-in-a-google-drive-folder/

listAllFilesInFolder.gs

function listAllFilesInFolder() {
  var foldername = 'XYZ';
  var filename = 'files_' + foldername;

  var folder = DriveApp.getFoldersByName(foldername).next();
  var sheet = SpreadsheetApp.create(filename).getActiveSheet();

  var file;
  var data = [];
  var re = /(?:\.([^.]+))?$/;
  var files = folder.getFiles();

  data.push(['Name', 'Extension', 'Owner', 'Date created', 'Date modified', 'Size', 'Link']);

  while (files.hasNext()) {
    file = files.next();
    data.push([
      file.getName(),
      '.' + re.exec(file.getName())[1],
      file.getOwner().getName(),
      file.getDateCreated(),
      file.getLastUpdated(),
      file.getSize(),
      file.getUrl()
    ]);
  }

  sheet.getRange(1, 1, data.length, data[0].length).setValues(data).setNumberFormat('@STRING@');
  sheet.getRange(1, 1, 1, data[0].length).setFontWeight('bold');
  sheet.autoResizeColumns(1, data[0].length);
}