{"product_id":"whatsapp-ai-appointment-assistant-with-gemini-calendar-n8n","title":"WhatsApp AI Appointment Assistant with Gemini \u0026 Calendar (n8n)","description":"\u003ch3\u003eTurn WhatsApp messages into booked appointments—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow powers a \u003cstrong\u003eWhatsApp AI Appointment Assistant\u003c\/strong\u003e that answers scheduling questions, checks availability in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, and can \u003cstrong\u003ebook, reschedule, or cancel\u003c\/strong\u003e appointments—using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for AI understanding and \u003cstrong\u003eWhatsApp Cloud API\u003c\/strong\u003e for patient communication.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTriggers on every new \u003cstrong\u003eWhatsApp message update\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAccepts only \u003cstrong\u003etext messages\u003c\/strong\u003e, validates the WhatsApp profile name, and generates a stable conversation ID from the sender’s \u003cstrong\u003eWhatsApp ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eChecks \u003cstrong\u003eRedis\u003c\/strong\u003e to determine whether the conversation is currently \u003cstrong\u003eescalated to a human\u003c\/strong\u003e; if so, automated handling stops.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e with \u003cstrong\u003ePostgreSQL chat memory\u003c\/strong\u003e to interpret the request and choose the right action: answer questions, check availability, book, reschedule, cancel, or escalate.\u003c\/li\u003e\n  \u003cli\u003eFor scheduling actions, reads clinic\/FAQ data from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then uses \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e to retrieve availability, create events, update events, or delete events.\u003c\/li\u003e\n  \u003cli\u003eSends the final confirmation or next-step response back to the patient via \u003cstrong\u003eWhatsApp\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA patient texts “Do you have openings tomorrow morning?” and receives available times based on Google Calendar.\u003c\/li\u003e\n  \u003cli\u003eA patient requests a change (“Reschedule my appointment to next Tuesday”), and the workflow updates the calendar event.\u003c\/li\u003e\n  \u003cli\u003eA patient asks to cancel, and the workflow deletes the corresponding Google Calendar event.\u003c\/li\u003e\n  \u003cli\u003eComplex cases are automatically escalated, with Redis preventing further AI automation during human handling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp Cloud API\u003c\/strong\u003e (Trigger + send back responses; configure Phone Number ID)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (primary and fallback chat models)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e (availability lookup, event create\/update\/delete)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (clinic\/FAQ data)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePostgreSQL\u003c\/strong\u003e (chat memory)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRedis\u003c\/strong\u003e (escalation state)\u003c\/li\u003e\n  \u003cli\u003en8n logic nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, and \u003cstrong\u003ecrypto\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBuilt for n8n users, automation engineers, and SaaS operators who want a production-ready \u003cstrong\u003eWhatsApp AI appointment assistant with Gemini \u0026amp; Calendar\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45742773862579,"sku":"N8N-17630","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vdoMvuVVhduur7lbZf0bp_Gx1XKcY2.png?v=1785402444","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-ai-appointment-assistant-with-gemini-calendar-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}