Real-time lead response across social channels with Llama AI & Google Sheets

by Avkash Kakdiya ✓ · 356 views · created 2025-12-24 · Lead Nurturing, AI Chatbot

What this workflow does

This workflow has 24 nodes and runs when an HTTP POST request hits its webhook URL (plus 4 other triggers). Along the way it connects Google Sheets, Gmail and WhatsApp Business Cloud. It also calls api.groq.com over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 4 other triggers).

1. Normalize Lead Data (Edit Fields (Set)): sets 5 fields: body.lead_name, body.contact_phone, body.message_text…
2. Normalize Lead Data (Edit Fields (Set)): sets 5 fields: body.lead_name, body.contact_phone, body.message_text…
3. Normalize Lead Data (Edit Fields (Set)): sets 5 fields: body.lead_name, body.contact_phone, body.message_text…
4. Normalize Lead Data (Edit Fields (Set)): sets 5 fields: body.lead_name, body.contact_phone, body.message_text…
5. Normalize Lead Data (Edit Fields (Set)): sets 6 fields: body.lead_name, body.contact_phone, body.message_text…
6. Switch: routes items into 5 branches
7. Extract Day and Hours (Code): runs custom JavaScript code
8. Is Working Day and Working Hour? (If): checks a condition and branches into true / false
9. Code: runs custom JavaScript code
10. Get Ai Response (HTTP Request): calls api.groq.com (POST)

…plus 9 more steps. See the full node list below.

Services it uses

Google SheetsGmailWhatsApp Business Cloud

HTTP calls to: api.groq.com

Before you upgrade to n8n 3.0

Nodes used (9)

• Google Sheetsn8n-nodes-base.googleSheets
• Edit Fields (Set)n8n-nodes-base.set
• Switchn8n-nodes-base.switch
• HTTP Requestn8n-nodes-base.httpRequest
• Gmailn8n-nodes-base.gmail
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Webhookn8n-nodes-base.webhook
• WhatsApp Business Cloudn8n-nodes-base.whatsApp

From the author

How it works This workflow acts as an instant SDR that replies to new inbound leads across multiple channels in real time. It first captures and normalizes all incoming lead data into a unified structure. The workflow then evaluates IST working days and…

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