n8n Gold Chain Repricing Workflow: Google Sheets + WhatsApp (Twilio)

Automatically Reprice Your Gold Chain Catalog Every Weekday — Then Send WhatsApp Only After Approval

Take the guesswork out of gold pricing. This n8n Gold Chain Repricing Workflow pulls a live 24k gold rate from goldapi.io, recalculates your gold chain prices in Google Sheets, and prepares a customer WhatsApp broadcast via Twilio—but it will only send after the owner approves.

What this workflow does

• Schedules or manual runs: Executes every weekday at 08:00 (or runs on demand) and loads pricing, sheet, and WhatsApp settings.
• Reads inventory from Google Sheets: Uses the “Stock” tab (or built-in demo stock) and holds back any items missing required data (e.g., weight, known karat purity, or a configured style).
• Fetches live gold rate: Retrieves today’s 24k gold price per gram from goldapi.io (or uses demo data).
• Calculates new prices: Applies purity-based pricing using your making charge, margin, and rounding rules.
• Validates rate plausibility: Stops the run if the gold rate moves beyond a configured maximum percentage compared to the last published rate.
• Prepares WhatsApp content: Generates a customer-facing WhatsApp catalogue plus a short “what changed” message (new in, back in stock, last few, sold out).
• Builds a recipient list: Reads Customers tab (or demo customers), filters opted-out/invalid/duplicate numbers, and applies a capped broadcast list.
• Owner approval gate: Sends the owner an approval message via Twilio with an approve link, then sends the broadcast to customers only if approved within the configured time window.

Use cases

• Daily/weekday gold chain price updates for a WhatsApp-based sales catalog
• Controlled messaging where the owner approves changes before customers are notified
• Inventory-aware promotions (last few, sold out, back in stock) driven by sheet data

Technical details

• Integrations/notes: Google Sheets, goldapi.io, Twilio
• n8n nodes used: if, code, wait, twilio, sticky note, http request

Includes live mode behavior that writes updated pricing and rate information back to your Google Sheets as part of the repricing run.