Send WooCommerce new category alert via WhatsApp using Rapiwa API

Send WooCommerce New Category Alert via WhatsApp Using Rapiwa API

This n8n automation listens for the creation of a new WooCommerce product category, fetches all WooCommerce customers, cleans and formats their phone numbers, verifies them using the Rapiwa WhatsApp validation API, sends a WhatsApp message to verified numbers with the new category info, and logs each interaction into a Google Sheet (separately for verified and unverified customers).

Who this is for

You have a WooCommerce store and want to:

- Send a promotional message when a new product category is added, - Verify customer WhatsApp numbers in bulk, - Keep a clear log in Google Sheets of which numbers are verified or not.

What it does (high level)

1. Webhook is triggered when a new WooCommerce category is created. 2. Fetches all WooCommerce customers via API. 3. Limits processing to the first 10 customers (for performance/testing). 4. Cleans phone numbers (removes +, spaces, and non-digits). 5. Verifies each number via Rapiwa WhatsApp Verify API. 6. If verified: sends WhatsApp message with new category info, logs as Verification = verified, Status = sent. 7. If not verified: logs as Verification = unverified, Status = not sent. 8. Processes users in batches with delays to avoid rate limiting.

How it works (step-by-step)