Shopify WhatsApp Order Status Bot with OpenAI & Shiprocket

Handle “Where’s my order?” on WhatsApp automatically—powered by OpenAI, live Shopify lookups, and Shiprocket tracking

This 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.

What this workflow does

• Receives WhatsApp messages: Triggers on each new WhatsApp message and extracts sender phone number, name, message type, and text.
• Detects chat mode from Google Sheets: Looks up the phone number in the Google Sheets tab “WISMO Conversations” to decide whether the user is in bot mode, human mode, or unsupported (non-text) mode.
• Routes to Slack for human help: If in human mode, forwards the customer’s message to a Slack channel for an agent to respond.
• Handles unsupported requests: If unsupported, replies on WhatsApp requesting the customer to type their order number or question.
• Responds in bot mode using OpenAI: Uses an OpenAI agent with chat memory to:
  • Fetch recent Shopify orders by phone
  • Optionally look up an order by order number with ownership verification
  • Pull live Shiprocket tracking by AWB
  • Reference a built-in return policy tool
• Applies agent guardrails & logs everything: Sends the reply on WhatsApp and logs message/reply, intent, sentiment, and handoff status to Google Sheets (“WISMO Log”).
• Human handoff with resume: Updates conversation state in Google Sheets, posts a Slack handoff card with context and a “resume bot” link, and validates a one-time token before switching back to bot mode.

Use cases

• Customers ask on WhatsApp: “Where’s my order?” and receive instant status + tracking updates.
• When an agent needs to intervene, the workflow forwards the request to Slack and lets the bot continue later via the resume link.
• SaaS operators manage bot vs human experience per phone number using Google Sheets.

Technical details

• WhatsApp trigger for incoming messages; WhatsApp replies for bot responses.
• Google Sheets integration using WISMO Conversations and WISMO Log tabs.
• Slack handoff and agent workflow.
• OpenAI agent with chat memory, Shopify order retrieval, and Shiprocket tracking by AWB.
• n8n nodes include if, code, slack, switch, and webhook (along with WhatsApp handling).