{"product_id":"n8n-gold-chain-repricing-workflow-google-sheets-twilio","title":"n8n Gold Chain Repricing Workflow: Google Sheets + Twilio","description":"\u003ch3\u003eReprice your gold chain stock every weekday—then send WhatsApp updates only after owner approval\u003c\/h3\u003e\n\u003cp\u003eThis n8n Gold Chain Repricing Workflow uses Google Sheets + goldapi.io (or a demo rate) to calculate updated gold prices for your stock list, generates a WhatsApp-ready catalogue and “what changed” announcement, and uses Twilio WhatsApp to request owner approval before broadcasting to customers.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule (or on demand):\u003c\/strong\u003e executes every weekday at \u003cstrong\u003e08:00\u003c\/strong\u003e (or manually), then loads business, pricing, sheet, and WhatsApp settings from a single configuration step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your stock list from Google Sheets:\u003c\/strong\u003e pulls chain rows from your sheet (or uses built-in demo stock). Items are held back if they’re missing weight, have an unknown style, or use unsupported karat.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches today’s 24k gold rate:\u003c\/strong\u003e pulls the daily gold price per gram from \u003cstrong\u003egoldapi.io\u003c\/strong\u003e (or uses a labeled demo rate).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrices chains safely and validates rate changes:\u003c\/strong\u003e reprices each chain and stops if the new rate appears implausible compared to the previous published rate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds customer-ready messages:\u003c\/strong\u003e creates a catalogue and a concise announcement that includes only relevant changes (new items, back in stock, last few, and sold out).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules WhatsApp broadcasting with approval:\u003c\/strong\u003e reads customer numbers from Google Sheets (or demo customers), filters invalid\/duplicate entries, enforces a broadcast cap, and prepares one message per recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTwilio WhatsApp approval gate:\u003c\/strong\u003e sends the draft announcement to the owner via Twilio with an approval link, then broadcasts the approved message to customers (or outputs a preview when sending is disabled).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptionally updates Google Sheets:\u003c\/strong\u003e when live mode is enabled, writes today’s pricing details back to your stock sheet (price, rate, quantity, etc.).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily gold chain repricing for jewelry stores with WhatsApp customer lists\u003c\/li\u003e\n  \u003cli\u003eControlled announcements that require owner approval before customer broadcasts\u003c\/li\u003e\n  \u003cli\u003eMaintaining an up-to-date stock catalogue in Google Sheets and messaging changes only\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 \u003cstrong\u003ehttp request\u003c\/strong\u003e (goldapi.io), \u003cstrong\u003eTwilio\u003c\/strong\u003e (WhatsApp), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, plus a \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow context\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223924002995,"sku":"N8N-20938","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9hI4DYs0jY1OnQfSlk5yz_y197b6No.png?v=1791968606","url":"https:\/\/buyflowscripts.com\/products\/n8n-gold-chain-repricing-workflow-google-sheets-twilio","provider":"N8N Commerce","version":"1.0","type":"link"}