Verify WhatsApp numbers in bulk using Google Sheets & WasenderAPI

Description

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 a sample sheet(Included with the workflow template)
A WasenderAPI.com subscription (starting from ~$6/month)

Google Sheet Format

Use this sample sheet as your base.

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

> 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 & Community

Need help setting up or customizing the workflow? Reach out here:

WhatsApp: Chat with Support
Discord: Join SpaGreen Server
Facebook Group: SpaGreen Community
Website: SpaGreen Creative
Envato: SpaGreen Portfolio