WhatsApp Bulk Number Verification via Google Sheets (Unofficial Rapiwa API)

Automate WhatsApp number validation and optionally send messages directly from Google Sheets — no official WhatsApp Business API required.

---

Who This Is For

Ideal for:

• Marketers running WhatsApp campaigns
• Small business owners needing quick validation of customer numbers
• Freelancers & support teams managing outreach or notifications

Perfect when you want a budget-friendly, automated solution for verifying and messaging WhatsApp numbers.

---

How It Works

1. Scan Pending Rows
   Checks rows in Google Sheets where Status = pending.

2. Clean Numbers
   Removes non-digit characters for proper API formatting.

3. Verify via Rapiwa
   Uses /api/verify-whatsapp to confirm WhatsApp registration.

4. Process Results

   • Verified: Optional message sending; updates Verification = verified, Status = sent.
   • Unverified: Skips sending; updates Verification = unverified, Status = not sent.

5. Batch Processing & Delays
   Processes rows in batches with short delays to prevent rate-limiting.

6. Scheduled Automation
   Runs automatically on a configurable interval (recommended 5–10 minutes).

---

Key Features

• Configurable automatic schedule
• Cleans phone numbers before verification
• Verifies WhatsApp registration using Rapiwa
• Batch processing with throughput limits
• Short delay between items to prevent throttling
• Automatic sheet updates for auditability

---

Recommended Defaults

• Trigger interval: 5–10 minutes
• Max items per run: Configurable (e.g., 200 per cycle)
• Delay between items: 2–5 seconds (example: 3 sec)

---

Setup Instructions

1. Duplicate the Sample Google Sheet
2. Fill contact rows, set Status = pending, include columns:
   WhatsApp No, Name, Message, Verification, Status
3. Authenticate Google Sheets node in n8n
4. Create an HTTP Bearer credential in n8n and store your Rapiwa API key
5. Configure workflow nodes:
   Trigger → Google Sheets → Limit/SplitInBatches → Code (clean) → HTTP Request (verify) → If → Update Sheet → Wait
6. Enable the workflow and run a small test batch

---

Requirements

• n8n instance with Google Sheets & HTTP Request nodes
• Google Sheets OAuth2 credentials
• Rapiwa account & Bearer token
• Correctly formatted Google Sheet

---

Why Use Rapiwa

• Cost-effective, developer-friendly REST API
• Simple HTTP integration in n8n
• Avoids official WhatsApp Business API costs and setup

⚠️ Rapiwa is unofficial — review terms and risks before production use.

---

Customization Options

• Adjust trigger schedule and max items per run
• Modify Wait node delay to reduce throttling
• Add send-message node for automated WhatsApp messaging
• Log API responses to a separate audit sheet

---

Example HTTP Request Body (n8n)

{
  "number": "{{ $json['WhatsApp No'] }}"
}