# Answer WhatsApp gold chain enquiries with Google Sheets, Twilio, and OpenAI

> Quick overview This workflow receives incoming WhatsApp messages via Twilio, looks up matching gold chain items in a Google Sheets price list, and replies with the last approved prices and available quantities; it can optionally use an OpenAI-compatible model to extract the requested style/karat/length/quantity and records opt-outs back to sheet. How it works 1. Receives an incoming WhatsApp message from Twilio via a webhook (or runs a built-in demo message set with the manual trigger). 2. Loads the stock list from Google Sheets (or falls back to built-in demo stock if no sheet is configured). 3. Extracts what the customer wants (style, karat, length, quantity, and opt-out/handoff intent) using keyword rules, optionally refining the extraction with an OpenAI-compatible chat endpoint. 4. Builds a customer reply from the stock list using the last published price and list date, or asks clarifying questions when the message is too vague. 5. Routes bulk/order/custom/complaint/payment-relate

- **Domain**: `n8n-workflow-20021.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/20021
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20021.n8n.io
- Documentation: https://n8n.io/workflows/20021