Using a webhook with Zapier, you can export data out of the system to use with other platforms/systems. This can be helpful if you use multiple systems and want to export information into a spreadsheet for a variety of purposes for your business. Follow these steps to set up a Webhook.
Step 1: Create or Log In to your Zapier account.
-
Ensure you have a Zapier account created. Visit zapier.com to log in or create an account.
Step 2: Create a Workflow to execute a webhook
There are several options to do this. You can create a Workflow to fire off based on a form or survey being submitted, an appointment being booked, a trigger link being clicked, a two-step order form being completed, and more. In our example, we’ll use an appointment booking to export information into Google Sheets.
-
Create a trigger for your webhook by adding it to the workflow.
-
Here, we’re creating a trigger based on a specific calendar so that when appointments are booked in that calendar, the webhook will export information to Google Sheets.
-
We’ll need to retrieve the Webhook URL from Zapier to paste into a webhook action added after the trigger. Keep this window open for now so you can come back and paste the Webhook URL.
Step 3: Set up the Webook in Zapier.
-
In Zapier, set up your webhook accordingly so that the webhook app does the ‘catch hook’ action.
-
The Custom Webhook URL will be created.
-
Copy this URL and paste it into the trigger in the previous step.
-
Save and activate the trigger.
Step 4: Test the Webhook
-
In your system, navigate to the calendar you created the appointment booking trigger for.
-
Book an appointment in the calendar as a test.
-
Back in Zapier, click “Find Data” to retrieve the test appointment data you just submitted.
-
Now in Zapier, you can “Create Spreadsheet Row in Google Sheets”.
-
Map the fields appropriately. Here you’re essentially telling Zapier to pull the first name to the First Name column, last name to the Last Name column, etc. from the webhook.
-
Click Continue > Test & Continue > Done Editing.
-
Your Zap is now ready!
-
Navigate to Google Sheets to confirm it is working correctly, and you’re all set.