Get Started
Back to Templates

Automated Shopify Abandoned Cart Recovery with WhatsApp Messages & Google Sheets

Created by

Created by: SpaGreen Creative || spagreen

SpaGreen Creative

Last update

Last update 6 hours ago

Categories

Share

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 number 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
    • Also send direct recovery links
  • Data Tracking:
    • Stores all outreach attempts in Google Sheets
    • Tracks which numbers were verified and which messages were sent otherwise not-sent
    • Save on sheet for verified and unverified contacts

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

Useful Links

Support & Help