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

| 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 | https://your_shop_domain/p-img-nike | verified | sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | 850 | | Sharp Most Demanding Hoodie x Nike | https://your_shop_domain/p-img-nike | unverified | not sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | 850 | | Sharp Most Demanding Hoodie x Nike | https://your_shop_domain/p-img-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:** 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