Google Sheets Setup Guide

This document describes the Google Sheets data source.

To configure this data source and collect Google Sheets data:

1. From the Data Sources menu, click Add Data Source.
2. Search for Google Sheets, then select that data source.
3. Click Sign in with Google and follow Google’s authorization process to allow Panoply to access Google Sheets data.
4. Enter the Sheets identifiers or URLs
   • The file must be a Google Sheets file. We do not support other file types.
   • By default, for each file, Panoply collects each individual sheet (tab) as a unique table.
   • Sheets must include headers.
     • The first row that contains at least one value will be used as the header row. This row is converted into column names in the target tables. See our Google Sheets demo file with properly formatted sample data.
     • If there is a duplicated header, the column letter will be appended to the header name in the format of <header name> column <column letter>. For example, if there are two columns titled date, the second column titled date will be appended with the column letter, becoming date column b.
     • If a column contains data, but has no header, Panoply will fill in the header with column <column letter>, for example column b.
     • If a column has a header but no data, the column will not be collected.
5. Click Save Changes then click Collect.
   • The data source appears grayed out while the collection runs.
   • You may add additional data sources while this collection runs.
   • You can monitor this collection from the Jobs page or the Data Sources page.
   • After a successful collection, navigate to the Tables page to review the data results.

This is all that is necessary to start collecting your data from Google Sheets, however there are a number of Advanced Settings you can use to customize your source. We do not recommend changing Advanced Settings unless you are an experienced Panoply user.