Who Is This For?

This workflow is perfect for e-commerce store owners using Shopify who want to automatically recover abandoned carts through personalized WhatsApp messages. It's ideal for businesses looking to increase conversion rates without manual outreach efforts.

What This Workflow Does

• Automated Cart Recovery: Runs on a schedule to check for abandoned checkouts
• Data Extraction: Retrieves abandoned checkout data from Shopify using both GraphQL and REST APIs
• Customer Data Processing:
  • Fetches detailed customer information including name, email, and phone number
  • Formats customer data for WhatsApp messaging
  • Creates personalized messages with recovery links and discount codes
• WhatsApp Verification: Verifies if customer phone numbers are registered on WhatsApp using Rapiwa API
• Targeted Messaging:
  • Sends personalized WhatsApp messages to verified numbers
  • Includes a 5% discount code (REOXXER5) to incentivize completion
  • Sends direct recovery links
• Data Tracking:
  • Stores all outreach attempts in Google Sheets
  • Tracks which numbers were verified and which messages were sent or not-sent
  • Saves verified and unverified contacts on the sheet

Requirements

• Shopify Admin API Access (to retrieve checkout and customer data)
• Google Sheets OAuth2 (for tracking outreach)
• Rapiwa API (for WhatsApp verification and messaging)

How to Use — Step-by-Step Setup

1. Set Up Credentials in n8n

• Add your Shopify Admin API credentials with access to customer and checkout data
• Add Google Sheets OAuth2 credentials (named "Google Sheets")
• Add Rapiwa API credentials (named "Rapiwa account 2")

2. Prepare Your Google Sheet

Google sheet: Example

3. Customize the Workflow

• Modify the Schedule
• Change the discount code from "REOXXXXR5" to your offer