I have different deadline dates in google sheets and would like an email reminder sent to me once the deadline date has passed. I would like this also done for another row, but for an email to be sent when the date is approaching.
I see this is possible with google calendar, however I can not figure out how to set up a trigger for specifically google sheets and for a trigger only to be done once the date in the cell has passed.
Thank you