How does it work?
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 OneDrive → Launch.
Step 2: Authorize access to OneDrive
Wait for the sidebar to fully load. Then, click on the Authorize OneDrive button to give access to your OneDrive.
Step 3: Pick folders
After successful authorization, select Pick from OneDrive to open the OneDrive file picker to 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 OneDrive and written on the Google Sheet™.