Get Started
Back to Templates

Automated WhatsApp Upsell Messages for Shopify Cancellations with Rapiwa & Google Sheets

Created by

Created by: Rapiwa || rapiwa

Rapiwa

Last update

Last update a day ago

Categories

Share

Who is this for?

This workflow is for Shopify store owners, customer success, and marketing teams who want to automatically check customers’ WhatsApp numbers and send personalized messages with discount codes for canceled orders. It helps recover lost sales by reaching out with special offers.

What This Workflow Does

  • Automatically checks for canceled orders on a schedule
  • Fetches canceled orders from Shopify
  • Creates personalized recovery messages based on customer data
  • Verifies customers’ WhatsApp numbers via Rapiwa
  • Logs results in Google Sheets: “Verified & Sent” for successful messages, “Unverified & Not Sent” for unverified numbers

Requirements

  • Shopify store with API access enabled
  • Shopify API credentials with access to orders and customer data
  • Rapiwa account and a valid Bearer token
  • Google account with Sheets access and OAuth2 credentials

Setup plan

  1. Add your credentials

    • Rapiwa: Create an HTTP Bearer credential in n8n and paste your token (example name: Rapiwa Bearer Auth).
    • Google Sheets: Add an OAuth2 credential (example name: Google Sheets).

  2. Set up Shopify

    • Replace your_shopify_domain with your real Shopify domain.
    • Replace your_shop_access-token with your actual Shopify API token.

  3. Set up Google Sheets

    • Update the example spreadsheet ID and sheet gid with your own.
    • Make sure your sheet’s column headers match the mapping keys exactly—same spelling, case, and no extra spaces.

  4. Configure the Schedule Trigger

    • Choose how often you want the workflow to check for canceled orders (daily, weekly, etc.).

  5. Check the HTTP Request nodes

    • Verify endpoint: Should call Rapiwa’s verifyWhatsAppNumber.
    • Send endpoint: Should use Rapiwa’s send-message API with your template (includes customer name, reorder link, discount code).

Google Sheet Column Structure

The Google Sheets nodes in the flow append rows with these column. Make sure the sheet headers match exactly.

A Google Sheet formatted like this ➤ sample

| Name | Number | Item Name | Coupon | Item Link | Validity | Status |
| ------------ | ------------- | ------------------------------------------- | -------- | --------------------------------------------------------------------------------------------------------------------------------------------- | ----------- | ---------- | ------ |
| Abdul Mannan | 8801322827799 | Samsung Galaxy S24 Ultra 5G 256GB-512GB-1TB | REORDER5 | Re-order Link | verified | sent |
| Abdul Mannan | 8801322827790 | Samsung Galaxy S24 Ultra 5G 256GB-512GB-1TB | REORDER5 | Re-order Link | unverified | not sent |

Important Notes

  • Do not hard-code API keys or tokens; always use n8n credentials.
  • Google Sheets column header names must match the mapping keys used in the nodes. Trailing spaces are common accidental problems — trim them in the spreadsheet or adjust the mapping.
  • Message templates reference - update templates if you need to reference different data.
  • The workflow processes cancelled orders in batches to avoid rate limits. Adjust the batch size if needed.

Useful Links

Support & Help