Bulk WhatsApp Number Verify via Unofficial API

# 📘 Bulk WhatsApp Number Verification via Unofficial API

## 📌 Overview

This **n8n workflow** verifies **unlimited WhatsApp numbers** from a **Google Sheet** using your **own WhatsApp number** through the [WasenderAPI.com](https://www.wasenderapi.com/) platform.

---

## 🔍 What It Does

- ✅ Fetches real-time data from Google Sheets  
- 🔍 Verifies if a number is registered on WhatsApp  
- 🛡 Implements delay and batch processing to maintain rate limits  
- ✏️ Updates verification status back to the Google Sheet  

---

## 🧰 Requirements

Before setting up the workflow, ensure you have:

- ✅ An active **WhatsApp Account** (Personal or Business)  
- ✅ **Google Sheets API** configured within your n8n instance  
- ✅ A properly structured [Google Sheet](https://docs.google.com/spreadsheets/d/1Ui4TzzI-Gq-bsEsrZELwW1Kyddw0IU9L1wxlHikktqw/edit?usp=sharing)  
- ✅ A **WasenderAPI.com** subscription (starting from ~$6/month)  

---

## 📄 Google Sheet Format

| WhatsApp No   | Verified/Unverified                         | Status     |
|---------------|----------------------------------|------------|
| +8801XXXXXXX  |  *(empty)* | *(empty)*  |

> ℹ️ Ensure the `Status` column is initially blank for unverified rows.

---

## ⚙️ How to Set Up in n8n

### Step 1: 🔗 Connect to Google Sheets
- Add a **Google Sheets** node.
- Authenticate with your Google account.
- Select your target document and worksheet.
- Apply a filter to only select rows where `Status` is empty.

### Step 2: 🔄 Loop Through Rows with Delay
- Add a **SplitInBatches** or **Code** node to process 5 rows at a time.
- Add a **Wait** node (set to 5 seconds) between each request to respect API limits.

### Step 3: 🌐 Verify Number via HTTP Request
- 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'] }}"
}