🎁 Shopify Auto Send WhatsApp Thank-You Messages & Loyalty Coupons Using Rapiwa API

Automatically reward your high-value customers with WhatsApp thank-you messages and discount coupons. This n8n workflow filters customers based on spending, verifies WhatsApp numbers with Rapiwa API, sends personalized messages, and logs everything in Google Sheets.

---

Who This Is For

• Shopify store owners & marketers
• Support teams aiming for customer retention
• Businesses rewarding high-value customers automatically

---

What It Does

• Fetches customer data from Shopify
• Filters customers where total_spent > 5000
• Cleans phone numbers (removes non-digit characters, formats internationally)
• Verifies numbers via Rapiwa API
• Sends personalized coupon or thank-you messages
• Logs every attempt to Google Sheets (status & validity)
• Uses batching and Wait nodes to prevent rate limits

---

Key Features

• Shopify webhook trigger: discounts/create or manual trigger
• Pre-send WhatsApp verification to reduce failed sends
• Google Sheets logging and status updates
• Batch processing with delay for API safety

---

Setup Instructions

1️⃣ Prepare Google Sheet

• Columns: name, number, status, validity, check (optional)
• Example: | Name | Number | Status | Validity | |---------------|---------------|---------|------------| | Abdul Mannan | 8801322827798 | not sent | unverified | | Abdul Mannan | 8801322827799 | sent | verified |

Sample Sheet

2️⃣ Configure n8n Credentials

• Shopify store access token (X-Shopify-Access-Token)
• Rapiwa Bearer token (HTTP Bearer Auth)
• Google Sheets OAuth2

3️⃣ Configure Nodes

1. Webhook / Trigger: Shopify discounts/create or manual
2. HTTP Request (Shopify): /admin/api/<version>/customers.json
3. Code Node: Filter total_spent > 5000 and map fields
4. SplitInBatches: Process customers individually
5. Code Node: Clean number → waNoStr.replace(/\D/g, "")
6. HTTP Request (Rapiwa verify) → /verify-whatsapp
7. IF Node: Check data.exists → Verified / Unverified branch
8. HTTP Request (Rapiwa send-message) → send coupon/message
9. Google Sheets Append/Update: status & validity
10. Wait Node: 2–5 seconds delay

4️⃣ Test

• Run manually with a small batch (2–5 records)
• Verify logs in Google Sheets

---

Customization Ideas

• Filter customers by order count or tags
• Use personalized templates (name + coupon code)
• Add SMS/email fallback for unverified numbers
• Send admin summary via Slack/email
• Store logs in a database for analytics

---

Important Notes

• Normalize data.exists before IF node (boolean vs string)
• Column names in Google Sheet must match exactly
• Store Shopify & Rapiwa tokens securely
• Test small batches before scaling

---

Useful Links

• Rapiwa Dashboard
• Rapiwa Official Website
• Rapiwa Documentation

---

Support & Community

• WhatsApp Chat
• Discord: SpaGreen Community
• Facebook Group: SpaGreen Support
• Website
• Developer Portfolio: Codecanyon SpaGreen