Send automatic WhatsApp order confirmations from Shopify with Rapiwa API

Send Automatic WhatsApp Order Confirmations from Shopify with Rapiwa API

Who’s it for This n8n workflow helps Shopify store owners and teams automatically confirm orders via WhatsApp. It checks if the customer's number is valid using Rapiwa API, sends a personalized message, and logs every attempt in Google Sheets—saving time and reducing manual work.

Whether you're a solo entrepreneur or managing a small team, this solution gives you a low-cost alternative to the official WhatsApp Business API, without losing control or personalization.

Features - Receives new order details via webhook upon order creation or update. - Iterates over incoming data in manageable batches for smoother processing. - Extracts and formats customer and order details from the Shopify webhook payload. - Strips non-numeric characters from WhatsApp numbers for consistent formatting. - Uses Rapiwa API to check if the WhatsApp number is valid and active. - Branches the workflow based on number validity — separates verified from unverified. - Sends a custom WhatsApp confirmation message to verified customers using Rapiwa. - Updates Google Sheet rows with status and validity

How it Works / What It Does Triggered by a Shopify webhook or by reading rows from a Google Sheet. Normalizes and cleans the order payload. Extracts details like customer name, phone, items, shipping, and payment info. Cleans phone numbers (removes special characters). Verifies if the number is registered on WhatsApp via Rapiwa API. If valid:

Sends a templated WhatsApp message. Updates Google Sheet with validity = verified and status = sent. If invalid:

Skips sending. Updates sheet with validity = unverified and status = not sent. Adds wait/delay between sends to prevent rate limits. Keeps an audit trail in the connected Google Sheet.

---