WhatsApp Bulk Number Verification in Google Sheets Using Unofficial Rapiwa API

Who’s it for

This workflow is designed for marketers, small business owners, freelancers, and support teams who want to automate WhatsApp verification using Google Sheets without relying on the official WhatsApp Business API.

How it works / What it does

• Filters rows where Status = pending
• Cleans phone numbers (removes non-digits)
• Verifies numbers using Rapiwa API
• Updates Google Sheets with verification results
• Skips invalid numbers and marks them accordingly
• Processes data in batches with delays
• Runs automatically on a schedule

Key Features

• Automated scheduled verification
• Phone number formatting and cleaning
• WhatsApp validation via Rapiwa API
• Batch processing with limits
• Delay between requests to prevent rate limits
• Automatic status updates in Google Sheets

Recommended Defaults

• Trigger interval: every 5–10 minutes
• Max items per run: configurable (e.g., 200)
• Delay between items: 2–5 seconds

How to Set Up

1. Duplicate the sample Google Sheet template
2. Add contacts and set Status = pending
3. Connect Google Sheets in n8n
4. Add Rapiwa API key as Bearer token
5. Configure workflow nodes
6. Activate and test with small batches

Requirements

• n8n instance
• Google Sheets OAuth2 credentials
• Rapiwa API key
• Properly structured Google Sheet

Why use Rapiwa

• Cost-effective solution
• Easy REST API integration
• No need for official WhatsApp API

Customization

• Adjust schedule frequency
• Change batch size
• Modify delay timing
• Add logging or audit tracking
• Extend workflow with message sending

Best Practices

• Test with small batches first
• Keep sheet headers consistent
• Store API keys securely
• Adjust delay if rate limits occur

Example API Request

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

Optional Enhancements

• Add message sending after verification
• Separate verified/unverified logs into different sheets

Support & Community

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