This is the fastest among the two methods available. It's a five step process.
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.
By default, when you select Fetch files
on the webpage opened, Drive Explorer will try to list all the files it can find. Alternatively, you can apply special filters to ONLY fetch the files you need. For now, following filters are supported,
Only list the files that contains specific set of words. For example, within a folder you could list the files that contains the word "Report".
This is to fetch the files created before or after a specific date. If you want to list the files that are created after 11 May, 2023, you can select 11 May, 2023 in the Start date
field before fetching files.
You can use End date
field to list the files created before a specific date.
You can filter files by type as well. Select one or more types from the dropdown. You can even input a custom mimetype. For example, to fetch only the gzip files from a folder, input application/gzip
, choose Create "application/gzip"
from the dropdown and select Fetch files
.
After fetching the files with filter, you can alter the filter to fetch different set of files or remove all filter values to fetch all files.
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 😉)
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.