24 hour reminder SMS and Email

How To
1

Steps taken so far

Hi everyone,

I’m trying to set up a reminder that triggers 24 hours before an appointment. I have a Google Sheet that collects my appointments, and everything works fine for the “Thanks for Booking” flow. However, I’m struggling to set up the reminder for the day before.

I’ve tried using Sleep and a few other options, but after two days of troubleshooting, I still can’t figure it out. Can someone point me in the right direction?

Thanks in advance!
Christopher

Screenshots: scenario setup, module configuration, errors

Screenshot 2025-02-14 at 11.23.22 AM.png
Screenshot 2025-02-14 at 11.23.22 AM.png2582×1424 143 KB

2

@C_H_R_I_S_T_O_P_H_E

I’m trying to set up a reminder that triggers 24 hours before an appointment.

Hi, I think you need to create a separate Scenario from the “Thanks for Booking” flow.
My ideas are as follows.

  1. use Search Rows in Spreadsheet for the first module.
  2. use the module placed in #1 to search for dates and times within 24 hours of the appointment date and time.
  3. set up a Filter so that the flow is executed when a record matching the condition in #2 is retrieved.
  4. set up a Trigger so that Scenario is executed at a fixed interval.

I would be happy to help solve this problem!

3

Welcome to the Make community!

You can have a scenario watch new items and schedule a cron job callback using apps like 0CodeKit that allows you to schedule a “callback” to a URL defined in a “Custom Webhook” trigger in another scenario at the exact time you want

389×181 8.51 KB

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, briefly mentioned here.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like