Hello, i am just getting started, i think i need a very simple Zap, i need to send an email to our company mail, the trigger is:
If a number in Column F drops below 30 it sends an email to company mail
Data is stored in google sheet, i will provide pictures down below
The idea is, my people in the company have their documents registered for 1 year, so every year we have to renew them, so, when we renew, we put in the dates, and column next to it is countdowning days until it needs to be renewd again, so, i need a zap to send me an email once that number in that specific row, if any on the number there in a row show under “30” that it triggers and sends an email saying “hey there is one documents coiming to an end in 30 days” or idealy, if it can also read names, and tell me specificly, this guys with name from cokumn A and B his doucments running out uner 30 days”
i tried to do something but it triggered allot of zaps, im getting lost and this system is not simple as i thought..
pls help
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/336b14db-d3d3-4f38-b67d-5174785af3b6.png)
also sorry for scrambles i wanted to protect thair names and privacy
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/ef01c2f0-5d36-478d-8b57-b943a74c69f6.png)