How to get total sum of a column filtered by month in Monday board and send alert notification if it meets a condition

I am trying to create an automation from a board the condition is:
There is a number column which counts the task hours every month.
I want to receive an alert notification when the task hours column total is greater then 50 for the current month.

I’m also looking to set up a notification based on a column total. Were you able to figure out a way to do this?

Hey all,

We developed an app that does exactly this. You can get notifications on sum / count of column and items.

You can find it here - https://monday.com/marketplace/10000291
If you have any questions, I’m available - daniel@fantasymedia.io