{"product_id":"shopify-whatsapp-order-status-bot-with-openai-shiprocket","title":"Shopify WhatsApp Order Status Bot with OpenAI \u0026 Shiprocket","description":"\u003ch3\u003eHandle “Where’s my order?” on WhatsApp automatically—powered by OpenAI, live Shopify lookups, and Shiprocket tracking\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow answers WhatsApp order status questions with an OpenAI agent, fetching recent Shopify orders by phone and pulling live Shiprocket tracking by AWB. Every conversation is logged to Google Sheets, and when needed, it hands off to a human via Slack with a one-click “resume bot” link.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives WhatsApp messages\u003c\/b\u003e: Triggers on each new WhatsApp message and extracts sender phone number, name, message type, and text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDetects chat mode from Google Sheets\u003c\/b\u003e: Looks up the phone number in the Google Sheets tab \u003cb\u003e“WISMO Conversations”\u003c\/b\u003e to decide whether the user is in \u003cb\u003ebot mode\u003c\/b\u003e, \u003cb\u003ehuman mode\u003c\/b\u003e, or \u003cb\u003eunsupported (non-text) mode\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRoutes to Slack for human help\u003c\/b\u003e: If in human mode, forwards the customer’s message to a \u003cb\u003eSlack\u003c\/b\u003e channel for an agent to respond.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHandles unsupported requests\u003c\/b\u003e: If unsupported, replies on WhatsApp requesting the customer to type their \u003cb\u003eorder number or question\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eResponds in bot mode using OpenAI\u003c\/b\u003e: Uses an OpenAI agent with chat memory to:\n    \u003cul\u003e\n      \u003cli\u003eFetch recent \u003cb\u003eShopify\u003c\/b\u003e orders by phone\u003c\/li\u003e\n      \u003cli\u003eOptionally look up an order by \u003cb\u003eorder number\u003c\/b\u003e with \u003cb\u003eownership verification\u003c\/b\u003e\n\u003c\/li\u003e\n      \u003cli\u003ePull live \u003cb\u003eShiprocket tracking\u003c\/b\u003e by \u003cb\u003eAWB\u003c\/b\u003e\n\u003c\/li\u003e\n      \u003cli\u003eReference a built-in \u003cb\u003ereturn policy tool\u003c\/b\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eApplies agent guardrails \u0026amp; logs everything\u003c\/b\u003e: Sends the reply on WhatsApp and logs message\/reply, intent, sentiment, and handoff status to \u003cb\u003eGoogle Sheets (“WISMO Log”)\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHuman handoff with resume\u003c\/b\u003e: Updates conversation state in Google Sheets, posts a Slack handoff card with context and a \u003cb\u003e“resume bot”\u003c\/b\u003e link, and validates a one-time token before switching back to bot mode.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCustomers ask on WhatsApp: “Where’s my order?” and receive instant status + tracking updates.\u003c\/li\u003e\n  \u003cli\u003eWhen an agent needs to intervene, the workflow forwards the request to Slack and lets the bot continue later via the resume link.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators manage bot vs human experience per phone number using Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eWhatsApp trigger\u003c\/b\u003e for incoming messages; \u003cb\u003eWhatsApp replies\u003c\/b\u003e for bot responses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e integration using \u003cb\u003eWISMO Conversations\u003c\/b\u003e and \u003cb\u003eWISMO Log\u003c\/b\u003e tabs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSlack\u003c\/b\u003e handoff and agent workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI agent\u003c\/b\u003e with chat memory, Shopify order retrieval, and Shiprocket tracking by AWB.\u003c\/li\u003e\n  \u003cli\u003en8n nodes include \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003eslack\u003c\/b\u003e, \u003cb\u003eswitch\u003c\/b\u003e, and \u003cb\u003ewebhook\u003c\/b\u003e (along with WhatsApp handling).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46248855797939,"sku":"N8N-21269","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/a9jtwWrgQoXuLQQ7igk20_CiYyk5tb.png?v=1792486955","url":"https:\/\/buyflowscripts.com\/products\/shopify-whatsapp-order-status-bot-with-openai-shiprocket","provider":"N8N Commerce","version":"1.0","type":"link"}