Shopify order fulfillment & send tracking link via WhatsApp using Rapiwa API

Description

Shopify Order Fulfillment & Send Tracking Link via WhatsApp Using Rapiwa API

Who is this for?
This n8n workflow automatically sends WhatsApp notifications to customers when their Shopify orders are fulfilled. It extracts order details, validates customer phone numbers for WhatsApp compatibility using the Rapiwa API, sends tracking information via WhatsApp, and logs all interactions in Google Sheets with appropriate verification status.

What this Workflow Does
This n8n workflow listens for new order fulfillments on Shopify and automatically sends a WhatsApp message with tracking details to customers. It uses the Rapiwa API to verify if the customer's number is on WhatsApp, formats all the data, sends a message, and logs everything to Google Sheets for tracking and auditing purposes.

Key Features
Webhook-Triggered**: Activates on new Shopify fulfillment events
Phone Number Validation**: Uses Rapiwa to check WhatsApp compatibility
Tracking Message Automation**: Sends real-time tracking messages via WhatsApp
Data Cleaning**: Formats phone numbers and customer data
Smart Branching**: Separates verified and unverified WhatsApp users
Google Sheets Logging**: Stores data with status labels for all messages
Rate-Limit Protection**: Wait node helps space API calls
Dual Sheet Logging**: Maintains separate records for verified and unverified numbers

Requirements
Tools & Services
An n8n instance (self-hosted or cloud)
A Shopify store with REST API access enabled
A Rapiwa.com account with:
Valid Bearer Token
Connected and verified WhatsApp number
A Google Sheet with the following columns:
Like this Sample Sheet
Google Sheets OAuth2 credentials** set up in n8n
Shopify API credentials** added to n8n
Rapiwa Bearer Token** added as httpBearerAuth credentials

How to Use
Step-by-step Setup
Connect Shopify to n8n
Use the Shopify Trigger node
Set event to fulfillments/create to capture new fulfillment events

Extract Webhook Data
Use a Code Node to format the webhook response
Capture order, customer, and tracking details

Fetch Complete Order Information
Add an HTTP Request Node using Shopify Admin API
Include the order ID to retrieve customer phone, email, and product details

Clean the Phone Number
Use a Code Node to:
Remove non-numeric characters
Format number to international standard
Combine customer first and last name

Batch Process Orders
Use the Split In Batches node to handle customers one-by-one

Validate WhatsApp Number
Use Rapiwa’s /verify-whatsapp endpoint with a Bearer Token
Check if number exists on WhatsApp

Conditional Branching
Use an If Node:
If data.exists === "true" → Verified path
Else → Unverified path

Send WhatsApp Message
Send tracking info with a personalized message:
Hi [Customer Name],
Good news! Your order has just been fulfilled.
Tracking Number: [Tracking Number]
Track your package here: [Tracking URL]
Thank you for shopping with us.
-Team SpaGreen Creative

Log Data to Google Sheets
Log verified and unverified entries in separate sheets
Include all relevant customer and tracking data

Add Delay Between Messages
Use the Wait Node to avoid rate limits on Rapiwa API

Requirements
A Shopify store with API access enabled
A Google Sheet with required column like this ➤ Sample
Rapiwa API account**:
Connected WhatsApp number
Valid Bearer Token
n8n** with:
Shopify API credentials
Rapiwa Bearer Token
Google Sheets OAuth2 credentials

Google Sheet Column Reference
A Google Sheet formatted like this ➤ Sample

| customer_id | name | email | number | tracking_company | tracking_number | tracking_url | product_title | status |
|---------------|-----------------|--------------------------------|---------------|------------------|-----------------|---------------------------------------------|----------------------------------------|------------|
| 8986XXXX06 | Abdul Mannan | [email protected] | 8801322827799 | Amazon Logistics | SG-OT-02 | https://traxxxG-OT-02 | S25 Ultra 5G Smartphone | verified |
| 883XXX7982 | Abdul Mannan | [email protected] | 8801322827799 | Amazon Logistics | SG-OT-N03 | https://traxxxGOT-N03| Samsung Galaxy S24 Ultra | verified |

Workflow Logic Summary
Shopify Webhook Trigger: On order fulfillment
Extract Webhook Payload
Fetch Order + Customer Details
Clean and Format Phone Number
Split into Single-Item Batch
Check WhatsApp Validity via Rapiwa
If Verified:
Send WhatsApp Message
Log to verified sheet
If Not Verified:
Skip message
Log to unverified sheet
Add Delay with Wait Node
Repeat for Next Fulfillment

Customization Ideas
Modify WhatsApp message to include delivery date or store contact
Send different messages for different product categories
Use product_type or shipping_zone to trigger separate workflows
Add admin alerts for unverified numbers
Store message delivery status (e.g., success, failed)

Notes & Warnings
Rapiwa is an unofficial WhatsApp API — delivery reliability is not guaranteed
The Google Sheet column name must include the space at the end
Wait node** may need longer delay for high-volume stores
Always format phone numbers in international format (e.g., 8801XXXXXXXXX)
Shopify API version used is 2025-07 — update as newer versions release
You must comply with WhatsApp terms and data privacy laws when messaging users

Useful Links
Dashboard:** https://app.rapiwa.com
Official Website:** https://rapiwa.com
Documentation:** https://docs.rapiwa.com

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