Quick overview
Quick overview This workflow uses the WhatsApp Cloud API, Google Gemini, Google Calendar, PostgreSQL, Redis, and Google Sheets to run an AI appointment assistant that answers scheduling questions, checks availability, books/reschedules/cancels appointments, and escalates conversations to a human when required. How it works Triggers when a new WhatsApp message update is received. Accepts only text messages, validates the WhatsApp profile name, and generates a consistent conversation identifier from the sender’s WhatsApp ID. Checks Redis to see whether the conversation is currently escalated to a human and stops automated handling if an escalation record exists. Uses Google Gemini with PostgreSQL chat memory to interpret the request and decide whether to answer a question, check availability, book, reschedule, cancel, or escalate. When scheduling actions are needed, the agent reads clinic/FAQ data from Google Sheets and uses Google Calendar to retrieve availability, create events, update events, or delete events. Sends the agent’s final reply back to the patient via WhatsApp. Setup Connect WhatsApp Cloud API credentials for both the WhatsApp Trigger and WhatsApp send nodes, and set your Phone Number ID for sending messages. Add a Google Gemini (PaLM) API credential and select the models used by the primary and fallback chat models. Connect a Google Calendar account and choose the target calendar(s) in the availability and event create/update/delete actions. Set up PostgreSQL credentials for chat memory storage and ensure the database is reachable from n8n. Set up Redis credentials for escalation locking, and update the “Create A Link” step with your instance base URL used to generate the human-resolution link. Connect Google Sheets OAuth credentials and update the spreadsheet ID/sheet tab used as the workflow’s structured knowledge source. Requirements WhatsApp Business Account WhatsApp Cloud API Google Gemini API Google Calendar PostgreSQL Redis Customization Business name Working hours Available services AI system prompt Google Calendar Human escalation rules Additional info Designed as a production-ready template demonstrating AI-powered conversational automation, persistent memory, and real-world scheduling workflows. This template can be adapted for healthcare clinics, dental practices, salons, consulting businesses, and any appointment-based service. An n8n automation workflow template by Ciphernutz IT Services.
Ciphernutz IT Services
web
free
Others in the same category, ranked by how often they are opened.
