Verify WhatsApp Numbers in Bulk from Google Sheets

# 📘 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 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 - ✅ 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'] }}" }