📱 Send bulk WhatsApp messages from Google Sheets using WasenderAPI

⚡ 754 views · 📱 Social Media & Email Marketing

💡 Pro Tip — If you’ve run into Facebook’s Graph API permission restrictions, ScraperNode is a community node that scrapes pages, groups, posts, and comments directly — no app review needed.

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

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 & 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

🔗 Nodes Used

Google Sheets, HTTP Request, Schedule Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup