Schedule scenario by dynamic time

Hello,
I need to schedule scenario activation according to dynamic time
I have an appointment time stored in a table (google sheet) and I need to send a message an hour before the appointment time.
Is there a possibility to activate scenario at a given time that will be sent to him dynamically?
Thank You

Bracha

Welcome to the Make community!

Have a scenario watch new items and schedule a Cron Job webhook callback using apps like 0CodeKit that allows you to schedule a “callback” to a “Custom Webhook” trigger in another scenario.

Screenshot_2023-12-21_095501

You can use an external module to schedule a webhook callback to your secondary scenario at the exact time for each item,

Screenshot_2023-10-01_175322

You don’t have to use a data store, this is just an example. You can use Google Sheets, Google Calendar, etc.

Alternatively, if you are already using Airtable, you can use an Airtable formula and built-in automation.

2 Likes