🚀 Send Automatic WhatsApp Order Confirmations from Shopify with Rapiwa API

Boost your Shopify store's efficiency and customer experience by automatically sending personalized WhatsApp order confirmations using the Rapiwa API—without the cost of the official WhatsApp Business API.

---

Who This Is For

This n8n workflow is perfect for:

• Shopify store owners who want to automate order confirmations
• Small teams looking to save time and reduce manual work
• Entrepreneurs seeking a low-cost, personalized messaging solution

---

Key Benefits

• ✅ Automate WhatsApp order confirmations instantly
• ✅ Validate numbers with Rapiwa API before sending
• ✅ Log every action in Google Sheets for tracking
• ✅ Personalize messages with customer & order details
• ✅ Save money compared to official WhatsApp Business API

---

Features

• Receives Shopify order details via webhook
• Processes orders in manageable batches
• Extracts & formats customer and order details automatically
• Cleans WhatsApp numbers for consistent formatting
• Verifies number validity with Rapiwa API
• Sends templated WhatsApp messages to verified numbers only
• Updates Google Sheets with status and validity
• Adds delays to prevent rate limits
• Maintains a full audit trail

---

How It Works

1. Triggered by Shopify webhook or Google Sheet row
2. Cleans and normalizes order payload
3. Verifies WhatsApp number via Rapiwa API
4. ✅ If valid: send confirmation message & mark sent/verified
5. ❌ If invalid: skip sending & mark not sent/unverified
6. Adds delay between sends to avoid API limits

---

Setup in n8n

1. Verify WhatsApp Number

• HTTP Request node
  • URL: https://app.rapiwa.com/api/verify-whatsapp
  • Method: POST
  • Auth: httpBearerAuth with your Rapiwa token
  • Body: { "number": "cleaned_number" }

2. Branch Based on Validity

• If node condition: {{ $json.data.exists }} == true

3. Send Message via Rapiwa

• Endpoint: https://app.rapiwa.com/api/send-message
• Method: POST

---

Sample Google Sheet

name	number	order id	item name	total price	validity	status
Abdul Mannan	8801322827799	8986469695806	Iphone 10	1150	verified	sent
Abdul Mannan	8801322827799	8986469695806	S25 UltraXXXXeen Android Phone	23000	verified	sent

View Sample Sheet

---

Tips

• Always include country code (e.g., 880 for BD)
• Clean numbers: replace(/\D/g, '')
• Use unique order id for accurate updates
• Adjust Wait node delay (3–10 seconds)
• Test with a small sheet before going live

---

Future Enhancements

• Alerts via Telegram/Slack after batch completes
• Send media or invoices with messages
• Auto-mark fulfillment status from WhatsApp confirmations
• Detect & resend failed messages
• Deeper Shopify GraphQL API integration

---

Support & Community

• WhatsApp: 8801322827799
• Discord: Join
• Facebook: SpaGreen BD
• Website: spagreen.net
• Envato/Codecanyon: Portfolio