OneDrive

OneDrive is a simple, secure, cloud-based file sharing and collaboration services that make it easy for your teams to manage and share your documents and work together in real time on any device. Many Grow users store exported files with supported formats in their synced OneDrive folders from platforms that may not yet have an integration with Grow. This means you don't have to worry about excluding any of your important data from Grow metrics. Whenever the OneDrive files behind your metrics are updated, Grow will update your metrics to reflect the change.

Here are some things you can expect from the OneDrive/Grow integration.

The OneDrive and OneDrive Business integrations have been merged into one integration called OneDrive.

In this article, we will cover:

Connecting to OneDrive

Before starting, please collect your Microsoft email and password.

  1. Select the Data tab next to the Dashboard.
    This takes you to the Data Overview page.
  2. Click on the Connections button.
  3. Select the blue Connect button at the end of the Your Top Data Sources options.
  4. From the list of Connections, search and select OneDrive.
  5. Click on Connect to OneDrive.
  6. Enter the Microsoft account credentials you use for OneDrive.
  7. Select Accept on the permission request page to grant Grow access to your OneDrive.

If you didn't see a window to enter your credentials but you still got a green success message, that means you were already logged in with your Microsoft account and Grow used that account to connect.

Data Warehousing

OneDrive is on the Grow Data Warehouse, which we highly recommend you use. For more information about warehousing your data, visit the Data Warehouse Help Article.

Tables

For warehoused files, think of a table as an individual spreadsheet within a file. By default, the tables inherit the name of the file and the selected sheet.
For example, Sales YTD Sheet1.

Warehousing your Data

  1. In the Connections Overview Page, click on your OneDrive connection.
    This opens the Connection Details page.
  2. Select the Manage Connection button inside the Connection Details section to open the warehouse table selection flow.
  3. Select the data you want stored in the Data Warehouse and click the Sync & Store button at the bottom of the Manage Connection page.
    This begins the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, sometimes up to several hours.

You may continue working within the app while your data is In Queue or Processing.

Sync Interval

Full Sync

The default sync interval is 12 hours per table.

Incremental Sync

Incremental sync is not currently available for OneDrive tables.

To learn more about sync intervals and how to adjust the default settings, please visit the sync section of the Data Warehouse help article.

Direct Query

The OneDrive integration is unlike most other integrations in that there aren't any specific endpoints to choose from after you connect your account. You simply choose the OneDrive files that you want to use to create your metrics, and Grow proceeds to pull data directly from the source.

FAQs

How can I make sure my data is secure?

We have several controls in place to keep your data safe. Check out our security article to see what steps you can take to keep your data safe.

How do I prepare my spreadsheets to use in Grow?

It's important to make sure your spreadsheets are formatted appropriately so you can easily use them in Grow. We strongly recommend you consult this help article for tips to prepare your spreadsheets.

Where can I find a file that is shared with me through another account?

Any file that is shared directly with your OneDrive account can be found within the Shared with me folder.
If the file you are looking for is missing from that folder, do verify that the file was shared with the same account you have connected to Grow.

This feature is only available in the warehouse and not direct query.

Was this article helpful?