Send Automated Patient Appointment Reminders via Email & SMS with Multi-Database Support
Ready for 3.0What this workflow does
This workflow has 18 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Google Sheets, Airtable, Twilio and Postgres.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Extract Appointment Data (Edit Fields (Set)): sets or maps fields
- Format & Validate Data (Code): runs custom JavaScript code
- Store in Google Sheets (Google Sheets): uses Google Sheets
- Store in Airtable (Airtable): uses Airtable
- Store in PostgreSQL (Postgres): uses Postgres
- Wait: pauses before continuing
- Send 3-Day Email Reminder (Send Email): sends an email over SMTP
- Send 3-Day SMS Reminder (Twilio): uses Twilio
- Update Google Sheets: 3-Day Sent (Google Sheets): uses Google Sheets
- Update Airtable: 3-Day Sent (Airtable): uses Airtable
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Airtable
n8n-nodes-base.airtable - Wait
n8n-nodes-base.wait - Send Email
n8n-nodes-base.emailSend - Twilio
n8n-nodes-base.twilio - Postgres
n8n-nodes-base.postgres
From the author
🏥 PATIENT APPOINTMENT REMINDER SYSTEM MULTI-DATABASE SUPPORT PURPOSE: Automatically send professional appointment reminders via email and SMS to reduce no-shows and improve patient experience. FEATURES: ✅ Dual reminders (3-day + 1-day before) ✅ Email + SMS…