{"product_id":"shopify-cod-rto-automation-gpt-4o-mini-wati-shiprocket","title":"Shopify COD RTO Automation: GPT-4o-mini, WATI \u0026 Shiprocket","description":"\u003ch3\u003eReduce Shopify COD RTOs automatically—score, confirm via WhatsApp, dispatch via Shiprocket\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow helps you cut Return-to-Origin (RTO) risk for \u003cb\u003eShopify Cash on Delivery (COD)\u003c\/b\u003e orders by scoring new orders (rules + \u003cb\u003eOpenAI GPT-4o-mini\u003c\/b\u003e), confirming customers over \u003cb\u003eWATI\u003c\/b\u003e, dispatching to \u003cb\u003eShiprocket\u003c\/b\u003e, and tracking every status in \u003cb\u003eGoogle Sheets\u003c\/b\u003e with ops alerts via \u003cb\u003eTelegram\u003c\/b\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTriggers on multiple inputs\u003c\/b\u003e: new Shopify orders, incoming \u003cb\u003eWATI\/Shiprocket webhook\u003c\/b\u003e events, ops decisions submitted through an \u003cb\u003en8n form\u003c\/b\u003e, and a \u003cb\u003e15-minute schedule\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads COD tracker\u003c\/b\u003e from \u003cb\u003eGoogle Sheets\u003c\/b\u003e and decides the next action per order: confirm, remind, hold, dispatch, or perform \u003cb\u003eNDR follow-up\u003c\/b\u003e based on the latest status and timing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eScores RTO risk for new orders\u003c\/b\u003e using:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cb\u003eRule-based RTO risk\u003c\/b\u003e calculation\u003c\/li\u003e\n      \u003cli\u003e\n\u003cb\u003eGPT-4o-mini\u003c\/b\u003e assessment of address quality and fraud\/RTO likelihood\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpdates execution records\u003c\/b\u003e: writes the blended risk score + risk band back to Google Sheets and \u003cb\u003eupdates Shopify order tags\u003c\/b\u003e (including \u003cb\u003eorder cancellation when needed\u003c\/b\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCommunicates via WhatsApp\u003c\/b\u003e using \u003cb\u003eWATI\u003c\/b\u003e confirmation or reminder templates for low\/medium-risk orders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDispatches confirmed orders\u003c\/b\u003e by creating shipments in \u003cb\u003eShiprocket**, then saves shipment ID, AWB, courier, and shipment status to Google Sheets.\u003c\/b\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHandles delivery outcomes\u003c\/b\u003e: reacts to Shiprocket tracking updates by sending \u003cb\u003eWATI out-for-delivery\u003c\/b\u003e and \u003cb\u003efailed-delivery (NDR)\u003c\/b\u003e messages, optionally triggering Shiprocket NDR actions (e.g., re-attempt\/return), and alerts ops in \u003cb\u003eTelegram\u003c\/b\u003e for high-risk cases, repeated NDRs, or auto-cancellations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate \u003cb\u003eCOD RTO prevention\u003c\/b\u003e by confirming addresses before dispatch.\u003c\/li\u003e\n  \u003cli\u003eCentralize order\/dispatch\/NDR history in \u003cb\u003eGoogle Sheets\u003c\/b\u003e and reduce manual follow-ups.\u003c\/li\u003e\n  \u003cli\u003eSpeed up operations with webhook-driven updates from \u003cb\u003eShiprocket\u003c\/b\u003e and customer confirmations via \u003cb\u003eWATI\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\u003c\/b\u003e: if, set, code, switch, webhook, telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations\u003c\/b\u003e: Shopify orders, \u003cb\u003eOpenAI (gpt-4o-mini)\u003c\/b\u003e, \u003cb\u003eWATI\u003c\/b\u003e, \u003cb\u003eShiprocket\u003c\/b\u003e, \u003cb\u003eGoogle Sheets\u003c\/b\u003e, Telegram webhooks\/alerts\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164145864883,"sku":"N8N-20523","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OLQ1zM_xg26fpeumAFH2p_QBFZDqCl.png?v=1791277290","url":"https:\/\/buyflowscripts.com\/products\/shopify-cod-rto-automation-gpt-4o-mini-wati-shiprocket","provider":"N8N Commerce","version":"1.0","type":"link"}