List files in bulk from Google Drive folder

To list all the files in a Google Drive folder in Google Sheets please first copy the folder ID.

Note: It’s recommended to use this method for folders with fewer than 5000 files due to current limitations.

1. Go to the Folder Tools Sidebar
2. Add the Folder ID
3. Click on the button List files.