Google Sheets

Overview

Grouparoo’s Google Sheets integration is a Source that enables you to import data from a Google Sheet to any of the Destinations we support. You can use Grouparoo to sync data between a Google Sheet and other supported services to operationalize your data.

Sources

Setup

From the Google API Console, you’ll need to navigate to the credentials page using the left hand menu. There, you will see a list of service accounts. The email for the service account you are using is needed to set up an app connection to Google Sheets. Select the service account you will use and, if you haven’t already saved one, create a new JSON key. This will give you the information needed to create an App that connects Grouparoo and Google Sheets.

App

To connect Google Sheets to Grouparoo, you create an App to tell Grouparoo how to connect to Google Sheets. This specifies the location of the data you want to sync data to or from. When you go on to create the Source, you will further specify which table it should data should be pulled from.

App Options

Google Sheets Import

This type of Source reads from a single Google Sheets tab using a primary key reference. Properties can be generated from row values in the table you choose to link.

Options

Mapping

Defining Mappings is a critical part of the process. It tells Grouparoo which Record to associate with the imported data.

If you are using Google Sheets Import as the primary source, choose the Google Sheet column that uniquely identifies Records in your Model. This will often be the primary key of the table that represents your Model. The Property mapped to this column will be assigned as the Model's Primary Key.

In secondary sources, choose the Google Sheet column that ties this table to your primary source. This will often be a foreign key in your table.

Schedule

Create a schedule to actively pull new data from this Google Sheets table. If the recurring option is not selected, you are creating a one-time sync. There are also options to confirm records exist when running a schedule and to enable refresh.

Options

Google Sheet Import Sources have no further options for configuration.

Filters

Google Sheet Import Sources do not support schedule related filters in configuration.

Properties

Properties populate your Records with data from your Google Sheets table based on table columns. Create a Property to be able to use row data in Grouparoo.

Options

Filters

Google Sheet Import Sources do not support property related filters in configuration.

Notes

We strive to keep our documentation accurate, easy to use, and up to date. If you notice that something has changed or is not addressed in the process of setting up your Grouparoo connection with Google Sheets, please let us know by reaching out to help@grouparoo.com.

As always, if you need support using Grouparoo, reach out to community members in our Slack channel. We are always happy to help!