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 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): | name | number | email | address1 | price | suk | title | product link | validity | staus | | ---------- | ------------- | ----------------------------------------------- | ----------- | ----- | --- | ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------- | -------- | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | 850 | | Sharp Most Demanding Hoodie x Nike | | verified | sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | 850 | | Sharp Most Demanding Hoodie x Nike | | unverified | not sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | 850 | | Sharp Most Demanding Hoodie x Nike | | verified | sent | 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: - Official Website: - Documentation: Support & Help - WhatsApp: Chat on WhatsApp - Discord: SpaGreen Community - Facebook Group: SpaGreen Support - Website: - Developer Portfolio: Codecanyon SpaGreen