Overview
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. Here are some things you can expect from the OneDrive/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 Add Metric. Select OneDrive from the list of Data Sources, then click connect.
- In order to connect your account, you’ll need to sign in to the Microsoft account you use for OneDrive. Enter your email and password.
- After you sign in, Microsoft will ask you if you want to give Grow access to your account. Go ahead and click Yes.
And that's it! You are good to go.
Endpoints
Instead of having set endpoints that you can pull from, OneDrive lets you pull in the files you have hosted on OneDrive. This can be useful if you have exported files from platforms that may not yet have an integration with Grow. Whenever the OneDrive data files are updated, your metrics will automatically update to reflect the change.
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.
Size Limits
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.