Compare gold and equity performance with Google Sheets, Groq, QuickChart and Gmail
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 AI workflow has 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Gmail and Groq Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Analysis Parameters (Edit Fields (Set)): sets 3 fields: startDate, endDate, threshold
- Fetch Gold Prices (Google Sheets): uses Google Sheets
- Fetch Equity Prices (Google Sheets): uses Google Sheets
- Merge Market Data (Code): runs custom JavaScript code
- Calculate Performance Metrics (Code): runs custom JavaScript code
- Generate Chart (Code): runs custom JavaScript code
- Generate AI Investment Insights (AI Agent): runs an AI agent, with model: Insights
- Combine AI + Chart Data (Merge): merges the data from its input branches
- Parse AI Output (Code): runs custom JavaScript code
- Generate Final Report (Code): runs custom JavaScript code
…plus 4 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 (9)
- Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Merge
n8n-nodes-base.merge - Gmail
n8n-nodes-base.gmail - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq
From the author
Gold vs Equity Performance Comparison Tracker with Visual Insights This automated n8n workflow evaluates the historical performance of gold against equity markets. It extracts daily price data from Google Sheets, calculates comparative returns and uses an AI…