Send AI-personalized WhatsApp campaigns with WhatsApp Business API and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 13 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects OpenAI Chat Model. It also calls sheets.googleapis.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Prepare Campaign Context (Edit Fields (Set)): sets 6 fields: campaignName, goals, phone…
- Python - Segment Audience (Code): runs custom Python code
- Wait: pauses before continuing
- Filter: keeps only the items that match a condition
- Wait: pauses before continuing
- AI - Generate Personalized Message (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- JS - Format Message (Code): runs custom JavaScript code
- Wait: pauses before continuing
- Send WhatsApp Message (HTTP Request): calls an HTTP API (POST)
- Update Analytics Sheet (HTTP Request): calls sheets.googleapis.com (POST)
Services it uses
HTTP calls to: sheets.googleapis.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI - Generate Personalized Message (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI - Generate Personalized Message (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Wait
n8n-nodes-base.wait - AI Agent
@n8n/n8n-nodes-langchain.agent - HTTP Request
n8n-nodes-base.httpRequest - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
This workflow automatically launches AI-powered personalized promotional campaigns to WhatsApp users. It handles audience segmentation, message personalization, delivery via WhatsApp Business API, and tracks performance in Google Sheets. Who’s it for •…