N8N Workflow
Send WhatsApp Upsell Recommendation Message for Shopify
Automate recovery messages for cancelled Shopify orders. Verify WhatsApp numbers via Rapiwa API, send personalized messages with discount codes, and log results in Google Sheets for better sales recovery.
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
- Configure Rapiwa HTTP Bearer credential and Google Sheets OAuth2 in n8n.
- Replace Shopify API endpoints and access token.
- Update Google Sheet ID, gid, and ensure exact column headers.
- Set schedule trigger interval.
- Verify HTTP Request nodes for Rapiwa verify & send message operations.
Google Sheet Structure
| Name | Number | Item Name | Coupon | Item Link | Validity | Status |
|---|---|---|---|---|---|---|
| Abdul Mannan | 8801322827799 | Samsung Galaxy S24 Ultra | REORDER5 | Reorder Link | verified | sent |
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
Support & Community
Item details
Release date
2025-11-12
Last update
2025-11-13
Similar items
Automates sharing Telegram Channel posts to WordPress, Facebook, X/Twitter, and LinkedIn, detecting content type and posting appropriately in real-time for creators and marketers.
$11.00
Buy now
A detailed workflow for n8n that collects user info, generates AI-driven follow-up questions, merges responses, and builds structured, ready-to-use prompts with clean formatting and automated parsing.
$3.00
Buy now
An automated n8n meeting booking workflow that checks availability, creates calendar events, sets up Zoom meetings, and sends multi-channel notifications seamlessly.
$19.00
Buy now
An automated n8n workflow that generates LinkedIn posts every 6 hours using AI, creates images and hashtags, posts to profiles and pages, and tracks topics in Google Sheets.
$9.00
Buy now
SpaGreen Store @ 2026 All rights reserved.
EN
USD
{{ recentPurchase.name.shorten(30) }}
Recently purchased
{{ recentPurchase.item_name.shorten(30) }}
Verified
Message
