Send gold-silver ratio opportunity alerts with GoldAPI and Gmail

Description

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
Starts manually and loads configuration values such as the GoldAPI.io key, currency, alert email, and ratio thresholds.
Requests the latest gold and silver prices from GoldAPI.io and extracts the numeric price values.
Combines both price results and calculates the gold-silver ratio.
Compares the ratio to the configured thresholds to decide whether to signal “buy silver”, “buy gold”, or “hold”.
Generates a timestamped alert message with an insight and interpretation for the selected signal.
Sends the full report (prices, ratio, signal, and explanation) to the configured recipient using Gmail.

Setup
Create a GoldAPI.io account, copy your API key, and paste it into the workflow configuration value used by the GoldAPI.io requests.
Connect a Gmail OAuth2 credential in n8n and ensure the workflow can send email from your Gmail account.
Set the recipient email address, currency code (for example, INR), and your buy-silver and buy-gold ratio thresholds in the workflow’s configuration step.
Replace the manual trigger with a Cron trigger if you want the workflow to run automatically on a schedule.

Additional info
How To Customize

Change thresholds in config node
Modify email content
Change currency
Adjust decision logic

Add-ons

Use Cron for automation
Store data in Google Sheets
Add Slack or Telegram alerts
Build dashboards

Use Cases

Investment alerts
Portfolio monitoring
Financial analysis
Trading signals
Learning automation

Troubleshooting Guide

| Issue | Possible Cause | Solution |
|------|--------------|---------|
| No price data returned | Invalid or missing API key | Add a valid GoldAPI key in config node |
| Email not sent | Gmail credentials not configured | Reconnect Gmail OAuth2 credentials |
| Ratio is 0 | Missing or incorrect price mapping | Verify Edit Fields nodes |
| Workflow stops | Incorrect node connection | Check workflow connections |
| Incorrect signals | Wrong threshold values | Update thresholds in config |

Need Help?

If you need help with setup, customization or extending this workflow, you can contact WeblineIndia to hire n8n workflow developers for professional support.