n8n WhatsApp Support Automation with Gemini, Sheets & Calendar

Automate WhatsApp support with Gemini, Redis memory, Google Sheets & Calendar—built for n8n

This 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.

What this workflow does

• Receives WhatsApp messages through a messages.upsert webhook from Evolution API.
• Normalizes the payload to extract chat ID, phone number, sender name, message text, and a bot-sent flag.
• Prevents automation loops by ignoring messages sent by the bot and any events without message text.
• Uses a Google Gemini orchestrator (multi-agent routing) with Redis-backed conversation memory to categorize the request and decide whether to answer directly or call specialist tools (Sales, Support, or Finance). It can also trigger a Google Calendar scheduling step.
• Parses the orchestrator output into structured data including replyText, category, lead details, and a shouldLog flag.
• Logs qualified leads to Google Sheets by appending or updating a row matched on phone number (only when shouldLog is true).
• Sends the final reply via Evolution API using the sendText endpoint back to the WhatsApp contact.

Use cases

• Provide instant WhatsApp customer support with context-aware Gemini responses stored in Redis.
• Automatically capture and qualify leads and keep your Google Sheets CRM list up to date.
• Offer a booking flow where Gemini schedules follow-ups in Google Calendar after support or sales triage.

Technical details (n8n)

• Webhook-based intake for Evolution API (messages.upsert) and HTTP header auth using apikey.
• Core control logic with if, set, and no op nodes.
• Conversation handling using a Gemini-based orchestrator with Redis conversation memory.
• Outbound actions via HTTP Request to Evolution API sendText, plus Google Sheets logging and optional Google Calendar scheduling.