Hi I managed to create a Zap that create a draft email when rows are updated on a oogleSheet file. It works pretty fine. I wuld like to tune it a little bit.
Actually I want the email to be created only when value of cell D2 falls below zero.
In the google Sheet i put a formula that says … IF( D2 is greater than 0, False, “D2”) In this way zap doesen’t gets triggered at every change of data but if the value of D2 falls below 0 ZAP gerts triggered, but it happens also when D2 raise again from zero. (i.e friend top up their credit of a car we are using toghether)
Can you suggest a way so that zap is triggered only when value falls below zero?
I cannot think of anything.