WhatsApp Lead Qualification with n8n, Google Sheets & Gemini

Qualify WhatsApp leads automatically—using n8n, Google Sheets, and Google Gemini

Turn every incoming WhatsApp message into a structured lead qualification and tailored property recommendation. This n8n workflow deduplicates and debounces messages with Redis, pulls your property inventory from Google Sheets, and uses Google Gemini to generate a qualifying or matching follow-up—optionally swapping any provided Cal.com link with an autofilled scheduling URL.

What this workflow does

• WhatsApp message trigger: Starts when a new WhatsApp message is received, extracting the sender, message ID, message type, and text.
• Text-only guardrail: If the incoming message is not text, the workflow replies in WhatsApp asking the user to send a text message instead.
• Deduplicate & debounce with Redis: Uses Redis to ignore duplicate message IDs and buffer multiple messages from the same phone number for a short time window—processing only when the latest message is stable.
• Prevent parallel runs: Acquires a Redis lock, combines buffered messages into a single prompt, then clears the buffer.
• Upsert contact in HighLevel: Looks up the contact in HighLevel and upserts the lead if it doesn’t already exist.
• AI qualification + recommendations: Reads the full property inventory from Google Sheets, aggregates it, and sends the user’s combined message plus inventory to a Google Gemini-powered AI agent (using Redis chat memory).
• JSON parsing & WhatsApp response: Parses the agent’s JSON output and sends either a qualifying follow-up or a property recommendation message in WhatsApp, replacing any Cal.com link with an autofilled scheduling URL when provided.

Use cases

• Real-estate teams qualifying WhatsApp inquiries and recommending matching listings.
• SaaS operators needing reliable WhatsApp lead intake with deduplication and stable message processing.
• Automation engineers deploying an n8n AI lead qualification flow tied to Google Sheets inventory.

Technical details

• Integrations: WhatsApp Cloud API (trigger/sending), Redis, Google Sheets, Google Gemini, HighLevel, Cal.com link handling.
• n8n nodes/logic: if, set, no op, wait, redis, WhatsApp.
• Core features: Redis deduplication, Redis locking, buffered prompt assembly, AI qualification with JSON parsing, WhatsApp response delivery.