Templates / Send AI-personalized WhatsApp campaigns with WhatsApp Business API and Google Sheets

Send AI-personalized WhatsApp campaigns with WhatsApp Business API and Google Sheets

Needs changes

by Oneclick AI Squad ✓ · 245 views · created 2026-05-11 · Social Media, AI Summarization

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What 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).

  1. Prepare Campaign Context (Edit Fields (Set)): sets 6 fields: campaignName, goals, phone…
  2. Python - Segment Audience (Code): runs custom Python code
  3. Wait: pauses before continuing
  4. Filter: keeps only the items that match a condition
  5. Wait: pauses before continuing
  6. AI - Generate Personalized Message (AI Agent): runs an AI agent, with model: OpenAI Chat Model
  7. JS - Format Message (Code): runs custom JavaScript code
  8. Wait: pauses before continuing
  9. Send WhatsApp Message (HTTP Request): calls an HTTP API (POST)
  10. Update Analytics Sheet (HTTP Request): calls sheets.googleapis.com (POST)

Services it uses

OpenAI Chat Model

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.0Replace 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)

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 •…

Excerpt from Oneclick AI Squad's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.