Google Sheets

Google Sheets is a web-based spreadsheet offered by Google as part of their Drive office services. It makes it easy to create, edit and collaborate with others from any device.

Overview

Hightouch lets you pull data stored in Google Sheets and push it to downstream destinations. Before connecting your Google Sheets, it's best to make sure they meet formatting requirements.

Google Sheets formatting requirements

• Your Google Sheet must be a Sheets file, not an .XLS or .XLSX file. If this is the case, you need to convert it to a Sheets file. To do so, go to File > Save as Google Sheets.
• Your Google Sheet must have column names in the first row of your sheet. In the following image, you can see that the column names are id, created_at, name, website, and description.

Connection configuration

To get started, go to the Sources overview page and click the Add source button. Select Google Sheets and follow the steps below.

Authorize connection

1. Click Log in to Google Sheets and select the desired Google Account.
2. After reading what authorization you're giving to Hightouch, select Allow.
3. Select the Spreadsheet containg the data you wish to sync from the dropdown.
4. Click Continue.

Test your connection

When setting up Google Sheets as a source for the first time, Hightouch checks that you have the correct permissions. Once the test passes, click Continue to finish setup.

Next steps

Once your source configuration has passed the necessary validation, your source setup is complete. Next, you can set up models to define which data you want to pull from Google Sheets.

Model setup

1. In Hightouch, go to the Models overview page.
2. Click Add model.
3. Select the Google Sheets source you previously created.
4. Select the Sheet name of the data you want to sync. Hightouch treats each sheet as a separate table. If you want to sync data from multiple sheets, you need to set up a separate model for each one.
5. Preview your model's query results.
6. Click Continue.
7. Name your model and select its primary key. Hightouch uses the primary key to determine which rows have been added, changed, or removed since the last sync.

Tips and troubleshooting

If you encounter an error or question not listed below and need assistance, don't hesitate to reach out. We're here to help.

Internal error encountered

This error may occur when the spreadsheet you're syncing to contains sheets with charts or pivot tables. Try moving the data you would like to update with Hightouch to a separate spreadsheet. Then reference this data's range using a formula like IMPORTRANGE in the spreadsheet with your charts and analysis. This way, the sheet that Hightouch updates won't have the timeout issue, and you can still see the data on the sheet that contains charts or pivot tables.