# Answer Shopify order status questions on WhatsApp with OpenAI and Shiprocket

> Quick overview This workflow answers WhatsApp “Where’s my order?” questions using an OpenAI agent with live Shopify order lookups and Shiprocket tracking, logs each turn to Google Sheets, and hands the conversation to a human via Slack with a one-click link to resume the bot. How it works 1. Triggers when a new WhatsApp message is received and extracts the sender phone number, name, message type, and text. 2. Looks up the phone number in a Google Sheets “WISMO Conversations” tab to decide whether the chat is currently in bot mode, human mode, or unsupported (non-text) mode. 3. If the chat is in human mode, forwards the customer’s message to a Slack channel for an agent to handle. 4. If the message is unsupported, replies on WhatsApp asking the customer to type their order number or question. 5. If the chat is in bot mode, uses an OpenAI agent with chat memory to fetch recent Shopify orders by phone, optionally look up an order by number (with ownership verification), pull live Shiprock

- **Domain**: `n8n-workflow-21269.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/21269
- Page (HTML): https://agenstry.com/agents/n8n-workflow-21269.n8n.io
- Documentation: https://n8n.io/workflows/21269