Manage medical appointment bookings and reminders with Google Sheets, Calendar, Gmail, and Supabase
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, Google Calendar, Gmail and Supabase.
How it runs
Trigger: On Google Sheets events (row added).
- Clean Patient Data (Edit Fields (Set)): sets 8 fields: Timestamp, Patient Name, Mobile Number…
- Generate Appointment Datetime (Edit Fields (Set)): sets or maps fields
- Check Doctor Availability (Google Calendar): get many
- Appointment Slot Available? (If): checks a condition and branches into true / false
- Create Google Calendar Appointment (Google Calendar): uses Google Calendar
- Prepare Database Data (Edit Fields (Set)): sets 9 fields: Timestamp, Patient Name, Mobile Number…
- Send Slot Unavailable Email (Gmail): uses Gmail
- Save Appointment in Supabase (Supabase): uses Supabase
- Send Appointment Confirmation Email (Gmail): uses Gmail
- Wait: pauses before continuing
…plus 2 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 (7)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Calendar
n8n-nodes-base.googleCalendar - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Supabase
n8n-nodes-base.supabase - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow monitors a Google Sheets form response sheet for new patient appointment requests, checks availability in Google Calendar, creates confirmed appointments, stores booking details in Supabase, and sends confirmation and reminder…