Dental clinic appointment & admin system with Supabase, phone integration & AI
Needs changesWhat this workflow does
This AI workflow has 38 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Supabase and OpenAI Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Switch: routes items into 7 branches
- Find Patient (Booking) (Supabase): get
- Find Patient (Reschedule) (Supabase): get
- Find Patient (Cancel) (Supabase): get
- Find Patient (List Appointments) (Supabase): get
- Find Insurance Record (Supabase): get
- Generate Availability With AI (AI Agent): runs an AI agent, with model: LLM Engine; 1 tool (Fetch Doctor’s Appointments)
- Fetch All Doctors (Supabase): get many
- Check Time Availability (If): checks a condition and branches into true / false
- Fetch Patient's Current Appointment (Supabase): get many
…plus 25 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Generate Availability With AI (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Generate Availability With AI (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Webhook
n8n-nodes-base.webhook - Switch
n8n-nodes-base.switch - Respond to Webhook
n8n-nodes-base.respondToWebhook - Supabase
n8n-nodes-base.supabase - If
n8n-nodes-base.if - Summarize
n8n-nodes-base.summarize - Aggregate
n8n-nodes-base.aggregate - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Supabase Tool
n8n-nodes-base.supabaseTool
From the author
Dental Clinic Automation: Scheduling, Availability & Patient Lookup This workflow automates dental appointment management through a phone-based assistant. It listens for requests like booking, rescheduling, canceling, checking insurance, looking up…