{"product_id":"n8n-whatsapp-gpt-4o-ndr-automation-for-shiprocket-delhivery","title":"n8n WhatsApp GPT-4o NDR Automation for Shiprocket \u0026 Delhivery","description":"\u003ch3\u003eAutomatically handle Shiprocket \u0026amp; Delhivery NDR on WhatsApp—powered by GPT-4o\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives \u003cstrong\u003ecourier non-delivery (NDR)\u003c\/strong\u003e webhooks from \u003cstrong\u003eShiprocket\u003c\/strong\u003e or \u003cstrong\u003eDelhivery\u003c\/strong\u003e, contacts the customer on \u003cstrong\u003eWhatsApp\u003c\/strong\u003e with resolution options, interprets replies using \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e, and submits the correct \u003cstrong\u003eNDR action\u003c\/strong\u003e back to the courier API—while escalating risky or stalled cases to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects NDR events:\u003c\/strong\u003e Listens for webhook payloads from Shiprocket\/Delhivery when tracking indicates a failed delivery.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes \u0026amp; deduplicates:\u003c\/strong\u003e Converts the courier payload into a consistent format, removes repeated attempts, calculates an \u003cstrong\u003eNDR reason\u003c\/strong\u003e, and computes an \u003cstrong\u003eRTO-risk score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds shipment context:\u003c\/strong\u003e Looks up shipment details in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then opens\/logs the case to an “\u003cstrong\u003eNDR Log\u003c\/strong\u003e” sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies the customer on WhatsApp:\u003c\/strong\u003e Sends a message with \u003cstrong\u003enumbered resolution options\u003c\/strong\u003e. If the phone number is missing or the risk is high, it alerts a \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads customer responses:\u003c\/strong\u003e When the customer replies on WhatsApp, the workflow matches the message to the latest open case in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts intent with AI:\u003c\/strong\u003e Uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to extract structured intent such as \u003cem\u003ereattempt\u003c\/em\u003e, \u003cem\u003ereschedule\u003c\/em\u003e, \u003cem\u003eaddress update\u003c\/em\u003e, \u003cem\u003ecancel\u003c\/em\u003e, or \u003cem\u003ealternate phone\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates requests \u0026amp; acts:\u003c\/strong\u003e For example, reschedules must be within \u003cstrong\u003e1–5 days\u003c\/strong\u003e and pincode changes are flagged. It either requests clarification on WhatsApp or escalates to Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers courier NDR actions:\u003c\/strong\u003e For valid requests, submits the appropriate NDR action via \u003cstrong\u003eShiprocket\/Delhivery HTTP APIs\u003c\/strong\u003e, logs the courier response, and confirms success to the customer or alerts Slack if needed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCustomer doesn’t receive delivery → immediate WhatsApp options to reschedule, update details, or cancel.\u003c\/li\u003e\n  \u003cli\u003eHigh-risk NDR (or missing phone) → automated Slack escalation for faster operations.\u003c\/li\u003e\n  \u003cli\u003eAccurate mapping of WhatsApp replies to the correct shipment case using Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e (Shiprocket\/Delhivery NDR trigger)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp\u003c\/strong\u003e (send resolution options, receive replies)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (shipment lookup, NDR Log, latest-case matching)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e for extracting intent from inbound replies\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e for risk\/stall escalation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic:\u003c\/strong\u003e if, code, switch, webhook, plus HTTP API calls to Shiprocket\/Delhivery\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232371921075,"sku":"N8N-21076","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/hy_LUEiBhwBIzDDfP3b5E_ETVLRqgw.png?v=1792141369","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-gpt-4o-ndr-automation-for-shiprocket-delhivery","provider":"N8N Commerce","version":"1.0","type":"link"}