Using from the Google Drive

This is the fastest among the two methods available. You can select one or more files/folders in your Google Drive dashboard, right-click, select Open with and click on Drive Explorer to list the file details on your browser (Refer to the image below).

To multi-select files/folders, you can press Ctrl (Cmd on Mac) or Shift and select. Drive Explorer lists all the sub-folders and their files when you list files from a parent folder. It goes on till there are files to list.

This is the recommended way when you want to list more than 10,000 files. The 10,000 limit is approximate and can vary based on the nested sub-folders level.
drive explorer in a browser tab

Motivation

Though you can fetch files directly inside a Google Sheet, there are some limitations (check issue #6). This method eliminates those limitations and lists every file it is supposed to. Also, you might not want to go to the Google Sheets to fetch one-off links of files. You can also export the listing as CSV simply by clicking a button.

You can see how many files you can list how fast in the below email screenshot. (Steve is okay with me sharing the screenshot here 😉)

drive explorer social proof

Running from the root level

You might want to list all the files from a particular Shared Drive or My Drive. It is possible. But, only do it when it's necessary. Because it can take a considerable amount of time, based on the number of files you have on the drive. From the root level of the Drive, select New (top left corner) → More → Drive Explorer.