Google Sheets makes it easy to share and store important data in spreadsheets. Grow allows you to make the most of the data in your Google Sheets files by transforming it into clear, powerful visualizations. This article will give you an overview of the Google Sheets integration.
WHAT TO EXPECT
Here are some things that you can expect with the Google Spreadsheets integration.
It's not the same as Google Drive.You'll have access to all of your Google Sheets, but not to your Google Drive files. If you have files you want to upload you can use the File Upload option or another storage service like Box, DropBox, or OneDrive.
Formatting is the key to success. Here are a few simple things you can do to make your sheets easier to use and help you get the most out of Grow.
One sheet per dataset. 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 dataset for each sheet.
Uniquely Named Headers. If there isn’t a unique column header in your chart, we can’t add the data to your dataset.
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.
Google Sheets is a little bit different from other custom integrations. Instead of having set endpoints to build from, you can build metrics from the spreadsheets that you have access to in your Google Sheets account. Every time your spreadsheets update, Grow will automatically update those metrics.
Questions about Google Sheets? Email us at firstname.lastname@example.org or chat in on the site.