List your

OneDrive file details

on a

Google Sheet

drive explorer for onedrive - listing onedrive files on a google sheet

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.

launching onedrive explorer in a google sheet

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.

authorize access to onedrive in drive explorer for 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.

drive explorer for onedrive pick folders using onedrive file picker

Step 4: Fetch files

On the interface, add or remove folders as needed. When ready, select Fetch files.

selected folder/file list drive explorer for onedrive

Step 5: Analyse files

Your file details are fetched from OneDrive and written on the Google Sheet.
drive explorer for onedrive - listing onedrive files on a google sheet
HomeDocumentationPricingSupportPrivacy
© 2024 Drive Explorer for OneDrive