Send WhatsApp bulk messages from Google Sheets
    100%
    Automation
    0(0 reviews)
    401 downloads

    Send WhatsApp bulk messages from Google Sheets

    NM

    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)

    What's Included

    • Complete n8n workflow template with 0 nodes. Ready to import and customize.

    Requirements

    n8n instance (self-hosted or cloud). credentials.

    How to Use

    1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0++
    • Setup time: 5-15 min

    Included in Builder Pro — $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Mar 2026
    v1.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Dependencies & Requirements

    Google Sheets
    Data

    ⚠️ 1 service require credentials. Make sure you have accounts set up before importing.

    Reviews

    0

    No reviews yet

    See all 0 reviews ↓
    —

    0 reviews

    5★
    0
    4★
    0
    3★
    0
    2★
    0
    1★
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought