{"product_id":"n8n-whatsapp-support-automation-with-gemini-sheets-calendar","title":"n8n WhatsApp Support Automation with Gemini, Sheets \u0026 Calendar","description":"\u003ch3\u003eAutomate WhatsApp support with Gemini, Redis memory, Google Sheets \u0026amp; Calendar—built for n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically receives incoming WhatsApp messages (via Evolution API), routes the request using Google Gemini with Redis-backed conversation memory, generates a specialist reply, optionally schedules meetings in Google Calendar, logs qualified leads into Google Sheets, and sends the response back to the customer.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives WhatsApp messages\u003c\/strong\u003e through a \u003cem\u003emessages.upsert\u003c\/em\u003e webhook from Evolution API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload\u003c\/strong\u003e to extract chat ID, phone number, sender name, message text, and a bot-sent flag.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents automation loops\u003c\/strong\u003e by ignoring messages sent by the bot and any events without message text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses a Google Gemini orchestrator\u003c\/strong\u003e (multi-agent routing) with \u003cstrong\u003eRedis-backed conversation memory\u003c\/strong\u003e to categorize the request and decide whether to answer directly or call specialist tools (Sales, Support, or Finance). It can also trigger a \u003cstrong\u003eGoogle Calendar scheduling\u003c\/strong\u003e step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses the orchestrator output\u003c\/strong\u003e into structured data including \u003ccode\u003ereplyText\u003c\/code\u003e, category, lead details, and a \u003ccode\u003eshouldLog\u003c\/code\u003e flag.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs qualified leads to Google Sheets\u003c\/strong\u003e by appending or updating a row matched on phone number (only when \u003ccode\u003eshouldLog\u003c\/code\u003e is true).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the final reply via Evolution API\u003c\/strong\u003e using the sendText endpoint back to the WhatsApp contact.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProvide instant \u003cstrong\u003eWhatsApp customer support\u003c\/strong\u003e with context-aware Gemini responses stored in Redis.\u003c\/li\u003e\n  \u003cli\u003eAutomatically \u003cstrong\u003ecapture and qualify leads\u003c\/strong\u003e and keep your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e CRM list up to date.\u003c\/li\u003e\n  \u003cli\u003eOffer a booking flow where Gemini schedules follow-ups in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e after support or sales triage.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWebhook-based intake for \u003cstrong\u003eEvolution API\u003c\/strong\u003e (\u003cem\u003emessages.upsert\u003c\/em\u003e) and HTTP header auth using \u003ccode\u003eapikey\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eCore control logic with \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003eno op\u003c\/strong\u003e nodes.\u003c\/li\u003e\n  \u003cli\u003eConversation handling using a \u003cstrong\u003eGemini-based orchestrator\u003c\/strong\u003e with \u003cstrong\u003eRedis conversation memory\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOutbound actions via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e to Evolution API sendText, plus \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e logging and optional \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e scheduling.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978911408307,"sku":"N8N-19362","price":7.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WDgK8HqTYgf59Kio_1q2K_gbFQKU1q.png?v=1788858552","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-support-automation-with-gemini-sheets-calendar","provider":"N8N Commerce","version":"1.0","type":"link"}