Send WooCommerce cross-sell offers to customers via WhatsApp using Rapiwa API

Who Is This For?

This n8n workflow enables automated cross-selling by identifying each WooCommerce customer's most frequently purchased product, finding a related product to recommend, and sending a personalized WhatsApp message using the Rapiwa API. It also verifies whether the user's number is WhatsApp-enabled before sending, and logs both successful and unsuccessful attempts to Google Sheets for tracking.

What This Workflow Does

• Retrieves all paying customers from your WooCommerce store
• Identifies each customer's most purchased product
• Finds the latest product in the same category as their most purchased item
• Cleans and verifies customer phone numbers for WhatsApp compatibility
• Sends personalized WhatsApp messages with product recommendations
• Logs all activities to Google Sheets for tracking and analysis
• Handles both verified and unverified numbers appropriately

Key Features

• Customer Segmentation: Automatically identifies paying customers from your WooCommerce store
• Product Analysis: Determines each customer's most purchased product
• Smart Recommendations: Finds the latest products in the same category as customer favorites
• WhatsApp Integration: Uses Rapiwa API for message delivery
• Phone Number Validation: Verifies WhatsApp numbers before sending messages
• Dual Logging System: Tracks both successful and failed message attempts in Google Sheets
• Rate Limiting: Uses batching and wait nodes to prevent API overload
• Personalized Messaging: Includes customer name and product details in messages

Requirements

• WooCommerce store with API access
• Rapiwa account with API access for WhatsApp verification and messaging
• Google account with Sheets access
• Customer phone numbers in WooCommerce (stored in billing.phone field)

How to Use — Step-by-Step Setup

1. Credentials Setup

• WooCommerce API: Configure WooCommerce API credentials in n8n (e.g., "WooCommerce (get customer)" and "WooCommerce (get customer data)")
• Rapiwa Bearer Auth: Create an HTTP Bearer credential with your Rapiwa API token
• Google Sheets OAuth2: Set up OAuth2 credentials for Google Sheets access

2. Configure Google Sheets

• Ensure your sheet has the required columns as specified in the Google Sheet Column Structure section

3. Verify Code Nodes

• Code (get paying_customer): Filters customers to include only those who have made purchases
• Get most buy product id & Clear Number: Identifies the most purchased product and cleans phone numbers

4. Configure HTTP Request Nodes

• Get customer data: Verify the WooCommerce API endpoint for retrieving customer orders
• Get specific product data: Verify the WooCommerce API endpoint for product details
• Get specific product recommend latest product: Verify the WooCommerce API endpoint for finding latest products by category
• Check valid WhatsApp number Using Rapiwa: Verify the Rapiwa endpoint for WhatsApp number validation
• Rapiwa Sender: Verify the Rapiwa endpoint for sending messages

Google Sheet Required Columns

You’ll need two Google Sheets (or two tabs in one spreadsheet): A Google Sheet formatted like this ➤ sample The workflow uses a Google Sheet with the following columns to track coupon distribution: Both must have the following headers (match exactly):

Important Notes

• Phone Number Format: The workflow cleans phone numbers by removing all non-digit characters. Ensure your WooCommerce phone numbers are in a compatible format.
• API Rate Limits: Rapiwa and WooCommerce APIs have rate limits. Adjust batch sizes and wait times accordingly.
• Data Privacy: Ensure compliance with data protection regulations when sending marketing messages.
• Error Handling: The workflow logs unverified numbers but doesn't have extensive error handling. Consider adding error notifications for failed API calls.
• Product Availability: The workflow recommends the latest product in a category, but doesn't check if it's in stock. Consider adding stock status verification.
• Testing: Always test with a small batch before running the workflow on your entire customer list.

Useful Links

• Dashboard: https://app.rapiwa.com
• Official Website: https://rapiwa.com
• Documentation: https://docs.rapiwa.com

Support & Help

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