Install the add-on from the Google Workspace marketplace. After that open a Google Sheet™, select Extensions → Drive Explorer for Dropbox → Launch.
Wait for the sidebar to fully load. Then, click on the Authorize Dropbox button to give access to your Dropbox.