Ensure you have a Zapier account created. Visit zapier.com to log in or create an account.
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.
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.
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.
