Skip to content
Hud Jamalul
Back to sample work

Appointment Reminders with AI Reply Tracking

ResultSent reminders automatically and tracked confirmed, reschedule and missing-email cases in one sheet

Reminds clients 24 hours before their appointment and uses AI to read their replies.

The task: Clinics, salons and service businesses lose time and money to no-shows and missed reschedule requests.

What I built:

  • Reads appointments from Google Calendar and emails each client a reminder 24 hours before
  • Each appointment is reminded only once
  • Business name, phone, message wording and Send or Draft mode are edited in a Settings sheet, no coding needed
  • AI reads each client's reply and marks it Confirmed, Wants to reschedule, Cancelled or Has a question
  • Reschedules and questions are starred in Gmail so they're handled first
  • Appointments without a client email are flagged

The result: In the demo, 4 reminders went out automatically, replies were sorted into Confirmed and Wants to reschedule, and the appointment with no email was flagged.

Built with Google Apps Script. If a client prefers n8n, Zapier or Make, I can build the same workflow on their paid plan.

The work

  1. Appointment Reminders with AI Reply Tracking, file 1 Full size

    1 of 2

  2. 2 of 2

    Demo: I create test appointments in Google Calendar, send reminders, and reply as the clients. AI then reads the replies and updates each status to Confirmed or Wants to reschedule, and flags the appointment with no email.