> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hightouch.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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's 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 activate for sending your records, as each record triggered will count as 1 request sent.

[More Information On Zapier's Webhook Limit](https://zapier.com/help/troubleshoot/behavior/rate-limits-and-throttling-in-zapier#step-4)

## Setup

### 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

   ![](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/destinations/destination-zapier-selectTrigger.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=251883b8c85c95b9ed1e774df752a4e0)
4. Click on **Trigger Event**, select **Catch Hook**, and then click **Continue**
5. Copy your custom webhook URL

   ![](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/destinations/destination-zapier-copyWebhook.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=082364534eacec389d5d5141b890205e)
6. Click **Continue**

> [!WARNING]
>
> it's 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 (for example, "Zapier (Google Sheet Zap)" and `zapier-googlesheet-zap`)
7. Click **Finish** to create your Zapier destination.

### 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've written dedicated guides for each supported data source. Take your pick:

* Connect to [Airtable](https://docs.hightouch.com/sources/airtable)
* Connect to [Amazon Athena](https://docs.hightouch.com/sources/amazon-athena.md)
* Connect to [Amazon Redshift](https://docs.hightouch.com/sources/amazon-redshift.md)
* Connect to [ClickHouse](https://docs.hightouch.com/sources/clickhouse.md)
* Connect to [Databricks](https://docs.hightouch.com/sources/databricks.md)
* Connect to [Elasticsearch](https://docs.hightouch.com/sources/elasticsearch)
* Connect to [Firebolt](https://docs.hightouch.com/sources/firebolt)
* Connect to [Google BigQuery](https://docs.hightouch.com/sources/google-bigquery.md)
* Connect to [Google Sheets](https://docs.hightouch.com/sources/google-sheets.md)
* Connect to [Looker](https://docs.hightouch.com/sources/looker)
* Connect to [Metabase](https://docs.hightouch.com/sources/metabase)
* Connect to [MySQL](https://docs.hightouch.com/sources/mysql.md)
* Connect to [PostgreSQL](https://docs.hightouch.com/sources/postgresql.md)
* Connect to [Rockset](https://docs.hightouch.com/sources/rockset)
* Connect to [SFTP](https://docs.hightouch.com/sources/sftp.md)
* Connect to [Snowflake](https://docs.hightouch.com/sources/snowflake.md)
* Connect to [SQL Server](https://docs.hightouch.com/sources/sqlserver.md)
* Connect to [Trino](https://docs.hightouch.com/sources/trino.md)

> [!NOTE]
>
> 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 datasets](https://docs.hightouch.com/sources/sample-data.md) to get started right away. For the rest of this tutorial, we'll use the **B2B SaaS** sample source, 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.

### 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

```sql theme={null}
SELECT * FROM users WHERE location = 'Nashville';
```

6. Click **Preview** to execute the query
7. Click **Continue** to proceed
8. Give your model a name and unique slug (for example, "Users in Nashville" and `users-in-nashville`)
9. Select **ID** as the primary key for your model
10. Click **Finish** to create your model.

### 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 whether 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 (for example, "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.

## Tips and troubleshooting

To see the exact API requests and responses from each sync run, use the [live debugger](https://docs.hightouch.com/syncs/debugger.md). To get notified by Slack, PagerDuty, SMS, or email when a sync fails, set up [sync alerts](https://docs.hightouch.com/syncs/alerting.md). If you run into an issue this page doesn't cover, [contact support](#pylon-chat).

## Common errors

### Couldn't find request

![](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/destinations/destination-zapier-missingRequest.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=2b60df00d8608d08960750cb5df0f87f)

There are a few reasons you may encounter this error:

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**

   ![](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/destinations/destination-zapier-correctTesting.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=1eeb339cfa595e2cd0a37c26cb527567)