# How to trigger make.com if my google sheet column changed? **URL:** \ **Category:** Ask for Help\ **Created:** [September 7, 2022, 2:36pm UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803 "2022-09-07T14:36:06Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [September 7, 2022, 2:36pm UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/1 "2022-09-07T14:36:06Z")
My database source will be google sheets and we have a column called “Due Date” ![Screen Shot 2022-09-07 at 9.34.45 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/1394a31e39fa8c2e090490f6316da71221b57639.png) I want everytime due date is “Overdue”, integromat need to send email notification to that each email with overdue Is this possible with google sheets ? ---
**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:** [September 8, 2022, 1:27am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/2 "2022-09-08T01:27:39Z")
I think the most important thing here is how does that column value gets changed? Are you using a formula, or are you changing it from the Glide interface? ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [September 8, 2022, 2:01am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/3 "2022-09-08T02:01:48Z")
the column value will change through human interaction, i have an admin that will manually update change the value. is this still possible from [make.com](http://make.com) ? or i need to use different method to remind those emails ? ---
**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:** [September 8, 2022, 2:58am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/4 "2022-09-08T02:58:52Z")
> [@liam\_putra](#): > > the column value will change through human interaction, i have an admin that will manually update change the value. Is the Admin changing it directly in the Google Sheet, or are they making the change in Glide? ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [September 8, 2022, 3:23am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/5 "2022-09-08T03:23:51Z")
admin will change everything on glide, google sheets is just another backup database ---
**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:** [September 8, 2022, 3:26am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/6 "2022-09-08T03:26:53Z")
Okay, so what you can do is trigger a webhook to Make when the change is made, and you can send the email from there. You could probably also use the Send Email action and send it directly from Glide. ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [September 13, 2022, 9:41am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/7 "2022-09-13T09:41:00Z")
> [@Darren\_Murphy](#): > > ou could probably also use the Send Email action and send it directly from Glide. okay thank you !! what if instead i use a formula to calculate the due date column ? can [make.com](http://make.com) still watch those column on background ? so here’s the case 1. I use ONLY glide tables 2. i create a new formula that automatically calculates whether a task is overdue, if it’s overdue send email notification. Note: this flow will happen when user is not opening the app. is this still possible with [make.com](http://make.com) webhook ? ---
**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:** [September 13, 2022, 9:47am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/8 "2022-09-13T09:47:38Z")
Not easily, no. The challenge is that you can only send webhooks with actions, not based on time. And actions need user interaction. What you could do is send a webhook to Make when the item is created, including the calculated due date, and then store the details in a Data Store. You could then have a Make task that runs periodically to check for any overdue items, and send an email. If a payment was made against any of them, you would also need to send a webhook at that point, so the data store could be updated. ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [September 13, 2022, 9:50am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/9 "2022-09-13T09:50:35Z")
> [@Darren\_Murphy](#): > > was made against any of them, you would also need to send a webhook at that point, so the data store could be updated. Thank you, just what i needed. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 14, 2022, 9:51am UTC](https://community.glideapps.com/t/how-to-trigger-make-com-if-my-google-sheet-column-changed/48803/10 "2022-09-14T09:51:25Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.