4 days before and 1 day before a reccuring event in a Google calendar I want to send an email to 2 people and store they’re responses in a Google sheet. Sounds simple, but really struggling to find a way to do it.
Hey Gareth,
store the Calendar events in a google sheet with a column for the due date. Then add an app script that triggers a make scenario 4 days before the date and 1 day before the date to send the emails with a specific subject line. Then a separate scenario that watches for new emails with that specific subject line and store the responses in the specific sheet.
Thanks for responding so quickly. Is there any way to do it without storing the due date in sheets, just using Calendar to trigger it? It’s a reccuring event essentially forever and I’d have to put a huge amount of data in to the sheet and remember to add more when it ran out. I have a Google Calendar module to watch for the specific event name and I’m trying to work out how to set up a filter for 4 days before but I have no idea what format the Condition needs or what to put in the Text operators: Equal to box. Or is this not achievable? Thank you.