{"product_id":"whatsapp-gold-chain-quotes-twilio-google-sheets-n8n","title":"WhatsApp Gold Chain Quotes (Twilio + Google Sheets) n8n","description":"\u003ch3\u003eInstant WhatsApp Gold Chain Quotes with Twilio + Google Sheets (n8n)\u003c\/h3\u003e\n\u003cp\u003eTurn inbound customer chats into real gold chain quote replies. This n8n workflow receives \u003cstrong\u003eTwilio WhatsApp\u003c\/strong\u003e messages, checks \u003cstrong\u003egold chain availability\u003c\/strong\u003e and \u003cstrong\u003elast-approved prices\u003c\/strong\u003e from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and automatically returns up to \u003cstrong\u003ethree in-stock matches\u003c\/strong\u003e—or escalates complex requests to the owner.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives WhatsApp messages\u003c\/strong\u003e via a Twilio webhook (or uses built-in demo messages when run manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your catalogue\u003c\/strong\u003e from the Google Sheets \u003cstrong\u003eStock\u003c\/strong\u003e tab. If no sheet is configured, it falls back to the workflow’s \u003cstrong\u003edemo stock\u003c\/strong\u003e data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses customer intent\u003c\/strong\u003e to extract style, karat, length, and quantity using keyword rules, with an optional \u003cstrong\u003eOpenAI-compatible\u003c\/strong\u003e model to refine the fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResponds intelligently\u003c\/strong\u003e by:\n    \u003cul\u003e\n      \u003cli\u003eConfirming opt-out requests\u003c\/li\u003e\n      \u003cli\u003eEscalating bulk orders, custom requests, complaints, or anything complex to the \u003cstrong\u003eowner\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eReturning up to \u003cstrong\u003ethree closest in-stock matches\u003c\/strong\u003e with quantities and list prices\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes output by mode\u003c\/strong\u003e (preview\/test\/live). If sending is disabled, it can output a preview instead of sending replies.\u003c\/li\u003e\n  \u003cli\u003eIf the customer opts out and live writing is enabled, it \u003cstrong\u003eupdates the Google Sheets Customers tab\u003c\/strong\u003e to mark the WhatsApp number as opted out.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomated \u003cstrong\u003eWhatsApp gold chain quotes\u003c\/strong\u003e for customers asking for karat, length, and quantity\u003c\/li\u003e\n  \u003cli\u003eFast responses using your curated \u003cstrong\u003eStock\u003c\/strong\u003e and \u003cstrong\u003elast-approved pricing\u003c\/strong\u003e without manual lookups\u003c\/li\u003e\n  \u003cli\u003eEscalation flow for \u003cstrong\u003ecustom orders\u003c\/strong\u003e, bulk quantities, or complaints\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, code, twilio, webhook, sticky note, http request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Twilio WhatsApp, Google Sheets (Stock + Customers tabs), optional OpenAI-compatible parsing\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e configure Twilio’s “A message comes in” webhook to POST to the workflow’s webhook URL and add Twilio credentials in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223923380403,"sku":"N8N-20939","price":68.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/G_Z25S5IZB8UHM9TbtMW1_wgwXVZ5H.png?v=1791968581","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-gold-chain-quotes-twilio-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}