n8n WhatsApp Gold Chain Price Bot with Twilio + Google Sheets

Instant WhatsApp gold chain pricing—automated with Twilio + Google Sheets

Turn inbound WhatsApp messages into accurate gold chain price replies. This n8n workflow connects Twilio WhatsApp with a Google Sheets price list to look up the last approved prices and available quantities, then responds to your customers automatically.

What this workflow does

• Receives WhatsApp messages via Twilio using a webhook (or lets you test with a built-in demo message through a manual trigger).
• Loads your stock/pricing from Google Sheets (from a configured sheet). If no sheet is configured, it can fall back to built-in demo stock.
• Extracts customer requirements such as style, karat, length, and quantity using keyword rules, with an optional OpenAI-compatible chat endpoint to refine extraction.
• Composes the customer reply using the matching stock row’s last published price and list date, or asks clarifying questions when details are too vague.
• Routes certain enquiries to the owner (bulk/order/custom/complaint/payment-related) by sending an alert message while acknowledging the customer.
• Sends WhatsApp replies via Twilio (or outputs a preview when sending is disabled).
• Handles opt-outs: if the customer sends “STOP” (or similar), the workflow updates the Customers tab in Google Sheets to mark the WhatsApp number as opted out (live mode only).

Use cases

• A jewelry shop responding to customers asking, “What’s the price for a 22K 18-inch gold chain?”
• Sales teams handling high WhatsApp volume while still alerting the owner for bulk orders and custom requests.
• SaaS operators demonstrating a real-world n8n automation: WhatsApp → extraction → Google Sheets lookup → reply.

Technical details

• Integrations / nodes: webhook, twilio, http request, if, code, and supporting notes for setup.
• Data source: Google Sheets with Stock and Customers tabs.
• Optional AI: OpenAI-compatible endpoint for structured extraction.
• Routing logic: owner alerts for bulk/order/custom/complaint/payment-related messages.