N8N Workflow
Automated WhatsApp Welcome Messages for Sales Leads with Google Sheets & Rapiwa
Automatically send WhatsApp welcome messages to sales leads from Google Sheets using Rapiwa API. Validates numbers, sends personalized messages, updates status, and processes new leads every 5 minutes
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 sentandunverified - Live status updates in sheet
- Loop logic for continuous processing of new leads
Step-by-Step Setup
- Prepare your Google Sheet with columns:
WhatsApp No,name,row_number,status,check,validity - Connect Google Sheets in n8n using OAuth2
- Sign up for Rapiwa, add your WhatsApp number, and get Bearer Token
- Configure HTTP Request nodes for Rapiwa API:
- Verify Number:
/verify-whatsapp - Send Message:
/send-message
- Verify Number:
- Run the n8n workflow — it reads leads, cleans numbers, verifies, sends messages, and updates the sheet
Google Sheet Column Reference
| name | number | time | check | validity | status | |
|---|---|---|---|---|---|---|
| Abdul Mannan | 8801322827799 | contact@spagreen.net | September 14th 2025, 10:34 | checked | verified | sent |
| Abdul Mannan | 8801322827798 | contact@spagreen.net | September 14th 2025, 10:34 | checked | unverified | not sent |
Workflow Logic Summary
- Trigger every 5 minutes
- Fetch pending rows from sheet (limit 60 per run)
- Clean and format phone numbers
- Check number validity via Rapiwa
- If valid → send WhatsApp message; else → mark as
not sentandunverified - Update sheet row with status and validity
- Wait 5 seconds before next message
- 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
nameincludes 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
Similar items
Collect form submissions automatically and store them in Google Sheets. Clean, format, and batch process data with n8n, adding timestamps and optional delays for smooth handling of bulk entries
Free
Buy now
A detailed workflow for n8n that collects user info, generates AI-driven follow-up questions, merges responses, and builds structured, ready-to-use prompts with clean formatting and automated parsing.
$3.00
Buy now
Automate content creation, distribution, and posting across multiple platforms. Extract text from PDFs and images, optionally generate new images using AI, and automatically post to WordPress, Facebook, LinkedIn, Telegram, Discord, and more. Streamline your social media workflow effortlessly.
$4.00
Buy now
This n8n workflow automatically identifies customers who have abandoned their carts on your Shopify store, cleans and verifies their WhatsApp numbers, and sends them personalized reminders via the Rapiwa API. It also logs each interaction—whether the number was valid or not—into a connected Google Sheet. Designed for marketers, small business owners, freelancers, and support teams, this solution makes it easy to run bulk WhatsApp campaigns using just a Google Sheet and your own WhatsApp number—no need for the unofficial WhatsApp API.
Free
Buy now
SpaGreen Store @ 2026 All rights reserved.
EN
USD
{{ recentPurchase.name.shorten(30) }}
Recently purchased
{{ recentPurchase.item_name.shorten(30) }}
Verified
Message
