🚀 Automate WooCommerce Order Updates via WhatsApp with Rapiwa

Keep your customers informed and engaged by automatically verifying WhatsApp numbers and sending order updates or invoice links directly via WhatsApp. Perfect for online stores, customer-success teams, and marketing operators, this workflow handles everything from number verification to logging sent messages—fully automated and adaptable to Shopify or other platforms.

---

Who Is This For?

Ideal for eCommerce store owners, support teams, and marketers who want to:

• Automatically notify customers of completed orders
• Send personalized invoice links via WhatsApp
• Reduce manual outreach and improve customer experience
• Track all notifications in Google Sheets for auditing

No coding or WhatsApp Business API required—fully automated and easy to set up.

---

What This Workflow Does / Key Features

• Listens for WooCommerce order events (order.updated or similar triggers)
• Filters only completed orders and maps payload to { customer, products, invoice_link }
• Iterates over line items with SplitInBatches to manage throughput
• Cleans phone numbers with Clean WhatsApp Number node
• Verifies WhatsApp numbers using Rapiwa API
• Sends templated WhatsApp messages for verified numbers
• Logs successful sends to "Verified & Sent" sheet and unverified numbers to "Unverified & Not Sent" sheet
• Uses batching and wait nodes to avoid API rate limits

---

Requirements

• Rapiwa Bearer Token (for WhatsApp verification and messaging)
• WooCommerce API or trigger (providing billing and line_items)
• n8n instance with nodes: WooCommerce Trigger, Code, SplitInBatches, HTTP Request, IF, Google Sheets, Wait
• Google account with Sheets access configured via OAuth2

---

Step-by-Step Setup

1. Configure Credentials

• Rapiwa: HTTP Bearer credential in n8n
• Google Sheets: OAuth2 credential in n8n
• WooCommerce: API credential or Webhook setup for order events

2. Configure Google Sheets

• Use your spreadsheet ID and ensure column headers exactly match the mapping keys
• Separate sheets/tabs for verified vs. unverified messages

3. Verify HTTP Request Nodes

• Verify endpoint: POST https://app.rapiwa.com/api/verify-whatsapp with { number }
• Send endpoint: POST https://app.rapiwa.com/api/send-message with message template referencing order details

---

Google Sheet Column Structure

Sample Sheet

Name	Number	Email	Address	Product Title	Product ID	Total Price	Invoice Link	Delivery Status	Validity	Status
Abdul Mannan	8801322827799	contact@spagreen.net	mirpur dohs	Air force 1 Fossil 1:1 - 44	238	BDT 5500.00	Invoice link	completed	verified	sent
Abdul Mannan	8801322827799	contact@spagreen.net	mirpur dohs h#1168 rd#10 av#10 mirpur dohs dhaka	Air force 1 Fossil 1:1 - 44	238	BDT 5500.00	Invoice link	completed	unverified	not sent

---

Important Notes

• Use n8n credentials; do not hard-code API keys
• Google Sheets headers must exactly match node mappings
• IF node expects string "true"; adjust if verify endpoint returns boolean
• Update message templates for multiple products if needed
• Test workflow with a small batch before full deployment

---

Useful Links

• Rapiwa Dashboard
• Official Rapiwa Website
• Rapiwa Documentation

---

Support & Help

• 💬 WhatsApp Support
• 🖥 SpaGreen Website
• 🛠 Discord Community
• 📘 Facebook Group
• 👨‍💻 Developer Portfolio

---

💡 Automate WooCommerce order notifications today—verify numbers, send messages, and log results—all without lifting a finger!