# ↗️ Webhook Action Tutorial

**URL:** <https://community.glideapps.com/t/webhook-action-tutorial/20905>\
**Category:** Community Resources\
**Tags:** tutorial\
**Created:** [January 8, 2021, 8:09pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905 "2021-01-08T20:09:29Z")\
**Posts on this page:** 20\
**Page:** 4

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [January 13, 2021, 9:17pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/61 "2021-01-13T21:17:30Z")

</div>

Would love to, @Rosewebstudio

> [@Lucas\_Pires](#):
>
> - specific per device - iOS push notifications with integromat ✨

But, as I said here, Integromat only allows us to do it with phones which has the Integromat already installed in it.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc998d13003c5a4ed611da1d20f5e44ffa70f817.png)

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [January 13, 2021, 9:21pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/62 "2021-01-13T21:21:36Z")

</div>

Ahh I see, maybe one day 🤔 thanks

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 13, 2021, 9:29pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/63 "2021-01-13T21:29:08Z")

</div>

Right…it requires a third party app. Others exist out there too, like push bullet.

---

<div class="post-metadata">

**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\
**Post date:** [January 13, 2021, 9:45pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/64 "2021-01-13T21:45:52Z")

</div>

I have to do the recording for this!! I’ll share it here next week

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 3:54pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/65 "2021-02-04T15:54:17Z")

</div>

How would you do this for a mass email, would you just have the cell referenced contain all emails separated by a space or comma?

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 3:55pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/66 "2021-02-04T15:55:52Z")

</div>

It works using their phone number@carriers text address (example [9185551234@txt.att.net](mailto:9185551234@txt.att.net))

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 4, 2021, 4:00pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/67 "2021-02-04T16:00:34Z")

</div>

Yep! Do a join column with comma separated addresses and place that in the BCC field

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 4:01pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/68 "2021-02-04T16:01:30Z")

</div>

Thanks Robert, I figured it would be that simple but I didnt want to test it and send 100 emails to people and piss them off.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 4:07pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/69 "2021-02-04T16:07:33Z")

</div>

> [@Robert\_Petitto](#):
>
> join column with comma separated addresses

So I’m using this formula to avoid blanks since the list will change and increase or decrease in size:

```
=JOIN( ", ",FILTER(A2:A,NOT(A2:A = "")))

```

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 4, 2021, 4:08pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/70 "2021-02-04T16:08:55Z")

</div>

Ya, I’m always nervous about doing that as well whenever a client wants me to add in that functionality to an existing live app.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 4:09pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/71 "2021-02-04T16:09:27Z")

</div>

Same…I’ve been using my scripts but I figured might as well try the webhook way.

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [February 4, 2021, 4:20pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/72 "2021-02-04T16:20:31Z")

</div>

I dont know how to set up this

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 4:21pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/73 "2021-02-04T16:21:01Z")

</div>

The values is just the column that has the list of emails to send to. It filters out the blanks and separates them with a comma.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 4:23pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/74 "2021-02-04T16:23:42Z")

</div>

Is that what you were looking for? Or the script way? Ahh, I think I know what your refering to. Ok, so what I did was gather every carriers email to text address. I listed them here.

> [@Free push notifications Workaround](https://community.glideapps.com/t/free-push-notifications-solved/6183):
>
> I have a solution for PUSH NOTIFICATIONS. It works with IOS and ANDROID. It is quick and has ZERO cost to everyone. You can do this in your google sheet or a separate sheet that is linked to your original (I used 4 linked sheets, I’ll explain later). 1st you setup on your sheet a variable or value you are wanting to trigger the notification. This data will need a VLOOKUP formula to link to the person you want notified’s phone number and phone carrier, so when the vlaue on the sheet is found usin…

With those I just have everyone in the app add their phone number and choose one of these carriers from a drop down list. It’s mandatory for our employees. and i use a simple vlookup to lookup the send address to the carrier list and append that to the phone number. In their employee list theres a column for phone number and carrier. then theres the notification column. The notification column has this formula in it:  
=ARRAYFORMULA(IF(Q2:Q=“”,“”,R2:R&VLOOKUP(Q2:Q,‘MISC TOOLS’!Y:Z,2,FALSE)))

The “Q” column is the carrier column. the “R” column is the phone number column and the vlookup just finds the end of the email/text. I have been since just using a script to send emails which in reality turn into notifications but webhooks just eliminates the scripts for button press notifications. I still need the scripts for live notifications.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 4, 2021, 5:08pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/75 "2021-02-04T17:08:31Z")

</div>

I’ve been using a lot of webhooks recently. Both using my own scripts to post to a webhook, as well as using the new Glide webhook action.

I’ve found that there is a time and place for each:

- If it’s something that’s triggered by a user interaction (tapping on a button, etc), I’ll use the Glide webhook
- If it’s something I need to run on a schedule, or when a certain condition is met (eg. time-based SLA breach), I’ll use a trigger to post to the webhook with a script

All of this is with Integromat webhooks, which I’m very rapidly falling in love with 😍 😂

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 5:09pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/76 "2021-02-04T17:09:54Z")

</div>

I have notifications that go out when the status of something changes. This change can occur on its own over time or when someone initiates the change. Its unpredictable. And it has to occur immediately not within a couple of minutes. That is why I still use scripts.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 4, 2021, 5:13pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/77 "2021-02-04T17:13:37Z")

</div>

Yup, that’s my second case.  
I have email notifications that go out with SLA breaches. A script runs on a (1 minute) time based trigger to check the duration of any active outages. When a breach occurs, a second function is called which posts to the Integromat webhook, and the email arrives within seconds.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 5:14pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/78 "2021-02-04T17:14:30Z")

</div>

Yeah 1 minute is still too long. I run onChange script events that are set to specific cells and/or columns to trigger the notification.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 4, 2021, 5:16pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/79 "2021-02-04T17:16:01Z")

</div>

That’s interesting - what causes the changes in those cells?

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [February 4, 2021, 5:18pm UTC](https://community.glideapps.com/t/webhook-action-tutorial/20905/80 "2021-02-04T17:18:19Z")

</div>

Times that fluctuate, Sold Items, Customer complaints, survey score change, etc.  
Just a lot of factors. All different triggers, but theres about 6 or 7 more that utilize the same idea. The one im building with webhook is just mass notification for the company.

[Previous page](https://community.glideapps.com/t/webhook-action-tutorial/20905.md?page=3)

[Next page](https://community.glideapps.com/t/webhook-action-tutorial/20905.md?page=5)
