Send gold-silver ratio opportunity alerts with GoldAPI and Gmail
Ready for 3.0What this workflow does
This workflow has 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Global Config (Edit Fields (Set)): sets or maps fields
- Fetch Gold Price (HTTP Request): calls an HTTP API
- Fetch Silver Price (XAG) (HTTP Request): calls an HTTP API
- Format Gold Price (Edit Fields (Set)): sets 1 field: goldPrice
- Format Silver Price (Edit Fields (Set)): sets 1 field: silverPrice
- Merge: merges the data from its input branches
- Calculate Gold-Silver Ratio (Code): runs custom Python code
- Ratio > BuySilver Threshold? (If): checks a condition and branches into true / false
- Signal — BUY SILVER (Edit Fields (Set)): sets or maps fields
- Ratio < BuyGold Threshold? (If): checks a condition and branches into true / false
…plus 5 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 (7)
- HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
Quick overview This workflow fetches live gold (XAU) and silver (XAG) prices from GoldAPI.io, calculates the gold-silver ratio, evaluates it against buy/hold thresholds, and sends a formatted opportunity alert email via Gmail. How it works 1. Starts manually…