Qualify and score real estate leads via WhatsApp, Google Gemini, and PostgreSQL
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 24 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Postgres, WhatsApp Business Cloud, Google Gemini Chat Model and Postgres Chat Memory.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Validate & Normalise Data (Code): runs custom JavaScript code
- Handle Message Updates (If): checks a condition and branches into true / false
- Create or Update the Lead here (Postgres): run a query
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; memory: Postgres Chat Memory; output parser: Structured Output Parser
- Send template (WhatsApp Business Cloud): uses WhatsApp Business Cloud
- If: checks a condition and branches into true / false
- Send the typing status to the user (HTTP Request): calls an HTTP API (POST)
- Send message (WhatsApp Business Cloud): send
- Check if the lead has been qualified (Postgres): run a query
- Route Lead (If): checks a condition and branches into true / false
…plus 7 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 (12)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Postgres
n8n-nodes-base.postgres - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview Capture real estate leads, qualify them through an AI-powered WhatsApp conversation, score buying intent, and notify your sales team when the lead is ready for follow-up. How it works 1. Receive Lead — Accept lead data through a webhook from a…