{"product_id":"n8n-whatsapp-gold-chain-price-bot-with-twilio-google-sheets","title":"n8n WhatsApp Gold Chain Price Bot with Twilio + Google Sheets","description":"\u003ch3\u003eInstant WhatsApp gold chain pricing—automated with Twilio + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eTurn inbound WhatsApp messages into accurate gold chain price replies. This n8n workflow connects \u003cstrong\u003eTwilio WhatsApp\u003c\/strong\u003e with a \u003cstrong\u003eGoogle Sheets price list\u003c\/strong\u003e to look up the last approved prices and available quantities, then responds to your customers automatically.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives WhatsApp messages via Twilio\u003c\/strong\u003e using a webhook (or lets you test with a built-in demo message through a manual trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your stock\/pricing from Google Sheets\u003c\/strong\u003e (from a configured sheet). If no sheet is configured, it can fall back to built-in demo stock.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts customer requirements\u003c\/strong\u003e such as style, karat, length, and quantity using keyword rules, with an optional \u003cstrong\u003eOpenAI-compatible\u003c\/strong\u003e chat endpoint to refine extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComposes the customer reply\u003c\/strong\u003e using the matching stock row’s last published price and list date, or asks clarifying questions when details are too vague.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes certain enquiries to the owner\u003c\/strong\u003e (bulk\/order\/custom\/complaint\/payment-related) by sending an alert message while acknowledging the customer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends WhatsApp replies via Twilio\u003c\/strong\u003e (or outputs a preview when sending is disabled).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles opt-outs\u003c\/strong\u003e: if the customer sends “STOP” (or similar), the workflow updates the \u003cstrong\u003eCustomers\u003c\/strong\u003e tab in Google Sheets to mark the WhatsApp number as opted out (live mode only).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA jewelry shop responding to customers asking, “What’s the price for a 22K 18-inch gold chain?”\u003c\/li\u003e\n  \u003cli\u003eSales teams handling high WhatsApp volume while still alerting the owner for bulk orders and custom requests.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators demonstrating a real-world n8n automation: \u003cem\u003eWhatsApp → extraction → Google Sheets lookup → reply\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes\u003c\/strong\u003e: \u003ccode\u003ewebhook\u003c\/code\u003e, \u003ccode\u003etwilio\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e, \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, and supporting notes for setup.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source\u003c\/strong\u003e: Google Sheets with \u003cstrong\u003eStock\u003c\/strong\u003e and \u003cstrong\u003eCustomers\u003c\/strong\u003e tabs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional AI\u003c\/strong\u003e: OpenAI-compatible endpoint for structured extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRouting logic\u003c\/strong\u003e: owner alerts for bulk\/order\/custom\/complaint\/payment-related messages.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114643378355,"sku":"N8N-20021","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Cwemro_ISUBYO-KQH2Krw_mYgk7RiA.png?v=1790586499","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-gold-chain-price-bot-with-twilio-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}