Analyze commodity portfolio diversification with Sheets, Gemini, and Gmail

by WeblineIndia ✓ · 15 views · created 2026-06-15 · Crypto Trading, AI Summarization

What this workflow does

This AI workflow has 24 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini, Gmail and Google Sheets. It also calls goldapi.io over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Initialize Configuration & API Keys (Edit Fields (Set)): sets 3 fields: goldapi_key, eia_api_key, twelvedata_key
2. Load Portfolio Data from Sheets (Google Sheets): uses Google Sheets
3. Get Gold Price (INR) (HTTP Request): calls goldapi.io
4. Get Silver Price (INR) (HTTP Request): calls goldapi.io
5. Get Crude Oil Price (USD) (HTTP Request): calls an HTTP API
6. Get Gold Trend Time Series (HTTP Request): calls an HTTP API
7. Merge: merges the data from its input branches
8. Extract Gold Price Value (Edit Fields (Set)): sets 1 field: gold price
9. Extract Silver Price Value (Edit Fields (Set)): sets 1 field: silver price
10. Convert Oil Price USD to INR (Edit Fields (Set)): sets 2 fields: oil_price_usd, oil_price_inr

…plus 13 more steps. See the full node list below.

Services it uses

Google GeminiGmailGoogle Sheets

HTTP calls to: goldapi.io

Before you upgrade to n8n 3.0

Nodes used (9)

• Edit Fields (Set)n8n-nodes-base.set
• Mergen8n-nodes-base.merge
• Ifn8n-nodes-base.if
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Coden8n-nodes-base.code
• Gmailn8n-nodes-base.gmail
• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick Overview This workflow reads a gold/silver/oil portfolio from Google Sheets, pulls current commodity prices and a recent gold trend from GoldAPI, EIA, and Twelve Data, calculates allocation and HHI concentration risk, generates a Gemini analysis, and…

View the original on n8n.io → Check your own copy