Facebook
From Botched Stork, 3 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 37
  1. function list_all_files_inside_one_folder_without_subfolders(){
  2.   var sh = SpreadsheetApp.getActiveSheet();
  3.   var folder = DriveApp.getFolderById('1mx-C16lEB22Y-ZHx1-BurfGWa6jKSnOi'); // change the folder ID  here
  4.   var list = [];
  5.   sh.getRangeList(['A1:Z999']).clearContent()
  6.   list.push(['Name','Type','Size','Url']);
  7.   var files = folder.getFiles();
  8.   while (files.hasNext()){
  9.     file = files.next();
  10.     var row = []
  11.     row.push(file.getName(),file.getMimeType(),file.getSize(), file.getUrl())
  12.     list.push(row);
  13.   }
  14.    sh.getRange(1,1,list.length,list[0].length).setValues(list);
  15. }
  16.