I have a sample of participants who visit the lab for data collection. I have a Google Sheet that contains columns for participant emails, visit completed (yes or no), and the date of their visit. My goal is to trigger zaps to send emails to participants 5 months after their visits. My current model tries to use Schedule by Zapier to trigger a process to once daily examine a Google Sheet and only send a message to participants whose Visit Completion date is 5 months prior to today’s date. This attempt uses Schedule by Zapier (to set a once daily trigger) > Google Sheets (Lookup Spreadsheet Row) > Formatter (To format the date as + 5 months) > Filter by Zapier (To match the output date from formatter to today’s date {{zap_meta_human_now}}). One issue with this method is that it seems that the today’s date timestamp contains date + time and will not match the output date from formatter, which contains only date.
I’m not using Delay because this could produce errors if the date is entered retrospectively or if it is entered incorrectly and then later changed.
Does anyone know a remedy or a more efficient way to achieve this goal?
Thanks in advance.