Send order tracking updates via WhatsApp and log events to Google Sheets

Description

This workflow automatically delivers real-time order updates to customers via WhatsApp — covering every stage from order confirmation through final delivery.

Who's it for
• E-commerce stores processing 50+ orders/day
• Logistics teams managing last-mile delivery
• Businesses wanting to reduce support tickets about order status

How it works / What it does
Receives order event via webhook (new order, shipped, out for delivery, delivered)
Extracts and normalises order + customer data
Detects the event type using JavaScript logic
Selects the matching WhatsApp message template
Sends the formatted message via WhatsApp Business API
Logs delivery receipt and audit trail to Google Sheets

Message Templates
• Order Confirmed: Order #ID confirmed with total amount
• Shipped: Tracking number + expected delivery date
• Out for Delivery: Same-day delivery alert
• Delivered: Thank-you confirmation message

How to set up
Import this workflow into n8n
Configure credentials: WhatsApp Business API, Google Sheets OAuth2
Replace YOUR_SHEET_ID with your actual Google Sheet ID
Replace YOUR_WHATSAPP_PHONE_NUMBER_ID with your Meta phone number ID
Set WHATSAPP_ACCESS_TOKEN in your n8n credentials
Activate the workflow and point your order system to the webhook URL

Requirements
• Meta WhatsApp Business API access (approved account)
• Google Sheets (for audit logging)
• Order management system capable of sending webhooks
• n8n instance (cloud or self-hosted)

How to customise
• Edit message text in the JS - Build Message Payload node
• Add new event types in the JS - Detect Order Event node
• Change sheet columns in Update Google Sheet Tracker
• Add error notification (e.g. Slack/email) in the Error Handler node