AutomationMart
Home/Browse/Send WhatsApp bulk messages from Google Sheets
n8n

Send WhatsApp bulk messages from Google Sheets

n8nn8n7 modulesv1.0
Google SheetsDiscordWhatsAppFacebook

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

At a glance

Send WhatsApp bulk messages from Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Discord, WhatsApp, Facebook. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Discord, WhatsApp, Facebook
Modules
7
Price
Free
Version
v1.0
Send WhatsApp bulk messages from Google Sheets workflow diagram

About this workflow

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 | | | Leave the Status column empty for rows that need to be processed. --- Requirements - WhatsApp Business Cloud API access via Meta for Developers - 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 --- 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 - Discord: Join SpaGreen Server - Facebook Group: SpaGreen Community - Website: Visit SpaGreen Creative

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Send Android push notifications for new Discord messages

Every time a new message is posted on your Discord server, Make will automatically send a push notification to the Android device of your choice.

Free

WhatsApp group chat with your vector database — no Facebook Business required

Enable smart, real-time answers in your WhatsApp groups using a custom webhook, Pinecone vector database, and no Facebook Business setup. > 🟡 Note: This template uses a custom WhatsApp webhook. It does not use the official WhatsApp Business API. --- 👥 Who is this for? This workflow is designed for individuals and teams who want to enable smart WhatsApp group automation — without going through Meta’s official WhatsApp Business API. Ideal for small businesses, internal teams, communities, and

Free

Convert ISO 3166-1 codes listed in a Google Sheets spreadsheet to country names

This scenario uses the ISO service to automatically convert ISO 3166-1 codes listed in a specific Google Sheets spreadsheet to corresponding country names. The template uses a table created according to this [example](https://goo.gl/YeHIgY).

Free

Send filtered Google Sheets rows via email

Streamline your email communication by automatically sending emails based on specific criteria in your Google Sheets. This template filters rows in your Google Sheets and triggers an email to be sent whenever a row meets your defined conditions. Perfect for managing notifications, reminders, or updates, this workflow ensures that you never miss an important message while keeping your email outreach organized and efficient.

Free

Extract and process invoices with GPT-4, Google Drive, and Google Sheets

This template is a fully automated AI invoice processing workflow for n8n. It watches a Google Drive folder for new invoice PDFs, extracts all key information using an AI Agent, assigns the correct booking account, saves the renamed invoice in the right Drive folder, and updates your Google Sheets booking list. A perfect starter template if you want to build your own AI-powered accounting automation. What this workflow does - Monito

Free

Create and publish AI videos with Sora 2 Cameos, Gemini, and Blotato

Overview This workflow automatically creates short-form AI videos using Sora 2 Cameos, powered by n8n and AI agents. It connects viral content collection, AI script and prompt generation, video rendering, video merging, and multi-platform publishing into a single fully automated system. Once configured, the workflow runs end to end without manual editing or intervention. The workflow is designed for creators, marketers, and affiliate builders who want to scale faceless or avatar-style AI videos

Free

Discord server anti-impersonation / scammer tracker with data tables

Discord Member Change Tracker This n8n template demonstrates how to automatically monitor and track username and nickname changes across your Discord server members. Perfect for community moderation, security monitoring, and maintaining accountability in large servers! Use cases are many Try tracking suspicious account behavior, maintaining audit logs for member identity changes, or monitoring impersonation attempts in your community! Good to know This workflow runs hourly by default - adjust t

Free

AI-driven lead management and inquiry automation with ERPNext & n8n

Overview This workflow template automates lead management and customer inquiry processing by integrating ERPNext, AI agents, and email notifications. It streamlines the process of capturing leads, analyzing inquiries, and generating actionable responses. The workflow uses ERPNext to capture inquiries, analyzes them with AI, and notifies the appropriate team or individual, all while maintaining a professional approach. --- What This Template Does 1. ERPNext Webhook Integration: - Captures leads

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free