Automated WhatsApp Recovery Messages for Cancelled Shopify Orders

Who Is This For?

This workflow helps Shopify store owners, customer-success teams, and marketing operators automatically verify WhatsApp numbers and send personalized recovery messages with discount codes for cancelled orders.

Key Features

• Scheduled trigger to check cancelled orders automatically
• Fetches cancelled orders via Shopify API
• Processes customer data to create personalized recovery messages
• Extracts product details and reorder links
• Verifies WhatsApp numbers via Rapiwa API
• Sends templated WhatsApp messages with discount codes
• Logs results to Google Sheets ("Verified & Sent" or "Unverified & Not Sent")

Requirements

• Shopify store with API access
• Shopify API credentials (orders and customer data)
• Rapiwa account with Bearer token
• Google account with Sheets access and OAuth2 credentials

Step-by-Step Setup

1. Configure Rapiwa HTTP Bearer credential and Google Sheets OAuth2 in n8n.
2. Replace Shopify API endpoints and access token.
3. Update Google Sheet ID, gid, and ensure exact column headers.
4. Set schedule trigger interval.
5. Verify HTTP Request nodes for Rapiwa verify & send message operations.

Google Sheet Structure

Important Notes

• Do not hard-code API keys; always use n8n credentials.
• Ensure Google Sheets column headers match mapping keys exactly.
• Processes cancelled orders in batches to avoid rate limits.
• Update message templates and discount codes as needed.

Useful Links

• Install Rapiwa
• Rapiwa Dashboard
• Official Website
• Rapiwa Documentation
• Shopify API Docs

Support & Community

• WhatsApp
• Discord Community
• Facebook Group
• Website
• Developer Portfolio