WhatsApp Bulk Message Broadcast From Google Sheet - n8n Workflow

Marketing teams needing scalable outreach solutions.
Sales professionals managing large contact lists.
Businesses requiring automated client updates via WhatsApp.
Users looking for advanced n8n templates leveraging the Google Sheets n8n node and custom scripting.

• Developers needing a tested n8n workflow for high-volume WhatsApp API usage.

This powerful n8n workflow solves the challenge of executing high-volume, personalized communication campaigns via WhatsApp. By utilizing the Google Sheets n8n node as the central database for contacts and messages, and integrating directly with the WhatsApp Business Cloud API, users can execute scalable bulk message broadcasts. This specific n8n workflow is designed for efficiency and compliance, incorporating critical flow control features like rate limiting via the Limit n8n node and data validation via a custom Code n8n node. This ensures robust delivery and prevents exceeding API thresholds. This specific n8n workflow provides a complete, automated system from list management to delivery confirmation.

The process initiates automatically based on a predefined schedule, ensuring a continuous messaging loop.

1. Scheduled Execution: The n8n trigger, configured as a Schedule Trigger, starts the entire n8n workflow every five minutes.


2. Fetch Pending Messages: The Google Sheets n8n node reads the connected spreadsheet, applying a filter to retrieve only the rows where the Status column is empty, indicating a pending message.


3. Rate Limiting: The Limit n8n node restricts the total number of items processed in a single run to 300, a crucial step for managing API rate limits effectively.


4. Batch Processing: The Loop Over Items n8n node (Split In Batches) iterates through the limited dataset, ensuring sequential processing of records.


5. Data Preprocessing: A dedicated Code n8n node, Clean WhatsApp Number, ensures data integrity by stripping all non-digit characters from the WhatsApp number field, making the format compliant for the WhatsApp n8n node.


6. Message Broadcast: The WhatsApp n8n node sends the message using a pre-approved template (n8nbroadcastmessage|en). Variables for Name, Message, and Image URL are dynamically mapped from the Google Sheet data.


7. Update Status: Once the message attempt is completed, a final Google Sheets n8n node executes an update operation, setting the Status column of the corresponding row to Sent, thereby completing the cycle for that record and preventing its reprocessing by the next run of the n8n workflow.

To deploy this highly effective n8n workflow, follow these steps:

1. Import: Copy the provided n8n workflow JSON and import it into your n8n instance.


2. Google Sheets Setup: Create a new credential for the Google Sheets n8n node. Ensure this credential has read and write access to the specific spreadsheet used in the workflow. The spreadsheet must contain columns for WhatsApp No, Name, Message, Image URL (optional), and Status.


3. WhatsApp API Setup: Obtain the necessary API tokens, phone number ID, and application ID from your Meta (Facebook) Developer account. Create a new WhatsApp API credential in n8n.


4. Template Configuration: Verify that the message template ID used in the WhatsApp n8n node (n8nbroadcastmessage|en) matches an approved template in your Meta Business account and corresponds to the variables used (Name, Message, Image URL).


5. Activation: Activate the n8n workflow and run it manually once to test the connection and logic. Once confirmed, the scheduled n8n trigger will handle continuous execution.

This n8n workflow relies on several core components for flow control, data integration, and execution:

Trigger Every 5 Minute (Schedule Trigger n8n trigger): Initiates the entire n8n workflow automatically at five-minute intervals, ensuring continuous processing of the message queue.
Fetch All Pending Queries for Messaging (Google Sheets n8n node): The data source for the n8n workflow. It uses a read operation and a filter to select only rows where the 'Status' is empty, ensuring idempotence.
Limit (Limit n8n node): Restricts the flow to processing a maximum of 300 items per run, protecting against high API costs and rate limiting issues.
Loop Over Items (SplitInBatches n8n node): Manages the execution context for individual records, allowing the subsequent messaging and update steps to run per item.
Clean WhatsApp Number (Code n8n node): Executes custom JavaScript code to clean the phone number field by removing non-digit characters (/\D/g), essential for successful routing via the WhatsApp n8n node.
Send Message to 100 Phone No1 (WhatsApp n8n node): The primary action node. It is configured to send templated messages, mapping input data fields (Name, Message, Image URL) to the template placeholders, utilizing the official Meta/WhatsApp API.

• Change State of Rows in Sent1 (Google Sheets n8n node): Updates the original spreadsheet row using the row number as a matching column, setting the Status to 'Sent' upon successful processing in this n8n workflow.