Integrating with Microsoft OneDrive

Prerequisites

MS Admin Consent for Connecting OneDrive Accounts

Drivetrain Setup Step 1: Connect your OneDrive Account Step 2: Import File to Drivetrain Step 3: Add more Files to Drivetrain

Prerequisites

• The table you want to import should start from the first cell (A1) on the sheet

• None of the column headers should be empty

• There should only be one table per file

• Only .XLSX and .CSV files are supported

• Admin privileges in Drivetrain

MS Admin Consent for Connecting OneDrive Accounts

Before a user can connect their OneDrive account, Drivetrain requires MS admin's consent from the user's Microsoft 365 organisation. This consent allows Drivetrain to access and read files from the user's OneDrive account as part of the integration.

Please use this link to grant the consent, once you click on this link a new tab will open and will ask you to sign with your admin account if your are not already signed in. Select Consent on behalf of your organization and click on Accept, after clicking on Accept it will redirect to you to your Drivetrain's tenant.

Drivetrain Setup

Step 1: Connect your OneDrive Account

1. Click on + button on top left corner

1. Select the OneDrive connector under Spreadsheets category

1. On the pop-up, click Open Window, you will be redirected to the Microsoft login page.

2. If you're not signed into Microsoft, do that now, then select the account from which you want to import the data If you are already signed in, simply select the account from which you want to import the data.

1. Or select the account from which you want to upload the sheet if you are already signed in

1. After a successful login, you will be redirected back to Drivetrain Connected Integrations page which will ask you to paste the URL of the sheet you want to import

Step 2: Import File to Drivetrain

1. Open OneDrive and navigate to the file you want to import

2. Copy the URL of the file which needs to be imported

1. Paste your OneDrive File Link into the field provided and click Add

1. Please wait for some few mins until the sync is completed, the file you added will now show up in the list of tables on OneDrive connector

Step 3: Add more Files to Drivetrain

You can add more tables by using the Add data option as shown below

FAQ