Send bulk WhatsApp messages from Google Sheets using WasenderAPI

Description

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

Duplicate the Sample Sheet: Use this format Sample Sheet.
Fill contacts: Add WhatsApp numbers, names, and messages. Set the Status column to pending.
Connect Google Sheets in the n8n node.
Subscribe to WasenderAPI and get your API key.
Paste API Key into the HTTP node (if using unofficial API).
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 & Community

Need help setting up or customizing the workflow? Reach out here:

WhatsApp: Chat with Support
Discord: Join SpaGreen Server
Facebook Group: SpaGreen Community
Website: SpaGreen Creative
Envato: SpaGreen Portfolio