Zapier is a service that allows you to connect applications running on the Internet with each other and send data back and forth. They’ve got interfaces to lots of applications, like Google Sheets, Zendesk, Sendgrid, and lots of others.
It’s really easy to configure Zapier to receive the requests submitted by a Looker Data Action and to use the data in Looker to perform useful tasks in other applications, such as updating Zendesk tickets, sending email through Sendgrid or MailChimp, or sending messages in Slack!
This article will guide you through the basic steps of configuring Zapier to accept these responses. It’s super easy!
Step One: Select the Webhook Application
If you create a new Zap, you will be asked to select a trigger app first. Select Webhooks by Zapier.
Step Two: Select Catch Hook
Select the Catch Hook option, which will configure Zapier to listen for incoming HTTP requests, like our Data Action.
Step Three: Copy the Webhook URL from Zapier
Finally, we’ll copy the URL that Zapier gives us. This is the URL we need to send our Data Actions to, and is where Zapier will be waiting for our requests.
Step Four: Write Your Data Action
Next, we’ll use the URL from Zapier to write our Data Action. You can use this guide on how to write Data Actions, and its at this point that you decide what data goes into your requests. Every parameter and form that you put in the Data Action here will show up in the data that gets sent to Zapier.
Make sure to check for LookML validator errors before you move on to the next step!
If you’ll need any API credentials for doing stuff with the data after Zapier catches the webhook, add them here in a parameter so you can configure Zapier to authenticate to that API.
Step Five: Test the Data Action
You’ll always want to run a test of the webhook before you move on with working on the rest of the Zap, so at this point, we’re going to open up an Explore, add the dimension or measure that we added the Data Action to, and fire off the Data Action.
Step Six: Revel In Sweet Victory
If everything was configured properly and you don’t have any LookML validation errors, then Zapier should report a successful test! Click their link to open up the test data that you sent and examine it to make sure everything looks right.
From here, you can use Zapier to send this data to other services and applications so that you can do meaningful, useful things with it. The possibilities are endless, so let your imagination roam free and make something awesome! Good luck!
Share Your Cool Stuff
Did you make something cool using this guide as a starting point? Talk about it in the comments! We love hearing about how customers are using Looker to make their jobs easier and to do things that they couldn’t do before, and someone else might be inspired by your creation to make something for themselves.