Send WhatsApp Bulk Messages from Google Sheets
Already have an account? Sign in
WhatsApp Bulk Message Broadcast via Google Sheets (n8n Workflow)
Automate WhatsApp Outreach, Engage Customers Instantly, and Track Every Message
Use Case
This workflow is designed for marketing teams, support agents, and businesses handling high-volume WhatsApp messaging. Pull recipient and message data from a Google Sheet, send templated messages (with optional images), and update the sheet with delivery status—all automatically.
Who Is This For?
- Businesses running WhatsApp marketing campaigns
- Customer support or notification teams
- Administrators seeking a no-code, automated message distribution system using Google Sheets
What This Workflow Does
- Triggers automatically to scan for pending messages
- Fetches unsent rows from a Google Sheet
- Limits messages per execution to comply with API guidelines
- Sanitizes WhatsApp numbers for correct formatting
- Sends messages using a pre-approved WhatsApp template (text + optional image)
- Updates the sheet with "Sent" status upon successful delivery
Workflow Breakdown (Node by Node)
1. Trigger Every Minute
Continuously monitors pending rows and starts the workflow automatically.
2. Fetch Pending Queries
Reads rows from Google Sheets where the Status column is empty.
3. Limit Processing
Restricts execution to a set number of rows per run to manage API throughput.
4. Loop Over Items
Uses SplitInBatches to process each row individually.
5. Clean WhatsApp Number
Strips non-numeric characters from the WhatsApp No field to ensure valid formatting.
6. Send Message
Sends a WhatsApp message using the Cloud API with a pre-approved template.
Template options:
- Optional image header (
Image URL) - Dynamic variables for recipient
NameandMessage
Variables must be pre-defined and approved in Meta Developer Portal.
7. Update Status
Marks rows as Sent upon successful delivery.
Google Sheet Format
| WhatsApp No | Name | Message | Image URL | Status |
|---|---|---|---|---|
| +8801XXXXXXX | John Doe | Hello, your order shipped | https://.../img.jpg |
Leave the Status column empty for rows that need processing.
Requirements
- WhatsApp Business Cloud API access via Meta for Developers
- Properly structured Google Sheet as described above
- OAuth2 credentials in n8n for:
googleSheetsOAuth2ApiwhatsAppApi
Customization Options
- Adjust the Limit node to control rows per execution
- Modify the Trigger schedule (e.g., every 5 minutes)
- Replace the message template ID with your custom-approved Meta template
- Add error-handling logic (e.g.,
IForTry/Catch) to log failures or mark Status = Failed
Sample Sheet Template
Workflow Highlights
- Fully automated bulk WhatsApp messaging
- Optional image support in messages
- Real-time status tracking in Google Sheets
- Safe API usage with batch limits and number formatting
- Scalable for high-volume campaigns
Automate outreach, save hours of manual messaging, and ensure every lead or customer receives timely communication.
