WhatsApp marketing dashboard with dynamic broadcasts from Google Sheets to Meta templates
Ready for 3.0What this workflow does
This workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets. It also calls graph.facebook.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Get Template Structure from Table (Data table): get
- Get All Templates from Table (Data table): get
- Get Existing Templates from Table (Data table): get
- Get Contacts from Google Sheet (Google Sheets): uses Google Sheets
- Return Template List as JSON (Respond to Webhook): sends the response back to the webhook caller
- Clear Existing Templates (Data table): delete rows
- Dynamically Build Message Body (Code): runs custom JavaScript code
- Get Templates from Meta (HTTP Request): calls graph.facebook.com
- Send WhatsApp Message (HTTP Request): calls graph.facebook.com (POST)
- Split Templates into Items (Code): runs custom JavaScript code
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: graph.facebook.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- HTTP Request
n8n-nodes-base.httpRequest - Webhook
n8n-nodes-base.webhook - Data table
n8n-nodes-base.dataTable - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
This workflow provides a complete backend solution for building your own WhatsApp marketing dashboard. It enables you to send dynamic, personalized, and rich-media broadcast messages to an entire contact list stored in Google Sheets. The system is built on…