Using from a Google Sheet

After installing the add-on, select Extensions → Drive Explorer for OneDrive → Launch.

1. Select Authorize OneDrive to connect your OneDrive account.
2. Authorize access to Onedrive Explorer on the page opened.
3. Comeback to the sheet and select Pick from OneDrive.
4. Select one or more folders on the OneDrive file picker and click on Choose.
5. Now, the picked files should be listed on the sidebar.
6. Select Fetch files to list the file details within the chosen folder(s) on the Google Sheet.