# Way to trigger alerts (automatic email) when data reaches a certain treshhold?

**URL:** https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826
**Category:** Ask for Help
**Created:** [February 12, 2023, 10:44am UTC](https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826 "2023-02-12T10:44:43Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [February 12, 2023, 10:44am UTC](https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826/1 "2023-02-12T10:44:44Z")

</div>

I have a connected car integration that is pushing the location of my cars to my app every hour.  
I want to set an email alert that when:

- my cars fuel tank/tire pressure is below a certain treshhold
- my cars location is farther than x away from a set location
- …  
In case this treshhold is reached the app should send an email.

Is this something that can be done in Glide natively?  
I can imagine a workaround in Airtable but what is the leanest way to set this up?

Many thanks for your advice!

Best regards,

Tim

---

<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 12, 2023, 10:56am UTC](https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826/2 "2023-02-12T10:56:16Z")

</div>

No way to do this natively in Glide at the moment, because all actions require a user to “do something” to trigger them.

But I’d say watch this space, as I can imagine this sort of functionality might be just around the corner.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [February 12, 2023, 12:06pm UTC](https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826/3 "2023-02-12T12:06:22Z")

</div>

Hola Tim,

On last Friday creating a new demo I had the same thought 🤕

The current problem in Glide is that the APP/Page must be loaded and running to send data or fire actions. We have to wait a little longer for Glide to get a native solution and let Glide servers (not APPs) send data to external users/apps.

Saludos!

---

<div class="post-metadata">

### Author: ![Sumer\_Bhadra9](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sumer_bhadra9/32/36080_2.png) [@Sumer\_Bhadra9](https://community.glideapps.com/u/Sumer_Bhadra9)
#### Post date: [February 13, 2023, 8:59am UTC](https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826/4 "2023-02-13T08:59:40Z")

</div>

Are you using Google Sheets as the back end or Glide Tables?

---

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [February 13, 2023, 10:19am UTC](https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826/5 "2023-02-13T10:19:53Z")

</div>

Thanks for your feedback @gvalero & @Darren_Murphy

I guess I’ll have to wait for the native functionality, in the mean time I think I’ll recreate this with Airtable as a back-end.

@Sumer_Bhadra9 I’m using Glide Tables atm.

---

<div class="post-metadata">

### Author: ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)
#### Post date: [February 13, 2023, 4:12pm UTC](https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826/6 "2023-02-13T16:12:35Z")

</div>

I think you can do it with google sheets or airtable, depend of what function u need, i know with zapier you can do a lot of things, i’m looking for a solution too, no time to do it right now, but i gonna build something similar in the future, it’s about expiration date, like send an email to customer 3 month before the contract gonna expire (no trigger action).

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 13, 2023, 11:49pm UTC](https://community.glideapps.com/t/way-to-trigger-alerts-automatic-email-when-data-reaches-a-certain-treshhold/57826/7 "2023-02-13T23:49:27Z")

</div>

The equivalent solution in Make would be to trigger a scenario to run every day, and have a column in your Google Sheets to calculate the “reminder date” (3 months from the actual expiration date). If “today” is the same as “reminder date” then you trigger the email module.

You should also make sure the dates are formatted in the same way, especially the “today” value, with the formatDate function.
