Confirm COD Shopify orders and manage RTO with GPT-4o-mini, WATI, and Shiprocket

by Rahul Joshi ✓ · 18 views · created 2026-10-06 · CRM, AI Summarization

What this workflow does

This AI workflow has 25 nodes and runs on Shopify events (plus 3 other triggers). Along the way it connects Shopify, Google Sheets, OpenAI and Telegram. It also calls apiv2.shiprocket.in over HTTP.

How it runs

Trigger: On Shopify events (plus 3 other triggers).

1. Set Store Config (Edit Fields (Set)): sets 29 fields: store_name, country_code, shopify_shop…
2. Get COD Orders Sheet (Google Sheets): uses Google Sheets
3. Decide Next Actions per Order (Code): runs custom JavaScript code
4. Needs AI Score? (If): checks a condition and branches into true / false
5. AI Assess RTO Risk (OpenAI): uses OpenAI
6. Split Into Actions (Code): runs custom JavaScript code
7. Apply AI Risk Score (Code): runs custom JavaScript code
8. Route by Action Type (Switch): routes items into 6 branches
9. Add New Order to Sheet (Google Sheets): append
10. Prepare Row Update (Code): runs custom JavaScript code

…plus 11 more steps. See the full node list below.

Services it uses

ShopifyGoogle SheetsOpenAITelegram

HTTP calls to: apiv2.shiprocket.in

Before you upgrade to n8n 3.0

Nodes used (12)

• Shopify Triggern8n-nodes-base.shopifyTrigger
• Webhookn8n-nodes-base.webhook
• n8n Form Triggern8n-nodes-base.formTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Switchn8n-nodes-base.switch
• HTTP Requestn8n-nodes-base.httpRequest
• Telegramn8n-nodes-base.telegram

From the author

Quick overview This workflow reduces COD RTOs by scoring new Shopify orders (rules + OpenAI), confirming them over WhatsApp via WATI, and dispatching confirmed orders to Shiprocket, while tracking statuses in Google Sheets and notifying ops via Telegram using…

View the original on n8n.io → Check your own copy