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.