Reduce appointment no-shows with Sent and Google Calendar
UnknownWhat this workflow does
This workflow has 28 nodes and runs on a schedule (every 15 minutes) (plus 1 other trigger). Along the way it connects Google Calendar and Sent (community).
How it runs
Trigger: On a schedule (every 15 minutes) (plus 1 other trigger).
- Workflow Settings (Edit Fields (Set)): sets 11 fields: calendarId, businessName, businessTimezone…
- Validate Workflow Settings (Code): runs custom JavaScript code
- Route Trigger Type (If): checks a condition and branches into true / false
- Parse Customer Reply (Code): runs custom JavaScript code
- Get Upcoming Appointments (Google Calendar): get many
- Check for Opt-Out (If): checks a condition and branches into true / false
- Prepare Reminder (Code): runs custom JavaScript code
- Find Sender Appointments (Google Calendar): get many
- Check Reminder Due (If): checks a condition and branches into true / false
- Match Reply to Appointment (Code): runs custom JavaScript code
…plus 13 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 2 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @sentdm/n8n-nodes-sent is verified or supports 3.0 (used in Listen for Sent Customer Replies).
- Check that @sentdm/n8n-nodes-sent is verified or supports 3.0 (used in Validate Recipient Phone, Send Appointment Reminder, Explain Appointment Match Issue).
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Sent Trigger
@sentdm/n8n-nodes-sent.sentTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Google Calendar
n8n-nodes-base.googleCalendar - Code
n8n-nodes-base.code - Sent
@sentdm/n8n-nodes-sent.sent - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow checks upcoming Google Calendar appointments every 15 minutes, sends timed reminder messages via Sent after validating phone numbers, and processes inbound Sent replies to confirm or reschedule appointments by updating the event…