On google drive I have a directory with over 1000 subfolders. I want to list all subfolders with the total amount of files for each subfolder. This is the script I got so far but it doesn't work cause it's just listing 0 for all subfolders

// replace your-folder below with the root folder for which you want a listing
function listFolderContents() {
  var foldername = 'CC-Part2';
  var folderlisting = 'listing of folder ' + foldername;

  var folders = DriveApp.getFoldersByName(foldername)
  var folder = folders.next();
  var contents = folder.getFolders();

  var ss = SpreadsheetApp.create(folderlisting);
  var sheet = ss.getActiveSheet();
  sheet.appendRow( ['name', 'size'] );

  var subfolder;
  var name;
  var size;
  var row;
  while(contents.hasNext()) {
    subfolder = contents.next();
    name = subfolder.getName();
    size = subfolder.getSize();
    sheet.appendRow( [name, size] );     

Can anyone help me fix this script?

1 Answer 1


You can find a script on labnol.org which is like the 'tree' command in DOS but for Google Drive.

To get started, click here and authorize the script to access the files in your Google Drive. Once the authorization is complete, it may take a minute to generate the entire Google Drive tree. You’ll then get a link to download an HTML file that mirrors your Drive structure. You can directly send the file to the printer as well.

  • This is almost a link only answer which are consider low quality posts. Please add the most relevant pars for que referred source as it could be unavailable in the future. Commented Jul 30, 2019 at 13:52
  • Your answer is in another castle. Please edit the essentials into your text.
    – user55949
    Commented Aug 20, 2019 at 10:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.