Google Sheets to WhatsApp Bulk Messaging via Unofficial API

## 📘 n8n Workflow: WhatsApp Bulk Messaging via Unofficial API

## 📌 Overview

This n8n workflow allows you to send **unlimited WhatsApp messages directly from a Google Sheet** using your **own WhatsApp number** via [WasenderAPI.com](https://www.wasenderapi.com/), avoiding high WhatsApp Business API costs.

---

## 🔍 What It Does

- ✅ Reads live data from Google Sheets  
- 📤 Sends WhatsApp messages to listed numbers  
- 🛡 Maintains API rate limits to prevent blocking  
- 🔄 Updates the status in Google Sheet after message is sent  

---

## 🧰 Prerequisites

Ensure you have the following:

- ✅ A **WhatsApp Account** (Personal or Business)  
- ✅ **Google Sheet API** access configured in n8n  
- ✅ A Google Sheet formatted like this [sample](https://docs.google.com/spreadsheets/d/1Ui4TzzI-Gq-bsEsrZELwW1Kyddw0IU9L1wxlHikktqw/edit?usp=sharing)  
- ✅ A **WasenderAPI.com** subscription (~$6/month)  

---

## 📄 Google Sheet Format

| WhatsApp No | Message                     | Status   |
|-------------|-----------------------------|----------|
| +8801XXXXXXX | Hello, this is a test msg. | pending  |

> ℹ️ Make sure the `Status` column has value `pending` initially.

---

## 🛠 Setup in n8n

### 1. 🔗 Connect Google Sheets
- Add a **Google Sheets** node
- Authenticate using your Google account
- Select the document and worksheet
- Use filter: `Status = pending`

### 2. 🔄 Loop Through Rows
- Use **SplitInBatches** or a **Code** node to process rows in small chunks (e.g., 5 rows)
- Add a **Wait** node to delay 5 seconds between messages

### 3. 🌐 Send Message via HTTP Node
- Add an **HTTP Request** node
- **Method**: `POST`
- **URL**: `https://app.wasenderapi.com/api/send-message`
- **Headers**:
  - `Content-Type`: `application/json`
  - `Authorization`: `Bearer YOUR_API_KEY`
- **JSON Body**:
```json
{
  "number": "{{ $json['WhatsApp No'] }}",
  "message": "{{ $json['Message'] }}"
}