Who Is This For This workflow is built for sales teams, marketers, support agents, and small business owners who store leads in Google Sheets and want to automatically send personalized WhatsApp welcome messages using the Rapiwa API. It is ideal for anyone looking to automate lead engagement, reduce manual work, and ensure fast WhatsApp follow-ups.

What This Workflow Does This n8n automation reads new leads from Google Sheets, verifies WhatsApp numbers through the Rapiwa API, sends a personalized welcome message, and updates the sheet with delivery and verification status. The workflow runs automatically every 5 minutes.

Key Features: Automatic execution every 5 minutes (adjustable) Google Sheets integration for reading and updating leads WhatsApp number verification via Rapiwa API Personalized messages using lead name Batch processing up to 60 messages per run Built-in 5-second delay to prevent API throttling Error handling for failed or unverified numbers Live status updates in Google Sheets Loop-based logic for continuous lead processing

Setup Overview: Prepare a Google Sheet with columns: WhatsApp No, name, row_number, status, check, validity. Connect Google Sheets to n8n via OAuth2. Sign up for Rapiwa, add your WhatsApp number, and get a Bearer Token. Configure HTTP Request nodes for number verification and message sending, then run the workflow.

Workflow Logic Runs every 5 minutes, fetches pending leads, cleans numbers, and verifies WhatsApp availability.