WooCommerce Automated Cross-Sell via WhatsApp
Who Is This For?
Online store owners, customer-success teams, and marketers who want to recommend products to WooCommerce customers via WhatsApp, automatically verifying numbers and logging results.
What This Workflow Does
- Retrieves paying customers from WooCommerce
- Identifies each customer's most purchased product
- Finds the latest product in the same category
- Cleans and verifies WhatsApp numbers using Rapiwa API
- Sends personalized WhatsApp messages with recommendations
- Logs all activity in Google Sheets for verified and unverified numbers
- Handles API rate limits via batching and wait nodes
Requirements
- WooCommerce store with API access
- Rapiwa account with API access
- Google Sheets with OAuth2 credentials
- Customer phone numbers stored in WooCommerce billing.phone
Google Sheet Structure
| name |
number |
email |
address1 |
price |
suk |
title |
product link |
validity |
status |
| Abdul Mannan |
8801322827799 |
contact@spagreen.net |
mirpur dohs |
850 |
|
Sharp Most Demanding Hoodie x Nike |
Link |
verified |
sent |
| Abdul Mannan |
8801322827799 |
contact@spagreen.net |
mirpur dohs |
850 |
|
Sharp Most Demanding Hoodie x Nike |
Link |
unverified |
not sent |
Important Notes
- Phone numbers are cleaned to remove non-digit characters; ensure WooCommerce data is compatible.
- Respect API rate limits; adjust batch sizes and wait nodes accordingly.
- Comply with data protection regulations when sending marketing messages.
- Test with a small batch before sending to all customers.
Useful Links
Support & Help