Hi guys,
I have a spreadsheet where certain conditions have to be validated everyday. I want to get an automatic email if value of a counter is = 1 and take no action if value = 0. Also it needs to be checked everyday without actually opening spreadsheet.
Any help from anyone ?

Thanks in advance.