Reprice gold chain stock daily and announce it on WhatsApp with Google Sheets, goldapi.io and Twilio
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 36 nodes and runs on a schedule (cron 0 8 * * 1-5) (plus 1 other trigger). Along the way it connects Google Sheets and Twilio.
How it runs
Trigger: On a schedule (cron 0 8 * * 1-5) (plus 1 other trigger).
- config (Code): runs custom JavaScript code
- stock sheet configured? (If): checks a condition and branches into true / false
- [cred] Sheets - read the stock (Google Sheets): uses Google Sheets
- use the demo stock (Code): runs custom JavaScript code
- collect the stock (Code): runs custom JavaScript code
- check the stock rows (Code): runs custom JavaScript code
- gold rate configured? (If): checks a condition and branches into true / false
- Gold rate - today's price (HTTP Request): calls an HTTP API
- use the demo gold rate (Code): runs custom JavaScript code
- read the gold rate (Code): runs custom JavaScript code
…plus 24 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Twilio
n8n-nodes-base.twilio - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow reprices a gold chain catalogue every weekday using a live goldapi.io rate (or demo data), updates prices in Google Sheets, and drafts a WhatsApp announcement for customers via Twilio that only sends after the owner approves. How…