I have a Zap that creates records for individual meetings from a booking platform. These are populated with a date/time when a reminder should be sent. This date/time can be changed, or the sending of the reminder can be cancelled, if the meeting is rescheduled or cancelled.
I would like a separate Zap that triggers when the current date/time is equal to the date/time in my send time field.
Solutions I have considered
- Meetings can be scheduled more than 30 days in advance, so the delay until step doesn’t work well.
- Scheduled runs only run at minimum ever hour, and this is a 1 hour before reminder text, meaning every hour doesn’t work well.
- Triggering off a code step that runs ~every minute that outputs the current date/time, and checks if any records on my table have send times in the past. This works well, but ran ~5000 times over 3 days, which is very run intensive and expensive.
Is there a better solution out there?