How to recursively list Google Drive files and folders up to level N in javascript?

user_6201770 0
Viewed 1938

I need to list all files and folders of google drive up to some level. The code below is listing all the files and their folders (until it exceeds its time limit) and logs them. How to I add some way to stop if it recursively went, let´s say, 3 levels of subfolders?

function listFolders(folder) {
  folder = folder || DriveApp.getRootFolder();
  var folderName = folder.getName();
  var files = folder.getFiles();
  while (files.hasNext()) {
    var fileName = files.next().getName();
    Logger.log(folderName + " :: " + fileName);
  }
  var subfolders = folder.getFolders();
  while (subfolders.hasNext()) {
    listFolders(subfolders.next());
  }
}
google-drive-api google-apps-script javascript
2 Answers

How about this modification? I think that there are several answers for your situation. So please think of this as just one of them.

Modified script:

When you use this modified script, please run main().

function main() { // Added
  const folder = // Please set here.
  const n = 3; // Please set here. This sample sets 3 as your question.
  listFolders(folder, n);
}

function listFolders(folder, n) { // Modified
  folder = folder || DriveApp.getRootFolder();
  var folderName = folder.getName();
  var files = folder.getFiles();
  while (files.hasNext()) {
    var fileName = files.next().getName();
    Logger.log(folderName + " :: " + fileName);
  }

  if (--n == 0) return; // Added

  var subfolders = folder.getFolders();
  while (subfolders.hasNext()) {
    listFolders(subfolders.next(), n); // Modified
  }
}

Note:

  • Your script is Google Apps Script. So I modified your script as Google Apps Script.
  • Please modify it for your situation.

If I misunderstood your question, please tell me. I would like to modify it.

user_71086530

I tried to modify the code to take a folder Id as such, but my code doesn't work, any idea?

I would also like to add the URL of every folder next to it if possible.

function onOpen() {     
  var SS = SpreadsheetApp.getActiveSpreadsheet();
  var ui = SpreadsheetApp.getUi();                      
SpreadsheetApp.getUi()                              
.createMenu('Custom Scripts')                               
.addItem('List All Files and Folders', 'listFilesAndFolders')                       
.addToUi();         
}
                    
function listFilesAndFolders(){
  var folderId = Browser.inputBox('Enter folder ID', Browser.Buttons.OK_CANCEL);
  if (folderId === "") {
    Browser.msgBox('Folder ID is invalid');
    return;
  }
  myFunction(folderId); 
};


function myFunction(folderId) {
  const folder = DriveApp.getFolderById(folderId)
  const n = 3; // Please set here. This sample sets 3 as your question.
  listFolders(folder, n);
}

function listFolders(folder, n) {
  var folderName = folder.getName();
  var files = folder.getFiles();
  while (files.hasNext()) {
    var fileName = files.next().getName();
    Logger.log(folderName + " :: " + fileName);
  }

  if (--n == 0) return;

  var subfolders = folder.getFolders();
  while (subfolders.hasNext()) {
    listFolders(subfolders.next(), n);
  }
}
user_191285430
Related