Daily Twilio SMS reminders for tomorrow's Acuity appointments

Every morning at 10am on a cron trigger, send a Twilio SMS reminder to every Acuity Scheduling client who has an appointment tomorrow.

Start by calling Acuity Scheduling List Appointments with minDate and maxDate set to tomorrow's local day so the response only contains appointments that fall on that date. Iterate every appointment in the response.

For each appointment, decide whether to skip it before doing any work. Skip the appointment if it is canceled, if the client record has no phone number, if the appointment's type is flagged as no-reminder (treat this as a configured list of appointment type ids or a matching flag on the type), or if the appointment already carries the label reminder_sent. Any of those conditions means move on to the next appointment.

For every appointment that passes the checks, build the SMS body. Address the client by their first name from the Acuity appointment. Render the appointment start time in the client's timezone using the timezone field on the appointment, not the account's timezone. Include the appointment type name, the location or video link (from the appointment fields), and a short one-line reschedule instruction the client can act on.

Send the message with Twilio Send a Message to the client's phone number using your Twilio sending number. Phone numbers must be in E.164 format.

After a successful send, call Acuity Scheduling Update Appointment to add the label reminder_sent to that appointment. This is what makes the workflow idempotent: a second run later in the day will see the label and skip the appointment instead of double-texting.

Log a short line per appointment so the run history shows what was sent, what was skipped, and why (canceled, no phone, no-reminder type, or already labeled).