Advertisement
Guest User

Untitled

a guest
Mar 26th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. // Get Folder Tree
  2. function getFolderTree(folderId, listAll) {
  3. try {
  4. // Get folder by id
  5. var parentFolder = DriveApp.getFolderById(folderId);
  6.  
  7. // Initialise the sheet
  8. var file, data, sheet = SpreadsheetApp.getActiveSheet().getSheetByName('raw-data');
  9. sheet.clear();
  10. sheet.appendRow(["Full Path", "Name", "Date", "URL", "Last Updated", "Description", "Size"]);
  11.  
  12. // Get files and folders
  13. getChildFolders(parentFolder.getName(), parentFolder, data, sheet, listAll);
  14.  
  15. } catch (e) {
  16. Logger.log(e.toString());
  17. }
  18. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement