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.
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.
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.
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.
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.
Select the Google Sheets source you previously created.
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.
Preview your model's query results.
Click Continue.
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.
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.
Ready to get started?
Jump right in or a book a demo. Your first destination is always free.