WhatsApp Bulk Message Broadcast From Google Sheet (Unofficial API)

Who’s it for

This workflow is designed for marketers, small business owners, freelancers, and support teams who want to automate WhatsApp messaging using a Google Sheet without paying for the WhatsApp Business API. Ideal for those who need a budget-friendly and scalable bulk messaging solution using their personal or business WhatsApp number.

How it works / What it does

This workflow reads a Google Sheet for rows where the Status column is set to pending, sends a message via the connected WhatsApp number using the WasenderAPI, and updates the message status to sent. It repeats this process every 10 seconds while maintaining a safe API rate limit.

How to set up

1. Duplicate the Sample Sheet: Use this format Sample Sheet.
2. Fill contacts: Add WhatsApp numbers, names, and messages. Set the Status column to pending.
3. Connect Google Sheets in the n8n node.
4. Subscribe to WasenderAPI and get your API key.
5. Paste API Key into the HTTP node (if using unofficial API).
6. Activate your workflow in n8n.

Requirements

• Google Sheets API credentials
• A configured Google Sheet
• WhatsApp (Personal or Business)
• WasenderAPI.com subscription (approx. $6/month)
• n8n setup with credentials for Google Sheets

How to customize the workflow

• Add delay: Insert a Wait node if you want to add custom time gaps between messages.
• Change message format: Modify the HTTP/Send Template node to send different message types (text, media, etc.).
• Personalize content: Use dynamic data from sheet columns (e.g., name, image URL).
• Add error handling: Insert a Set or IF node after the WhatsApp send node to capture and log failed deliveries.

Workflow Highlights

• Triggers every 5 Minutes
• Reads pending messages from Google Sheets
• Sends WhatsApp messages using WasenderAPI or WhatsApp Cloud API
• Updates each row’s Status to sent

Support

If you need help with setup, integration, or customization, reach out for assistance.

WhatsApp: +8801322827799