takeidlink

function list_all_files_inside_one_folder_without_subfolders(){
  var sh = SpreadsheetApp.getActiveSheet();
  var folder = DriveApp.getFolderById('XXXXXXXXXXXXXXXXX'); // I change the folder ID  here
  var list = [];
  list.push(['Name','ID','url']);
  var files = folder.getFiles();
  while (files.hasNext()){
    file = files.next();
    var row = []
    row.push(file.getName(),file.getId(),file.getUrl())
    list.push(row);
  }
   sh.getRange(3,6,list.length,list[0].length).setValues(list);
}