Automate Personalized WhatsApp Broadcasts from Google Sheets
detail.loadingPreview
Effortlessly send personalized bulk WhatsApp messages directly from your Google Sheets. This n8n workflow automates the entire process, from fetching recipient data to sending templated messages and updating delivery statuses, saving you valuable time and ensuring consistent customer communication.
About This Workflow
Streamline your customer outreach with this powerful n8n workflow that transforms your Google Sheet into a dynamic WhatsApp broadcast engine. Designed for marketing and sales teams, it intelligently fetches pending messages from your spreadsheet, automatically cleans phone numbers for optimal delivery, and dispatches personalized WhatsApp template messages (including images, names, and custom text). Post-delivery, it diligently updates your Google Sheet with a 'Sent' status, providing a comprehensive audit trail and preventing duplicate sends. Say goodbye to manual messaging and hello to efficient, scalable communication.
Key Features
- Google Sheets as your CRM: Manage your contact lists and message content directly within a Google Sheet, including WhatsApp numbers, names, message bodies, image URLs, and status.
- Automated Bulk Messaging: Send hundreds of personalized WhatsApp template messages with just a trigger, without manual intervention.
- Dynamic Content Personalization: Utilize powerful expressions to insert recipient-specific data like names, custom messages, and images directly into your WhatsApp templates.
- Robust Number Cleaning: Automatically removes non-digit characters from phone numbers to ensure compatibility and successful message delivery via WhatsApp API.
- Real-time Status Tracking: Update message statuses (e.g., 'Sent') in your Google Sheet immediately after each message attempt, giving you clear visibility and preventing duplicate sends.
- Built-in Rate Limiting: Includes a configurable limit to control the number of messages processed per run, helping you manage API quotas and avoid overwhelming recipients.
How To Use
- Prepare your Google Sheet: Create a Google Sheet with columns like 'WhatsApp No', 'Name', 'Message', 'Image URL' (optional), and 'Status'. Populate it with your recipient data, leaving the 'Status' column blank or with a 'Pending' value for messages to be sent.
- Configure 'Fetch All Pending Queries for Messaging' (Google Sheets node):
- Select your Google Sheets credentials.
- Choose the
documentId(your spreadsheet) andsheetName(the specific tab). - In the 'Filters' section, add a filter for the 'Status' column, setting it to retrieve rows with 'Pending' or empty status.
- Adjust 'Limit' (Limit node): Set the
maxItemsparameter to control how many messages are processed in a single workflow execution. This is a safety measure and can be adjusted based on your needs and WhatsApp API limits. - Configure 'Send Message to 100 Phone No1' (WhatsApp node):
- Select your WhatsApp Business API credentials.
- Enter your
phoneNumberId. - Specify the
templatename (e.g.,n8n_broadcast_message|en). - Map the
recipientPhoneNumberto={{ String($json['WhatsApp No']) }}. - Map
components(header parameters likeimageLinkto={{ $json['Image URL'] }}and body parameters liketextto={{ $json.Name }}and={{ $json.Message }}).
- Configure 'Change State of Rows in Sent1' (Google Sheets node):
- Select the same Google Sheets credentials,
documentId, andsheetNameas the first Google Sheets node. - Set the
operationto 'Update'. - Under 'Columns', select 'row_number' as the
matchingColumnand map its value to={{ $('Limit').item.json.row_number }}. - Add a new column mapping for 'Status' and set its value to 'Sent'.
- Select the same Google Sheets credentials,
- Activate the workflow: Save and activate the workflow. You can trigger it manually or schedule it to run at regular intervals.
Apps Used
Workflow JSON
{
"id": "40057495-a46e-4d8e-85c7-b1f94dfce469",
"name": "Automate Personalized WhatsApp Broadcasts from Google Sheets",
"nodes": 27,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 40057495-a46e...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.