Bulk WhatsApp Number Verification via Unofficial API

Validate WhatsApp numbers in bulk directly from Google Sheets without using the official WhatsApp Business API. Perfect for marketers, CRM managers, support teams, and data verification agents.

---

Who This Is For

• Marketers running WhatsApp campaigns
• CRM or sales teams needing clean lead data
• Support teams verifying customer numbers
• Data verification agents seeking scalable, affordable solutions

Ideal for teams who want a fast, budget-friendly, and automated number validation workflow.

---

Overview

This n8n workflow uses WasenderAPI.com (or your own WhatsApp number) to:

• Fetch real-time contact data from Google Sheets
• Verify if numbers are registered on WhatsApp
• Respect API limits with batch processing and delays
• Update verification status back into your sheet automatically

---

Requirements

• Active WhatsApp account (Personal or Business)
• n8n instance with Google Sheets API configured
• Properly structured Google Sheet (sample included)
• WasenderAPI.com subscription (~$6/month)

---

Google Sheet Format

Use this sample sheet as a template:

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

Ensure the Status column is blank for rows that need verification.

---

How It Works

1. Connect to Google Sheets

   • Add a Google Sheets node in n8n
   • Authenticate and select your worksheet
   • Filter to rows where Status is empty

2. Loop Through Rows with Delay

   • Use SplitInBatches or a Code node to process a small number of rows at a time
   • Add a Wait node (e.g., 5 seconds) between requests to prevent throttling

3. Verify Numbers via HTTP Request

   • Node type: HTTP Request
   • Method: POST
   • URL: https://app.wasenderapi.com/api/send-message
   • Headers:
     • Content-Type: application/json
     • Authorization: Bearer YOUR_API_KEY

4. Update Sheet

   • Mark each row as Checked in the Status column
   • Optionally log verification results as Verified or Unverified

---

Workflow Highlights

• Scheduled to trigger every 5 minutes
• Reads only pending contacts from Google Sheets
• Verifies WhatsApp numbers using WasenderAPI or WhatsApp Cloud API
• Updates each row’s Status automatically

---

Support & Community

• WhatsApp: Chat with Support
• Discord: SpaGreen Server
• Facebook Group: SpaGreen Community
• Website: SpaGreen Creative
• Portfolio: Codecanyon SpaGreen