ht
Documentation
WelcomeConcepts

Get Started

OverviewCreate a sourceCreate a modelCreate a destinationCreate a sync

Sources

Amazon RedshiftDatabricksGoogle BigQueryGoogle SheetsLookerMySQLPostgreSQLSnowflake
Documentation/Sources/Google Sheets
ht
Documentation

Google Sheets

Table of Contents
Setup

Setup

Create the Google Sheets connection in Hightouch

  1. In Hightouch, go to Sources or click https://app.hightouch.io/sources
  1. Click "Create Source"
  1. Select Google Sheets.
  2. Click Authorize a new Google account and select the desired Google account.
  3. Click Select Google Sheet and pick a spreadsheet from the Google Picker popup.
  4. Click the Test button.
  5. If Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page
If not, contact Hightouch at hello@hightouch.io, and we're happy to assist you.

Properly Formatting and Querying your Google Sheet

Your Google Sheet must have column names in Row 1 (the first row).When querying your Google Sheet, the sheet names are used as the table names.

Example

Here in our spreadsheet named "Google Sheets Demo", "Data" and "Work" serve as the table names. "Id", "Created At", "Name", "Website", and "Description" are the column names.An example query is below:
SELECT id, name FROM Data