Google SheetBrowser
How does it work from ?
Step 1: Install & launch the add-on
Install the add-on from the Google Workspace marketplace. After that open a Google Sheet, select Extensions → Drive Explorer for Dropbox → Launch.
Step 2: Authorize access to Dropbox
Wait for the sidebar to fully load. Then, click on the Authorize Dropbox button to give access to your Dropbox.
Step 3: Pick folders
From the Dropbox chooser (file picker), select the folders from which you want to fetch the files.
Step 4: Fetch files
On the interface, add or remove folders as needed. When ready, select Fetch files.
Step 5: Analyse files
Your file details are fetched from Dropbox and written on the Google Sheet.