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's highly recommend you follow the steps to ensure a smooth setup as Zapier is quite unique compared to our other destinations
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 activate for sending your records, as each record triggered will count as 1 request sent.
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've 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.
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.
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:
Click on Models in the left sidebar
Click on Add model in the top right corner
Select Demo Database as your source and click Continue to proceed
Select SQL Editor as your modeling method
Paste following the SQL query into the editor on the left side of the page
SELECT*FROM users WHERE location ='Nashville';
Click Preview to execute the query
Click Continue to proceed
Give your model a name and unique slug (for example, "Users in Nashville" and users-in-nashville)
There are a few reasons you may encounter this error:
You tried to test the webhook trigger in Zapier, before you tested it in Hightouch.
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
Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.