OneDrive for Business makes it easy for your teams to manage and share your documents and work together in real time on any device. This article will give you an overview of the OneDrive Business/Grow integration.
NOTE: This data source is available for accounts on the Starter, Basics, and Professional plans.
How to Connect
Before starting, please collect your Microsoft email and password.
- First, log in to your Grow account and click connect.
- This will bring you into the sign-in page for your organizational Microsoft account. Go ahead and sign in to your account.
- Once you have signed in to your account, you’ll be brought back to Grow. Here, you’ll need to choose what site you want to connect to.
- Once you select a site, press Get Data
And that's it! You are good to go.
Instead of having set endpoints that you can pull from, OneDrive Business lets you pull in the files you have hosted in your OneDrive enterprise/business/institution account. This can be useful if you have exported files from platforms that may not yet have an integration with Grow.
FAQs + Tips and Tricks
One Sheet per Report
For Excel-based files, you can select 1 sheet at a time. So if you have an Excel doc with multiple sheets, you need to create a report for each sheet.
Uniquely Named Headers
If there isn’t a unique column header in your chart, you will have difficulty using Grow’s transform tools as we wont know which columns to filter, group, pivot, etc.
Google places has some size limits on spreadsheets. If you are getting close to any of these limits, you'll get a warning at the top of your spreadsheet (in Google Sheets) telling you which limit you are about to reach. The sheets can have a total of 400,000 cells across all sheets (within one spreadsheet), 256 columns per sheet, 40,000 cells containing formulas, and 100 sheets per workbook.
Supported File Formats
XLS, XLSX, XLSM, and CSV. If you're looking to use JSON or XML files, Grow can pull those in, but we suggest converting to a CSV first.
Pulling Sharepoint Files
Grow does not have an integration with Sharepoint. You can, however, pull your Sharepoint files into Grow through the OneDrive Business integration. For additional information please see the section below called Sharepoint.
While Grow doesn’t have an integration with Sharepoint, there is a way to pull some files in Sharepoint into Grow.
Files hosted in Sharepoint can be pulled through Grow’s OneDrive Business integration. In order to access these files, they need to be hosted in Sharepoint shared folders. Grow can pull Excel spreadsheets from your Sharepoint account. Tables, lists, and any other content on Sharepoint are not supported in Grow.
To pull your Sharepoint files into Grow, log in to your Grow account and click Add Metric. Select OneDrive Business from the list of data sources and connect your account (if it is not already connected).
You will be able to access your shared folders once you have connected your account.