I’d like to create a Zap that looked through, say, Google Sheets at a spreadsheet of my forthcoming events (or some kind of calendar app instead) and then sent a mailjet email to my contacts at 5 days, 3 days, 1 day and 2 hours before that event.
How might I do that. The action of sending the email seems easy enough. But how do I get it to trigger 5,3 and 1 day before?
Thanks
Al