Triggering sequence at customised times

How To
,
1

Hey guys, I’m trying to accomplish the following usecase.

All booked appointments get added to a spreadsheet or Airtable. It specifies the name and time of the appointment (this is already set up properly).
I want to trigger a sequence at the time of the appointment that sends a message in Slack.
For example John booked an appointment at 10:00AM and I want the sequence to be triggered at this particular time.

I was thinking to start the sequence with “Watch rows” so it gets triggered each time a row gets added but I don’t know how to make the sequence wait until the time of the appointment.

Any help would be appreciated.

2

You can set up the rows to be watched on a daily or hourly basis and use a filter to pass the ones that are due. But this can become expensive.

Within airtable is there a webhook that can be sent out when the due date approaches? I personally am not too familar with airtable but I believe you are able to send out webhooks. If thats the case you can use the webhook module to start your scenario.

Hope this helps!