Complete appointment system with Supabase and AI assistants for scheduling & management
Needs changesWhat this workflow does
This AI workflow has 40 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Ollama Chat Model and Supabase.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Appointment Actions (Edit Fields (Set)): sets 5 fields: set_appointment, reschedule, cancel…
- Switch: routes items into 5 branches
- Assign Interviewer & Schedule (AI Agent): runs an AI agent, with model: Ollama Chat Model; 3 tools (Create Interview Record, Load Interviewers Table, Delete Interviewer Record)
- AI Rescheduling Agent (AI Agent): runs an AI agent, with model: Ollama Chat Model; 5 tools (Load Enroller Record, Update Enroller Record, Load Interviewers Table, Delete New Interview Slot…)
- AI Cancellation Agent (AI Agent): runs an AI agent, with model: Ollama Chat Model; 3 tools (Delete Enroller Record, Fetch Enroller Profile, Insert Available Interviewer)
- AI Class List Agent (AI Agent): runs an AI agent, with model: Ollama Chat Model; 1 tool (Fetch Enroller Classes)
- AI Enroller Info Agent (AI Agent): runs an AI agent, with model: Ollama Chat Model; 1 tool (Fetch Enroller Record)
- Respond Appointment Booking (Respond to Webhook): sends the response back to the webhook caller
- Respond Appointment Reschedule (Respond to Webhook): sends the response back to the webhook caller
- Respond Appointment Cancellation (Respond to Webhook): sends the response back to the webhook caller
…plus 5 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 Assign Interviewer & Schedule (v1.9), AI Rescheduling Agent (v1.9), AI Cancellation Agent (v1.9)…: replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Assign Interviewer & Schedule (v1.9), AI Rescheduling Agent (v1.9), AI Cancellation Agent (v1.9), AI Class List Agent (v1.9), AI Enroller Info Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama - Switch
n8n-nodes-base.switch - Supabase Tool
n8n-nodes-base.supabaseTool - AI Agent
@n8n/n8n-nodes-langchain.agent - Respond to Webhook
n8n-nodes-base.respondToWebhook - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Edit Fields (Set)
n8n-nodes-base.set
From the author
Who’s it for This workflow is designed for organizations or services managing appointments, such as interview scheduling, class enrollments, or client meetings. It’s ideal for users who want to automate appointment creation, rescheduling, cancellation, and…