🎁 WooCommerce Coupon WhatsApp Distribution Workflow (n8n)

Automatically sends promotional WhatsApp messages to customers whenever a new coupon is created in WooCommerce.
Logs all attempts in Google Sheets for tracking and analysis.

---

🎯 Who Is This For?

• WooCommerce store owners
• E-commerce marketers and managers
• Businesses aiming to boost coupon usage and engagement
• Teams seeking to automate coupon sharing while tracking performance

---

⚡ Overview

This workflow listens for WooCommerce coupon creation events (coupon.created) and automatically sends promotional WhatsApp messages via Rapiwa API.

Steps include:

1. Extract customer billing data
2. Clean and format phone numbers
3. Verify WhatsApp registration via Rapiwa API
4. Send personalized messages for verified numbers
5. Log results to Google Sheets (separate sheets for verified/sent and unverified/not sent)

---

🛠 What This Workflow Does

• Triggers on new coupon creation events in WooCommerce
• Retrieves all customer data from WooCommerce
• Processes customers in batches to control throughput
• Cleans and formats phone numbers for WhatsApp
• Verifies numbers via Rapiwa API
• Sends personalized coupon messages to verified numbers
• Logs all activity to Google Sheets for tracking
• Handles unverified numbers appropriately

---

✨ Key Features

• Automated Coupon Distribution: Messages are sent automatically when new coupons are created
• Customer Data Retrieval: Fetches billing info and contact details from WooCommerce
• Phone Number Validation: Ensures messages only go to WhatsApp-enabled numbers
• Personalized Messaging: Includes customer name and coupon details
• Dual Logging: Tracks both successful (sent) and unsuccessful (not sent) attempts
• Rate Limiting: Uses batching and wait nodes to avoid API overload
• Data Formatting: Standardizes coupon info for consistent messaging

---

📊 Google Sheet Column Structure

Sample Sheet: Click Here

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 for WhatsApp verification and messaging
• Google account with Sheets access
• Customer phone numbers stored in WooCommerce (billing.phone)

---

⚠️ Important Notes

• Phone Number Format: Numbers are cleaned of non-digit characters. Ensure WooCommerce phone numbers are compatible.
• API Rate Limits: Adjust batch sizes and wait nodes to respect Rapiwa and WooCommerce limits.
• Data Privacy: Comply with regulations when sending marketing messages.
• Error Handling: Unverified numbers are logged. Consider adding notifications for failed API calls.
• Message Content: Current template references the first coupon only (coupons[0]). Adjust if multiple coupons need processing.

---

🔗 Useful Links

• Rapiwa Dashboard: https://app.rapiwa.com
• Official Website: https://rapiwa.com
• Documentation: https://docs.rapiwa.com

---

💬 Support & Help

• WhatsApp: Chat on WhatsApp
• Discord: SpaGreen Community
• Facebook Group: SpaGreen Support
• Website: https://spagreen.net
• Developer Portfolio: Codecanyon SpaGreen