Drivetrain Integration Guide
  • INTEGRATION GUIDE
    • Integrate with Drivetrain
      • Accounting & ERP
        • Integrating with Certinia
        • Integrating with NetSuite
        • Integrating with QuickBooks
        • Integrating with Rillet
        • Integrating with Sage Intacct
        • Integrating with Tally
        • Integrating with Xero
        • Integrating with Zoho Books
      • BI
        • Integrating with Looker
        • Integrating with Tableau
      • Billing & Invoicing
        • Integrating with Chargebee
        • Integrating with Invoiced
        • Integrating with Maxio Chargify
        • Integrating with Maxio SaaSOptics
        • Integrating with Recurly
        • Integrating with Stripe
        • Integrating with Subscript
      • CRM
        • Integrating with Active Campaign
        • Integrating with HubSpot
        • Integrating with LeadSquared
        • Integrating with Outreach
        • Integrating with Pipedrive
        • Integrating with Salesforce
      • Customer Success
        • Integrating with ChurnZero
        • Integrating with Freshdesk
        • Integrating with Planhat
        • Integrating with Zendesk
      • Databases and Warehouses
        • Integrating with Azure SQL Server
        • Integrating with BigQuery
        • Integrating with Databricks
        • Integrating with Redshift
        • Integrating with S3
        • Integrating with Snowflake
        • Integrating with Snowflake (Small Datasets)
        • Integrating with Google Cloud Storage
        • Integrating with Postgres
      • HRIS & ATS
        • Integrating with ADP
        • Integrating with ADP Workforce Now (SFTP)
        • Integrating with Ashby
        • Integrating with BambooHR
        • Integrating with Darwinbox
        • Integrating with Deel
        • Integrating with Greenhouse
        • Integrating with Gusto
        • Integrating with HiBob
        • Integrating with Justworks
        • Integrating with Lever
        • Integrating with Namely
        • Integrating with Paylocity
        • Integrating with Personio
        • Integrating with Sapling
        • Integrating with UKG Pro
        • Integrating with Zenefits
      • Spreadsheets
        • Integrating with Airtable
        • Integrating with Google Drive
        • Integrating with Google Sheets
        • Integrating with Microsoft OneDrive
      • Others
        • Integrating with Brex
        • Integrating with Clari
        • Integrating with NetSuite (Role Based Access)
        • Integrating with Shopify
        • Integrating with Twilio
        • Integrating with Officevibe
        • Integrating with SFTP
        • Integrating with Drivetrain's SFTP
        • Setting up SSO
Powered by GitBook
On this page
  • Prerequisites
  • Drivetrain Setup
  • Step 1: Connect your OneDrive Account
  • Step 2: Import File to Drivetrain
  • Step 3: Add more Files to Drivetrain
  • FAQ

Was this helpful?

  1. INTEGRATION GUIDE
  2. Integrate with Drivetrain
  3. Spreadsheets

Integrating with Microsoft OneDrive

PreviousIntegrating with Google SheetsNextOthers

Last updated 2 months ago

Was this helpful?

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 OneDriveConnector 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

Please copy the URL using the address bar (see below image) and not using the copy link option available in OneDrive

  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

Can I load/refresh data from a OneDrive File?

Yes, you can connect your OneDrive Account to Drivetrain. It'll be synced (i.e, refreshed) with the changes at predefined intervals. Alternatively, you can also . Refer to the above guide for more details

trigger a manual sync
Prerequisites
Drivetrain Setup
Step 1: Connect your OneDrive Account
Step 2: Import File to Drivetrain
Step 3: Add more Files to Drivetrain
Page cover image