{"product_id":"n8n-gold-chain-repricing-workflow-google-sheets-whatsapp-twilio","title":"n8n Gold Chain Repricing Workflow: Google Sheets + WhatsApp (Twilio)","description":"\u003ch3\u003eAutomatically Reprice Your Gold Chain Catalog Every Weekday — Then Send WhatsApp Only After Approval\u003c\/h3\u003e\n\u003cp\u003eTake the guesswork out of gold pricing. This \u003cstrong\u003en8n Gold Chain Repricing Workflow\u003c\/strong\u003e pulls a live 24k gold rate from \u003cstrong\u003egoldapi.io\u003c\/strong\u003e, recalculates your gold chain prices in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and prepares a customer WhatsApp broadcast via \u003cstrong\u003eTwilio\u003c\/strong\u003e—but it will \u003cstrong\u003eonly send after the owner approves\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules or manual runs:\u003c\/strong\u003e Executes every weekday at \u003cstrong\u003e08:00\u003c\/strong\u003e (or runs on demand) and loads pricing, sheet, and WhatsApp settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads inventory from Google Sheets:\u003c\/strong\u003e Uses the \u003cstrong\u003e“Stock”\u003c\/strong\u003e tab (or built-in demo stock) and holds back any items missing required data (e.g., weight, known karat purity, or a configured style).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches live gold rate:\u003c\/strong\u003e Retrieves today’s \u003cstrong\u003e24k gold price per gram\u003c\/strong\u003e from \u003cstrong\u003egoldapi.io\u003c\/strong\u003e (or uses demo data).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates new prices:\u003c\/strong\u003e Applies purity-based pricing using your making charge, margin, and rounding rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates rate plausibility:\u003c\/strong\u003e Stops the run if the gold rate moves beyond a configured maximum percentage compared to the last published rate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares WhatsApp content:\u003c\/strong\u003e Generates a customer-facing WhatsApp catalogue plus a short “what changed” message (new in, back in stock, last few, sold out).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a recipient list:\u003c\/strong\u003e Reads \u003cstrong\u003eCustomers\u003c\/strong\u003e tab (or demo customers), filters opted-out\/invalid\/duplicate numbers, and applies a capped broadcast list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOwner approval gate:\u003c\/strong\u003e Sends the owner an approval message via \u003cstrong\u003eTwilio\u003c\/strong\u003e with an approve link, then sends the broadcast to customers only if approved within the configured time window.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily\/weekday gold chain price updates for a WhatsApp-based sales catalog\u003c\/li\u003e\n  \u003cli\u003eControlled messaging where the owner approves changes before customers are notified\u003c\/li\u003e\n  \u003cli\u003eInventory-aware promotions (last few, sold out, back in stock) driven by sheet data\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/notes:\u003c\/strong\u003e Google Sheets, \u003cstrong\u003egoldapi.io\u003c\/strong\u003e, \u003cstrong\u003eTwilio\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003etwilio\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eIncludes live mode behavior\u003c\/strong\u003e that writes updated pricing and rate information back to your Google Sheets as part of the repricing run.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114646491315,"sku":"N8N-20020","price":17.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Cq8TTzgu61Ipdwwf_tuZS_WiAGfZW7.png?v=1790586522","url":"https:\/\/buyflowscripts.com\/products\/n8n-gold-chain-repricing-workflow-google-sheets-whatsapp-twilio","provider":"N8N Commerce","version":"1.0","type":"link"}