Search documentation...

K

Zapier

Use Zapier as a destination if you are trying to quickly migrate system or if you need to connect a service we do not yet support.

Overview

Zapier is best used for when there's a destination we do not yet support or if you want make a quick migration to using Hightouch from Zapier. Regardless, it is highly recommend you follow the steps to ensure a smooth setup as Zapier is quite unique compared to our other destinations

Using Zapier

Due to limitations, we use Zapier's webhook trigger to send data as it's they easiest way set up for users.

Rate limits

Something to keep in mind, as you process all your rows of data is that Zapier limits the amount of times Hightouch can send data to the webhook. For example, Zapier only accept 10,000 requests every 5 minutes. It's important to keep this in mind when selecting which triggers you want to acitvate for sending your records, as each record triggered will count as 1 request sent.
More Information On Zapier's Webhook Limit

Setup

Below are the steps to follow in text. However, we also created a video tutorial which you can follow here!

Step 1: Connect to Zapier

Creating Webhook URL in Zapier

  1. Log in to Zapier
  2. Click on Create Zap (skippable if editing zaps)
  3. Click on Trigger tab and select the Webhooks by Zapier trigger
  4. Click on Trigger Event, select Catch Hook, and then click Continue
  5. Copy your custom webhook URL
  6. Click Continue
It is important to not test the trigger until you are in the sync creation step

Adding destination in HT

  1. Log in to Hightouch or create a free Hightouch account
  2. Click on Destinations in the left sidebar
  3. Click on Add destination in the top right corner
  4. Select Zapier in the destination catalog and click Continue to proceed
  5. Paste your webhook url from Zapier into the **Zapier Webhook Trigger URL ** field and click Continue to proceed
  6. Give your destination a name and unique slug (e.g., "Zapier (Googlesheet Zap)" and "zapier-googlesheet-zap")
  7. Click Finish to create your Zapier destination!

Step 2: Connect to your data source

Hightouch sits on top of your data warehouse and can read from Snowflake, Redshift, BigQuery, Databricks, Postgres, MySQL, and many other data sources. You can even fetch data from Google Sheets and Airtable. Hightouch can help activate your data wherever it resides.
We'e written dedicated guides for each supported data source. Take your pick:
If you're missing the credentials necessary to connect to your data source, try inviting your teammates to Hightouch. You can have unlimited collaborators in your workspace!

Connect to a sample database instead

Waiting for credentials to your data warehouse? No problem! You can connect to one of our sample databases to get started right away. For the rest of this tutorial, we'll use our demo Postgres database, which contains a users table with names, emails, locations, and other user attributes. This sample source is available when you log in for the first time—no setup required.

Step 3: Create a model

In Hightouch, a model represents a query that filters or transforms the records in your data source. Models are used to determine exactly which records to sync between sources and destinations.
In this example, we'll keep it simple. Suppose you want to use Zapier to retrieve information for your customers located in the city of Nashville. To accomplish this, you'll want to create a model that looks like this:
  1. Click on Models in the left sidebar
  2. Click on Add model in the top right corner
  3. Select Demo Database as your source and click Continue to proceed
  4. Select SQL Editor as your modeling method
  5. Paste following the SQL query into the editor on the left side of the page
SELECT * FROM users WHERE location = 'Nashville';
  1. Click Preview to execute the query
  2. Click Continue to proceed
  3. Give your model a name and unique slug (e.g., "Users in Nashville" and users-in-nashville)
  4. Select id as the primary key for your model
  5. Click Finish to create your model!

Step 4: Create a sync

  1. Click on Syncs in the left sidebar
  2. Click on Add sync in the top right corner
  3. Select Users in Nashville as your model and click Continue to proceed
  4. Select Zapier as your destination and click Continue to proceed
  5. Select wheter you want to map your data or keep as is
  6. Click on Acknowledgement of testing checkbox to en
  7. Select Create a new segment
  8. Give a name to your segment (e.g., "My beta test")
  9. Click Continue to proceed to the last step
  10. Go back to the Zap you created, and click Test Trigger
  11. Verify that a request was found in Zapier
  12. Go back to Hightouch, and click Continue to proceed to the last step
  13. Select Interval to tell your sync to run on a set interval
  14. Configure your sync schedule to run every 5 minutes
  15. Click Finish to create your sync!

Troubleshooting

Common errors

Couldn't Find Request (Testing in Zapier)

If you've run into the error above, there are a couple reasons as to why you might get this screen.
  1. You tried to test the webhook trigger in Zapier, before you tested it in Hightouch.
  2. You tested in Hightouch, however you may have tested it for a trigger you did not enable. For example, if you selected to trigger on Record Changed, you need to make sure run test as Sync As Row Changed

Use the Hightouch debugger

Hightouch provides full visibility into the Zapier calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks.

Set up sync alerts

Hightouch can alert you of any sync issues via Slack, PagerDuty, SMS, and/or email. For details, please visit our article on alerting.

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    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.

On this page

OverviewUsing ZapierSetupStep 1: Connect to ZapierStep 2: Connect to your data sourceStep 3: Create a modelStep 4: Create a syncTroubleshootingCommon errorsCouldn't Find Request (Testing in Zapier)Use the Hightouch debuggerSet up sync alerts

Was this page helpful?