After installing the add-on, select Extensions → Drive Explorer for Dropbox → Launch from a Google Sheet™.
Select Authorize Dropbox to connect your Dropbox account.
Authorize access to Drive Explorer for Dropbox on the page opened.
Comeback to the sheet and select Pick from Dropbox.
Select one or more folders on the Dropbox file picker and click on Choose.
Now, the picked files should be listed on the sidebar.
Select Fetch files to list the file details within the chosen folder(s) on the Google Sheet™.
To refer to the image for each step, check the landing page.
Ready to list Dropbox files at spreadsheet speed?
Install Drive Explorer from the Google Workspace Marketplace today and start exporting Dropbox file metadata, folder structures, and details directly inside Google Sheets.