
Curated by n8n Markets team
Last updated: March 8, 2026
# WhatsApp Bulk Message Broadcast via Google Sheets (n8n Workflow) ## Use Case This workflow enables automated bulk WhatsApp message broadcasting using the WhatsApp Business Cloud API. It pulls recipient and message data from a Google Sheet, sends templated messages (optionally with image headers), and updates the sheet with the message status. It is ideal for marketing teams, support agents, and businesses handling high-volume outreach. --- ## Who Is This For? - Businesses conducting WhatsApp marketing or outreach campaigns - Customer support or notification teams - Administrators seeking an automated, no-code message distribution system using Google Sheets --- ## What This Workflow Does - Triggers automatically every minute to scan for pending messages - Fetches unsent entries from a Google Sheet - Limits the number of messages processed per execution to comply with API usage guidelines - Sanitizes WhatsApp numbers for proper formatting - Sends messages using a pre-approved WhatsApp template (text and optional image) - Marks the row as "Sent" in the sheet upon successful delivery --- ## Workflow Breakdown (Node by Node) ### 1. Trigger Every 5 Minutes Initiates the workflow every minute using a scheduled trigger to continuously monitor pending rows. ### 2. Fetch All Pending Queries for Messaging Reads rows from a Google Sheet where the `Status` column is empty, indicating they haven’t been processed yet. ### 3. Limit Restricts processing to 2 rows per execution to manage API throughput. ### 4. Loop Over Items Uses `SplitInBatches` to iterate through each row individually. ### 5. Clean WhatsApp Number A code node that strips non-numeric characters from the `WhatsApp No` field, ensuring the format is valid for the API. ### 6. Send Message to 300 Phone No Sends a WhatsApp message using the WhatsApp Cloud API and a pre-approved template. Template includes: - An image from the `Image URL` column (as header, optional) - Dynamic variables for the recipient's `Name` and `Message` fields Template variables must be pre-defined and approved in the Meta Developer Portal, such as `{{1}}`, `{{2}}`. ### 7. Change State of Rows in Sent1 Updates the `Status` column to `Sent` for each successfully processed row using the row number as a reference. --- ## Google Sheet Format Structure your Google Sheet as shown below: | 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 to be processed. --- ## Requirements - WhatsApp Business Cloud API access via [Meta for Developers](https://developers.facebook.com/) - A properly structured Google Sheet as described above - Active OAuth2 credentials configured in n8n for: - `googleSheetsOAuth2Api` - `whatsAppApi` --- ## Customization Options - Update the `Limit` node to control how many rows are processed in each run - Adjust the trigger schedule (e.g., change to every 5 minutes) - Replace the message template ID with your own custom-approved one from Meta - Add error-handling logic (e.g., `IF` or `Try/Catch` nodes) to log failures or set `Status = Failed` --- ## Sample Sheet Template [View Sample Google Sheet](https://docs.google.com/spreadsheets/d/1nI-AwIR3Y1FYzV0lwjr9iK6Ia4WuD5eRtgJH819rIIc/edit?usp=drivesdk) --- ## Workflow Highlights - Automated execution every 1 minute - Reads and processes only pending records - Verifies WhatsApp numbers and delivers templated messages - Updates Google Sheet after each attempt --- ## Support & Community Need help setting up or customizing the workflow? - WhatsApp: [Contact Support](https://wa.me/8801322827799) - Discord: [Join SpaGreen Server](https://discord.gg/SsCChWEP) - Facebook Group: [SpaGreen Community](https://www.facebook.com/groups/spagreenbd) - Website: [Visit SpaGreen Creative](https://spagreen.net)
n8n instance (self-hosted or cloud). credentials.
1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation
Included in Builder Pro — $19/mo, 4,177 premium workflows
Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.
100% Secure Checkout
Refund requests within 7 days of a new subscription
⚠️ 1 service require credentials. Make sure you have accounts set up before importing.
0 reviews
No reviews yet.
Log in to ask a question.
No questions yet. Be the first to ask!