🛒 Automate Shopify Abandoned Cart WhatsApp Reminders via Rapiwa

Automatically remind customers about abandoned carts on your Shopify store using WhatsApp messages with product links. This n8n workflow verifies numbers via Rapiwa API, sends personalized messages, and logs interactions in Google Sheets.

Who This Is For

• Shopify store owners & marketers
• Small business owners & freelancers
• Support teams managing customer follow-ups

Workflow Overview

1. Reads rows from Google Sheets with Status = pending
2. Cleans phone numbers (removes non-digits)
3. Verifies WhatsApp existence using Rapiwa API
4. If verified → sends WhatsApp message + updates sheet (sent, verified)
5. If unverified → skips send + updates sheet (not sent, unverified)
6. Waits between sends to avoid rate limits
7. Processes rows in batches and repeats automatically (default: every 5 minutes)

Setup Instructions

1️⃣ Prepare Google Sheet

• Columns: WhatsApp No, Name, Message, Image URL, Status, Verification
• Example row:

Sample Sheet

2️⃣ Configure n8n

• Google Sheets: OAuth2 credentials & sheet access
• Rapiwa: Bearer token (HTTP Bearer Auth)
• Workflow nodes: Trigger → Google Sheets → Limit → SplitInBatches → Code → HTTP Request → IF → Update Sheets → Wait

3️⃣ Configure Sending

• HTTP Request node → POST https://app.rapiwa.com/api/send-message
• Bearer authentication using Rapiwa API key
• JSON Body Example:

{
  "number": "{{ $json['WhatsApp No'] }}",
  "message": "{{ $json['Message'] }}"
}