Using Zapier’s Webhook you can also have SMS sent out based on your data actions!
The following will show you how to implement this using MessageBird.
1/ Go to Zapier and search for MessageBird:
2/ Select the appropriate Template (Webhook to MessageBird):
3/ Setting Up the Webhook (following template):
4/ At this step we will want to copy the generated webhook to bring into our LookML
5/ Define the field to use the LookML action
dimension: orders_update {
description: "Update for Orders to SMS"
sql: ${TABLE}.field) ;;
action: {
label: "outgoing text"
url: "https://hooks.zapier.com/hooks/catch/31995216/f4ei6d/"
icon_url: "https://cdn-gc.messagebird.com/assets/images/glyph.svg"
param: {
name: "sms"
value: "{{ value }}"
}
}
}
6/ Go to the explore and select that field, and click on the action:
7/ See the test successful in Zapier:
8/ Start setting up the MessageBird specific part of the mechanism:
9/ Connect to your MessageBird account (You will have to have an account created and provisioned to continue):
10/ You will be prompted to add the access key that was created on your account (Making sure the key your created is of type LIVE, not test):
11/ Additional account set up, naming this Zap:
12/ Editing the template (add origin number, content of sms, list of recipients and other optional parameters):
13/ Set up is complete!
14/ Go to your explore and start sending SMS
15/ Get the SMS!
