Zapier is a service that allows non-technical users to connect a triggering event from one service with one or more actions in other services. There are hundreds of services connected to Zapier and each connection between services is called a Zap.
Here, we'll show you how to build a Zap, set up a bot in an AppSheet app to fire an event to trigger the Zap and send an email. Instead, you could use any of the hundreds of other Zapier actions.
To integrate with Zapier:
- Create a Zapier account.
- Click Create Zap to create a new Zap.
- Replace Name your zap with your Zap name in the top left.
- Set the Trigger to Webhook.
- Select Catch Hook in the Trigger Event drop-down and click Continue.
- Click Copy next to the Custom Webhook URL to the copy the URL. Then, click Continue.
- In the AppSheet app editor Call a webhook from a bot in your app.
- Paste the Zapier webhook URL copied in the previous step into the URL field of the Call a webhook task.
- Save your app.
- In your AppSheet application, make a data update and save it to trigger the AppSheet webhook.
You can do this by deploying and running your app or using the Test feature to execute the Call a webhook task. - In Zapier click on Test trigger. This tells Zapier that you've sent a trial webhook to the Zap to trigger it.
- If Zapier receives the webhook from your AppSheet app successfully, it displays the message
We found a request!
followed by the JSON webhook body sent by your AppSheet webhook. For example:
- Click Continue.
- Choose an action for the Zap, such as an Email by Zapier.
- Click Continue.
- Configure the action.
Note: You can use any of the fields from the updated record in AppSheet as they are all available in the payload sent from AppSheet.
- Click Continue.
- Click Test & Continue to test the Zap.
- Click Turn on Zap.
- Enable your AppSheet app to integrate it with the world via Zapier!