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

Who Is This For?

Sales teams, marketers, support agents, or small business owners who collect leads in Google Sheets and want to automatically send personalized WhatsApp welcome messages using Rapiwa API.

What This Workflow Does

This n8n automation reads leads from Google Sheets, verifies WhatsApp numbers via Rapiwa API, sends a personalized welcome message, and updates the sheet with delivery status. Runs automatically every 5 minutes.

Key Features

• Automatic scheduling every 5 minutes (adjustable)
• Google Sheets integration: reads and updates lead data
• WhatsApp number validation via Rapiwa API
• Personalized messaging using lead name
• Batch processing (up to 60 messages per cycle)
• 5-second delay between messages to prevent throttling
• Error handling: marks failed messages as not sent and unverified
• Live status updates in sheet
• Loop logic for continuous processing of new leads

Step-by-Step Setup

1. Prepare your Google Sheet with columns: WhatsApp No, name , row_number, status, check, validity
2. Connect Google Sheets in n8n using OAuth2
3. Sign up for Rapiwa, add your WhatsApp number, and get Bearer Token
4. Configure HTTP Request nodes for Rapiwa API:
   • Verify Number: /verify-whatsapp
   • Send Message: /send-message
5. Run the n8n workflow — it reads leads, cleans numbers, verifies, sends messages, and updates the sheet

Google Sheet Column Reference

Workflow Logic Summary

1. Trigger every 5 minutes
2. Fetch pending rows from sheet (limit 60 per run)
3. Clean and format phone numbers
4. Check number validity via Rapiwa
5. If valid → send WhatsApp message; else → mark as not sent and unverified
6. Update sheet row with status and validity
7. Wait 5 seconds before next message
8. Repeat for next lead

Customization Ideas

• Send images or documents via Rapiwa
• Customize messages based on product or service
• Log failed messages to a separate sheet
• Send admin notifications for failed batches
• Support multilingual messages

Notes & Warnings

• The column name name includes a space — do not remove or rename
• Phone numbers must be in international format for Rapiwa
• Increase Wait node delay for high-volume messaging to prevent API throttling

Support

• WhatsApp Support
• Discord Community
• Facebook Group
• Website
• Developer Portfolio