Automated WhatsApp welcome messages for sales leads with Google Sheets & Rapiwa

Automated WhatsApp Welcome Messages for Sales Leads with Google Sheets & Rapiwa

Who is this for?

This automation is ideal for sales teams, digital marketers, support agents, or small business owners who collect leads in Google Sheets and want to automatically send WhatsApp welcome messages. It's a cost-effective and easy-to-use solution built for those not using the official WhatsApp Business API but still looking to scale communication.

---

What this Workflow Does

This n8n automation reads leads from a connected Google Sheet, verifies if the provided WhatsApp numbers are valid using the Rapiwa API, and sends a personalized welcome message. It updates the sheet based on delivery success or failure, and continues this process every 5 minutes — ensuring new leads are automatically engaged.

---

Key Features - Automatic Scheduling: Runs every 5 minutes (adjustable) - Google Sheets Integration: Reads and updates lead data - WhatsApp Number Validation: Confirms number validity via Rapiwa - Personalized Messaging: Uses lead name for custom messages - Batch Processing: Sends up to 60 messages per cycle - Safe API Usage: Adds 5-second delay between each message - Error Handling: Marks failed messages as not sent and unverified - Live Status Updates: Sheet columns are updated after each attempt - Loop Logic: Repeats continuously to catch new rows