Use case: Remind managers new hire is starting next week
Hi, I’d like setup a zap to send a reminder email 1 week before a date in a google spreadsheet.
So, i’d need zapier to look at all of the rows in column D in a spreadsheet and find where that date = 1 week before today. For those rows, send an email to manager’s email in row E to remind them of something.
Can this be done?