function getFileIdAndNames() {

 var FileFolderID = '1HA0XDnc1m1ZBM2aiedU3L7qiFTPEf8t5'; // the ID of the folder with files
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = ss.getSheets()[0];
 var urlCol = 1;
 var urlRow = 1;
 var folder = DriveApp.getFolderById(FileFolderID);
 var files = folder.getFiles();

 sheet.clear();

 while (files.hasNext()) {
 var file = files.next();
 
 
   if (file.getName().indexOf(".png") != -1) {
     sheet.getRange(urlRow, urlCol).setValue(file.getName());
     sheet.getRange(urlRow, urlCol+1).setValue(file.getId());
     sheet.getRange(urlRow, urlCol+2).setValue('https://drive.google.com/uc?export=download&id='+ file.getId());
     sheet.getRange(urlRow, urlCol+3).setValue('PNG');
     sheet.getRange(urlRow, urlCol+4).setValue(Math.round(file.getSize()/1000) + " KB");
     sheet.getRange(urlRow, urlCol+5).setValue(file.getName().substr(7).slice(0, -4));
   } 
   
 urlRow = urlRow+1;
 }
  sheet.sort(1, true);
  sheet.sort(4, true);
  sheet.insertRows(1);
  var title = [["Filename","File ID","Direct Link to Download","File Type","File Size (KB)","Description"]];
  var fontStyles = [ [ "bold", "bold", "bold", "bold", "bold","bold" ]];
  var titleRange = sheet.getRange("A1:F1");
  titleRange.setValues(title);
  titleRange.setFontWeights(fontStyles);
 }