Verify WhatsApp Numbers in Bulk using Google Sheets & WasenderAPI

Bulk WhatsApp Number Verification via Unofficial API

Who’s it for

This workflow is perfect for marketers, CRM managers, support teams, and data verification agents who need to bulk-check WhatsApp number validity without using the official WhatsApp Business API. It is ideal for teams seeking an affordable and scalable way to clean or validate phone number lists from Google Sheets.

Overview

This n8n workflow verifies unlimited WhatsApp numbers from a Google Sheet using your own WhatsApp number through the WasenderAPI.com platform.

How it works / 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 like this Sample Sheet
• A WasenderAPI.com subscription (starting from ~$6/month)

Google Sheet Format

Use this sample sheet as your base.

Ensure the Status column is initially blank for unverified rows.

How to set up

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

Workflow Highlights

• Triggers every 5 Minutes
• Reads pending contact from Google Sheets
• Verify WhatsApp number using WasenderAPI or WhatsApp Cloud API
• Updates each row’s Status to Checked

Support

If you need help with setup, integration, or customization, reach out for assistance.

WhatsApp: 8801322827799