WooCommerce WhatsApp Coupon Distribution Workflow
Who Is This For?
This workflow is ideal for WooCommerce store owners, marketers, and eCommerce managers who want to automatically send promotional WhatsApp messages when new coupons are created.
Overview
The workflow listens for WooCommerce coupon creation events (coupon.created), cleans and formats customer phone numbers, verifies WhatsApp registration via Rapiwa API, sends coupon messages to verified numbers, and logs all activity in Google Sheets.
What This Workflow Does
- Triggers on new coupon creation in WooCommerce
- Retrieves all customer data
- Processes customers in batches
- Cleans and formats phone numbers for WhatsApp
- Verifies WhatsApp numbers via Rapiwa API
- Sends personalized WhatsApp messages with coupon details
- Logs verified and unverified sends in separate Google Sheets
Key Features
- Automated coupon distribution via WooCommerce Trigger
- Customer data retrieval and processing
- WhatsApp number validation before sending
- Personalized messages with customer and coupon info
- Dual logging system in Google Sheets
- Batch processing and wait nodes for rate limiting
- Consistent coupon data formatting for messaging
Google Sheet Column Structure
| name |
number |
email |
address1 |
couponCode |
couponTitle |
couponType |
couponAmount |
createDate |
expireDate |
validity |
status |
| Abdul Mannan |
8801322827799 |
contact@spagreen.net |
mirpur-DOHS |
62dhryst |
eid offer 2025 |
percent |
20.00 |
2025-09-11 06:08:02 |
2025-09-15 00:00:00 |
unverified |
not sent |
| Abdul Mannan |
8801322827799 |
contact@spagreen.net |
mirpur-DOHS |
62dhryst |
eid offer 2025 |
percent |
20.00 |
2025-09-11 06:08:02 |
2025-09-15 00:00:00 |
verified |
sent |
Requirements
- n8n instance with nodes: WooCommerce Trigger, Code, SplitInBatches, HTTP Request, IF, Google Sheets, Wait
- WooCommerce store with API access
- Rapiwa account with API access
- Google account with Sheets access
- Customer phone numbers stored in WooCommerce billing.phone field
Important Notes
- Phone numbers must be cleaned; workflow removes all non-digit characters.
- Respect Rapiwa and WooCommerce API rate limits by adjusting batch sizes and wait nodes.
- Ensure compliance with data protection regulations when sending messages.
- Message template currently uses only the first coupon (
coupons[0]); adjust for multiple coupons if needed.
Useful Links
Support & Help