Handle healthcare appointments on WhatsApp with Gemini and Google Calendar

Description

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.