Automate review request via WhatsApp for completed WooCommerce order with Rapiwa

Who is this for? This workflow is designed for online store owners, customer-success teams, and marketing operators who want to automatically verify customers' WhatsApp numbers and deliver order updates or invoice links via WhatsApp. It is built around WooCommerce order WooCommerce Trigger (order.updated) but is easily adaptable to Shopify or other platforms that provide billing and lineitems in the WooCommerce Trigger payload.

What this Workflow Does / Key Features - Listens for WooCommerce order events (example: order.updated) via a Webhook or a WooCommerce trigger. - Filters only orders with status "completed" and maps the payload into a normalized object: { data: { customer, products, invoicelink } } using the Code node Order Completed check. - Iterates over line items using SplitInBatches to control throughput. - Cleans phone numbers (Clean WhatsApp Number code node) by removing all non-digit characters. - Verifies whether the cleaned phone number is registered on WhatsApp using Rapiwa's verify endpoint (POST https://app.rapiwa.com/api/verify-whatsapp). - If verified, sends a templated WhatsApp message via Rapiwa (POST https://app.rapiwa.com/api/send-message). - Appends an audit row to a "Verified & Sent" Google Sheet for successful sends, or to an "Unverified & Not Sent" sheet for unverified numbers. - Uses Wait and batching to throttle requests and avoid API rate limits.

Requirements - HTTP Bearer credential for Rapiwa (example name in flow: Rapiwa Bearer Auth). - WooCommerce API credential for the trigger (example: WooCommerce (get customer)) - Running n8n instance with nodes: WooCommerce Trigger, Code, SplitInBatches, HTTP Request, IF, Google Sheets, Wait. - Rapiwa account and a valid Bearer token. - Google account with Sheets access and OAuth2 credentials configured in n8n. - WooCommerce store (or any WooCommerce Trigger source) that provides billing and lineitems in the payload.

How to Use — step-by-step Setup 1) Credentials - Rapiwa: Create an HTTP Bearer credential in n8n and paste your token (flow example name: Rapiwa Bearer Auth). - Google Sheets: Add an OAuth2 credential (flow example name: Google Sheets). - WooCommerce: Add the WooCommerce API credential or configure a Webhook on your store.

3) Configure Google Sheets - The exported flow uses spreadsheet ID: 1S3RtGt5xxxxxxxXmQis (Sheet gid=0) as an example. Replace with your spreadsheet ID and sheet gid. - Ensure your sheet column headers exactly match the mapping keys listed below (case and trailing spaces must match or be corrected in the mapping).

5) Verify HTTP Request nodes - Verify endpoint: POST https://app.rapiwa.com/api/verify-whatsapp — sends { number } (uses HTTP Bearer credential). - Send endpoint: POST https://app.rapiwa.com/api/send-message — sends number, messagetype=text, and a templated message that uses fields from the Clean WhatsApp Number output.

Google Sheet Column Structure The Google Sheets nodes in the flow append rows with these column keys. Make sure the spreadsheet headers A Google Sheet formatted like this ➤ [sample](https://docs.google.com/spreadsheets/d/1S3RtGt5tGk2sLLm9XQTI9C1C0bq2jx3TNuGQnXmQis/edit?usp=sharing)

| Name | Number | Email | Address | Product Title | Product ID | Total Price | Invoice Link | Delivery Status | Validity | Status | |----------------|---------------|-------------------|------------------------------------------|-----------------------------|------------|---------------|--------------------------------------------------------------------------------------------------------------|-----------------|------------|-----------| | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | Air force 1 Fossil 1:1 - 44 | 238 | BDT 5500.00 | [Invoice link](https://yourshopdomain/oxxxxoWRWqd) | completed | verified | sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs h1168 rd10 av10 mirpur dohs dhaka | Air force 1 Fossil 1:1 - 44 | 238 | BDT 5500.00 | [Invoice link](https://yourshopdomain/cxxxxuhtbLoWRWqd) | completed | unverified | not sent |