Automated Daily Shipment Tracking & Customer Notification Workflow

This n8n workflow automates the daily tracking of shipments from various couriers, integrates with courier APIs to fetch real-time status updates, and notifies customers via WhatsApp and email about their shipment statuses. The workflow begins with a scheduled trigger that runs each day at 9 AM, fetching shipment data from a Google Sheet. It filters out completed deliveries and empty tracking entries, then routes the remaining shipments to the appropriate courier’s API (Delhivery or DHL) based on the courier information. After retrieving tracking details, the response data is parsed and normalized. If a shipment status has changed since the last update, the workflow updates the Google Sheet, sends a WhatsApp message with the latest shipment details, and emails the customer. A summary of the workflow execution is logged for monitoring purposes. This automation is ideal for e-commerce businesses or logistics companies aiming to keep customers informed and streamline shipment tracking.