Qualify, log, and route inbound WhatsApp leads with OpenAI and Google Sheets

by achiya ✓ · 124 views · created 2026-07-08 · Lead Generation, AI Summarization

What this workflow does

This AI workflow has 13 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model and Google Sheets.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Extract Message (Edit Fields (Set)): sets 3 fields: message, phone, name
2. Classify Lead (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Segment Schema
3. Flatten Result (Edit Fields (Set)): sets 9 fields: Phone, Name, Message…
4. Log Lead to Google Sheet (Google Sheets): append or update (sheet)
5. Is Buyer? (If): checks a condition and branches into true / false
6. Reply to Buyer (WAHA) (HTTP Request): calls an HTTP API (POST)
7. Is Spam? (If): checks a condition and branches into true / false
8. Notify Owner of Hot Lead (WAHA) (HTTP Request): calls an HTTP API (POST)
9. Respond (Respond to Webhook): sends the response back to the webhook caller
10. Polite Reply (Non-Buyer) (HTTP Request): calls an HTTP API (POST)

Services it uses

OpenAI Chat ModelGoogle Sheets

Before you upgrade to n8n 3.0

Nodes used (9)

• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• AI Agent@n8n/n8n-nodes-langchain.agent
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Google Sheetsn8n-nodes-base.googleSheets
• Respond to Webhookn8n-nodes-base.respondToWebhook
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow receives inbound WhatsApp lead messages via a webhook, uses OpenAI to classify each sender's intent (buyer, job seeker, or spam), logs the enriched lead to Google Sheets — and then acts on the classification: buyers get an instant…

View the original on n8n.io → Check your own copy