Integrating with Microsoft OneDrive

Prerequisites

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

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. Review your data permissions and click Next and then select Read Only permissions.

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