List and Insert all files (bulk) in a Google Drive folder in a Spreasheet

To list all files in a Google Drive folder in Google Sheets please follow these steps.

  1. Open FileDrop
  2. Click the Drive tab and navigate to the folder.
  3.  Click the insert all files button.

list files in google folder in sheets

The sheet will be populated with the files in the respective folder. Depending on the number of files in your folder it might take a few seconds.

In your Google Sheets file you will see the following fields:

  • Name
  • Date
  • Size
  • URL
  • Download
  • Description
  • Image

We will add more fields soon.

screenshot docs.google.com 2023.07.17 13 21 56