List all files in a Google Drive folder

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.

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.

list files in google folder in sheets

Get Our Latest Articles

Subscribe to our newsletter below to get amazing new Google Sheets articles, but also tips and tricks.