📦 WooCommerce Order WhatsApp Notification Workflow (n8n)

Automatically sends WhatsApp messages or invoice links to customers when new or updated orders are detected in WooCommerce.
Logs both verified and unverified attempts in Google Sheets.

---

🎯 Who Is This For?

• WooCommerce store owners
• E-commerce managers and marketers
• Businesses looking to automate order notifications via WhatsApp
• Teams needing batch processing, verification, and logging for order communications

---

⚡ Overview

This workflow:

1. Listens for WooCommerce order events (order.updated or similar)
2. Cleans and structures customer/order data
3. Processes orders in batches for controlled throughput
4. Verifies phone numbers via Rapiwa API
5. Sends invoice links or messages to verified numbers
6. Logs all attempts to Google Sheets

---

🛠 What This Workflow Does

• Receives order events from WooCommerce
• Extracts customer, billing/shipping, product, and invoice details
• Batch processes orders/items for stable throughput
• Cleans phone numbers (billing.phone) by removing non-digit characters
• Verifies numbers via Rapiwa API
• Sends messages or invoice links to verified WhatsApp numbers
• Logs unverified numbers separately
• Maintains throttling using Wait nodes to respect API limits

---

✨ Key Features

• Trigger-based automation (WooCommerce or adaptable to Shopify)
• Batch processing with SplitInBatches
• Phone number cleaning via JavaScript
• Pre-send verification to reduce failed messages
• Conditional branching between verified/unverified flows
• Personalized message templates including customer and product details
• Logging to Google Sheets with separate tabs for verified/sent and unverified/not sent
• Wait nodes for throttling and looping control

---

🛠 Requirements

• n8n instance with nodes:
  HTTP Request, Code, SplitInBatches, IF, Google Sheets, Wait, WooCommerce Trigger
• Rapiwa account with Bearer token for verification/send endpoints
• Google Sheets with OAuth2 access
• WooCommerce store credentials
• Incoming order payload containing billing and line_items

---

📊 Google Sheet Format

Sample Sheet: Click Here

Customer Name	Phone Number	Email Address	Address	Product Title	Product ID	Size	Quantity	Total Price	Product Image	Invoice Link	Status	Validity
Abdul Mannan	8801322827799	contact@spagreen.net	mirpur	T-Shirt - XL	110	XL	1	BDT 499.00	https://your_shop_domain/Product/gg.img	https://your_shop_domain/INV/DAS	sent	verified
Abdul Mannan	8801322827799	contact@spagreen.net	mirpur	T-Shirt - XL	110	XL	1	BDT 499.00	https://your_shop_domain/Product/gg.img	https://your_shop_domain/INV/DAS	not sent	unverified

---

⚠️ Important Notes

• Ensure payload contains billing and line_items; update Code nodes if your source differs.
• Message template references products[0]; update logic to handle multiple items.
• Test in small batches first to avoid mass messaging and respect API limits.

---

🔗 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