List all Google Drive Files and Folders

With Google Scripts you can generate a Google Drive Tree with all the files and folders (and sub-folders). You can either start with the root (main) folder or specify a folder name - this is helpful when you have tons of files in your Google Drive and retrieving the entire list can cause the script to time out.

/* Change the FOLDER NAME to generate tree for any specify folder */

function generateFolderTree() {
  try {
    // If you want a tree of any sub folder
    //var parent = DriveApp.getFoldersByName("FOLDER_NAME").next();

    // If you want to search from the top (root) folder
    var parentFolder = DriveApp.getRootFolder();

    getChildFolders(parentFolder);
  } catch (e) {
    Logger.log(e.toString());
  }
}

function getChildFolders(parent) {
  var childFolders = parent.getFolders();

  while (childFolders.hasNext()) {
    var childFolder = childFolders.next();

    Logger.log('Folder Name: ' + childFolder.getName());
    Logger.log('Folder URL:  ' + childFolder.getUrl());

    var files = childFolder.getFiles();

    while (files.hasNext()) {
      // Print list of files inside the folder
      Logger.log(files.next().getName());
    }

    // Recursive call for any sub-folders
    getChildFolders(childFolder);
  }
}

Amit Agarwal is a web geek, solo entrepreneur and loves making things on the Internet. Google recently awarded him the Google Developer Expert and Google Cloud Champion title for his work on Google Workspace and Google Apps Script.

Awards & Recognition

Google Developer Expert

Google Developer Expert

Google awarded us the Developer Expert title recogizing our work in Workspace

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional title for 5 years in a row

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator award for technical expertise

Want to stay up to date?
Sign up for our email newsletter.

We will never send any spam emails. Promise 🫶🏻