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.
Setup
Create the Google Sheets connection in Hightouch
-
In Hightouch, go to Sources or click https://app.hightouch.io/sources
-
Click "Create Source"
-
Select Google Sheets.
-
Click Authorize a new Google account and select the desired Google account.
-
Click Select Google Sheet and pick a spreadsheet from the Google Picker popup.
-
Click the Test button.
-
If Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page
Properly Formatting and Querying your Google Sheet
Example

SELECT id, name FROM Data
- Connection issues with your data warehouse?
- Confusing API responses from destination systems?
- Unsupported destination objects or modes?
- Help with complex SQL queries?
Need help?
Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.
or
Feature Requests?
If you see something that's missing from our app, let us know and we'll work with you to build it!
We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.