WhatsApp number verify & confirmation system with Rapiwa API and Google Sheets

WhatsApp Number Verify & Confirmation System with Rapiwa API and Google Sheets ---

Who is this for? This n8n workflow makes it easy to verify WhatsApp numbers submitted through a form. When someone fills out the form, the automation kicks in—capturing the data via a webhook, checking the WhatsApp number using the Rapiwa API, and sending a confirmation message if the number is valid. All submissions, whether verified or not, are logged into a Google Sheet with a clear status.

It’s a great solution for businesses, marketers, or developers who need a reliable way to verify leads, manage event signups, or onboard customers using WhatsApp.

---

How it works? This n8n automation listens for form submissions via a webhook, validates the provided WhatsApp number using the Rapiwa API, sends a confirmation message if the number is verified, and then appends the submission data to a Google Sheet, marking each entry as verified or unverified.

---

Features - Webhook Trigger: Captures form submissions via HTTP POST - Data Cleaning: Formats and sanitizes the WhatsApp number - Rapiwa API Integration: Checks if the number is registered on WhatsApp - Conditional Messaging: Sends confirmation messages only to verified WhatsApp users - Google Sheets Integration: Appends all submissions with a validity status - Auto Timestamping: Adds the submission date in YYYY-MM-DD format - Throttling Support: Built-in delay to avoid hitting API or sheet rate limits - Separation of Verified/Unverified: Distinct handling for both types of entries

--- Nodes Used in the Workflow - Webhook - Format Webhook Response Data (Code) - Loop Over Items (Split In Batches) - Cleane Number (Code) - check valid whatsapp number (HTTP Request) - If (Conditional) - Send Message Using Rapiwa - verified append row in sheet (Google Sheets) - unverified append row in sheet (Google Sheets) - Wait1