Doctor appointment management system with Gemini AI, WhatsApp, Stripe & Google Sheets

by GreatStack · 11,233 views · created 2025-09-22 · Support Chatbot, AI Chatbot

What this workflow does

This AI workflow has 35 nodes and runs on a schedule (every day at 08:00) (plus 4 other triggers). Along the way it connects Google Gemini Chat Model, WhatsApp Business Cloud, Date & Time and Google Sheets and 1 more. It also calls api.stripe.com over HTTP.

How it runs

Trigger: On a schedule (every day at 08:00) (plus 4 other triggers).

1. Appointment Reminder AI Agent (AI Agent): runs an AI agent, with model: Google Gemini Chat Model; 3 tools (Date & Time, Get Appointment sheet, Send message in WhatsApp Business Cloud)
2. Check status "Cancelled" (If): checks a condition and branches into true / false
3. Retrieve Payment Session (HTTP Request): calls api.stripe.com
4. Check Appointment Payment Mode (If): checks a condition and branches into true / false
5. AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 9 tools (Config, Add Patient, Date & Time, Add Appointment…); memory: Simple Memory
6. Check Is Amount Paid (If): checks a condition and branches into true / false
7. Mark Payment Paid (Google Sheets): update
8. Send Payment Confirmation (WhatsApp Business Cloud): send
9. Generate Stripe Payment Link (HTTP Request): calls api.stripe.com (POST)
10. Send message (WhatsApp Business Cloud): send

…plus 5 more steps. See the full node list below.

Services it uses

Google Gemini Chat ModelWhatsApp Business CloudDate & TimeGoogle SheetsStripe

HTTP calls to: api.stripe.com

Before you upgrade to n8n 3.0

Nodes used (14)

• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• WhatsApp Triggern8n-nodes-base.whatsAppTrigger
• Simple Memory@n8n/n8n-nodes-langchain.memoryBufferWindow
• Date Time Tooln8n-nodes-base.dateTimeTool
• WhatsApp Business Cloudn8n-nodes-base.whatsApp
• Google Sheets Tooln8n-nodes-base.googleSheetsTool
• AI Agent@n8n/n8n-nodes-langchain.agent
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Whats App Tooln8n-nodes-base.whatsAppTool
• Google Sheets Triggern8n-nodes-base.googleSheetsTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if
• Stripe Triggern8n-nodes-base.stripeTrigger

From the author

WhatsApp AI Assistant for Clinic Appointment Booking Automate your entire appointment lifecycle with an intelligent AI assistant that lives on WhatsApp. This workflow empowers any clinic or independent practitioner to manage bookings, take payments, and send…

View the original on n8n.io → Check your own copy