Qualify real estate WhatsApp leads with Gemini, Airtable and Google Calendar
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 23 nodes and runs on WhatsApp events (messages). Along the way it connects WhatsApp Business Cloud, Google Gemini Chat Model, Google Calendar and Google Sheets and 2 more.
How it runs
Trigger: On WhatsApp events (messages).
- Is Valid Message? (If): checks a condition and branches into true / false
- Route by Message Type (Switch): routes items into 2 branches
- Normalize Input Text (Edit Fields (Set)): sets 1 field: input_text
- Get Audio File (WhatsApp Business Cloud): media url get
- Send Unsupported Notice (WhatsApp Business Cloud): send
- Real Estate Assistant (AI Agent): runs an AI agent, with model: Gemini Chat Model; 3 tools (book_appointment, search_properties, check_availability); memory: Per-User Memory; output parser: Lead Output Parser
- Download Audio Binary (HTTP Request): calls an HTTP API
- Send WhatsApp Reply (WhatsApp Business Cloud): send
- Log Lead to Sheet (Google Sheets): append
- Hot Lead or Escalation? (If): checks a condition and branches into true / false
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (15)
- WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Calendar Tool
n8n-nodes-base.googleCalendarTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Airtable Tool
n8n-nodes-base.airtableTool - Code
n8n-nodes-base.code
From the author
Quick overview An AI-powered WhatsApp assistant for real estate teams. Answers property questions from a live Airtable database, qualifies leads as hot, warm, or cold, checks calendar availability before booking viewings, and escalates to a human agent when a…