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.
Ready to get started?
Jump right in or a book a demo. Your first destination is always free.