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. --- How to Set Up 1. Set up a Shopify webhook for new orders (or connect a Google Sheet). 2. Create a Google Sheet with columns: name, number, order id, item name, total price, validity, status 3. Create and configure a Rapiwa Bearer token in n8n. 4. Add Google Sheets OAuth2 credential in n8n. 5. Import the workflow in n8n and configure these nodes: Webhook or Sheet Trigger Loop Over Items (SplitInBatches) Normalize Payload (Code) Clean WhatsApp Number (Code) Rapiwa WhatsApp Check (HTTP Request) Conditional Branch (If) Send WhatsApp Message (HTTP Request) Update Google Sheet (Google Sheets) Wait Node (delay per send) --- Requirements Shopify store with order webhook enabled (or order list in Google Sheet) A verified Rapiwa API token A working n8n instance with HTTP and Google Sheets nodes enabled A Google Sheet with required structure and valid OAuth credentials in n8n --- How to Customize the Workflow Modify the message template with your own brand tone or emojis. Add country-code logic in the Clean Number node if needed. Use a unique order id in your Google Sheet to prevent mismatches. Increase or decrease delay in the Wait node (e.g., 5–10 seconds). Use additional logic in Code nodes to handle discounts, promotions, or more line items. --- Workflow Highlights - Triggered by Shopify webhook update. - Receiving new order data form Shopify using webhook - Cleans and extracts order data from raw payload. - Normalizing and validating the customer’s WhatsApp number using the Rapiwa API - Verifies WhatsApp number using Rapiwa's verify-whatsapp endpoint. - Sends order confirmation via Rapiwa's send-message endpoint. - Logs every result into Google Sheets (verified/unverified + sent/not sent). --- Setup in n8n 1. Check WhatsApp Registration Use an HTTP Request node: URL: https://app.rapiwa.com/api/verify-whatsapp Method: POST Auth: httpBearerAuth using your Rapiwa token Body: { "number": "cleanednumber" } 2. Branch Based on Validity Use an If node: Condition: {{ $json.data.exists }} == true (or "true" if string) 3. Send Message via Rapiwa Endpoint: https://app.rapiwa.com/api/send-message Method: POST Body: Hi {{ $json.customerfullname }}, Thank you for shopping wi