💬 Automated Shopify abandoned cart recovery with WhatsApp messages & Google Sheets

⚡ 38 views · 💬 Lead Nurturing & AI Sales Agents

💡 Pro Tip — If you’ve run into Facebook’s Graph API permission restrictions, ScraperNode is a community node that scrapes pages, groups, posts, and comments directly — no app review needed.

Description

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

• Shopify Admin API: API Documentation
• Rapiwa: Get your WhatsApp API credentials
• Google Sheets API: Developer Documentation

Support & Help

• WhatsApp: Chat on WhatsApp
• Discord: SpaGreen Community
• Facebook Group: SpaGreen Support
• Website: https://spagreen.net
• Developer Portfolio: Codecanyon SpaGreen

🔗 Nodes Used

Google Sheets, HTTP Request, Schedule Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup