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 payingcustomer): 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