Analyze your stock portfolio daily using Google Sheets, RSS, Groq LLM and Gmail

by WeblineIndia ✓ · 127 views · created 2026-05-12 · Crypto Trading, AI Summarization

What this workflow does

This AI workflow has 19 nodes and runs on a schedule (every day at 16:00). Along the way it connects Google Sheets, Groq Chat Model and Gmail.

How it runs

Trigger: On a schedule (every day at 16:00).

1. Fetch Portfolio (Google Sheets) (Google Sheets): uses Google Sheets
2. Calculate Portfolio Metrics (Edit Fields (Set)): sets 8 fields: symbol, quantity, avg_price…
3. Iterate Stocks (Loop Over Items (Split in Batches)): loops over the items in batches
4. Aggregate: combines items into one
5. Fetch Stock News (RSS) (RSS Read): reads an RSS feed
6. Parse Stock AI Output (Code): runs custom JavaScript code
7. Sort: sorts the items
8. Generate Portfolio Insight (AI Agent): runs an AI agent, with model: LLM (Portfolio Analysis)
9. Merge: merges the data from its input branches
10. Limit: keeps the first few items

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

Services it uses

Google SheetsGroq Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (14)

• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• RSS Readn8n-nodes-base.rssFeedRead
• Sortn8n-nodes-base.sort
• Limitn8n-nodes-base.limit
• Coden8n-nodes-base.code
• AI Agent@n8n/n8n-nodes-langchain.agent
• Groq Chat Model@n8n/n8n-nodes-langchain.lmChatGroq
• Waitn8n-nodes-base.wait
• Aggregaten8n-nodes-base.aggregate
• Mergen8n-nodes-base.merge
• Gmailn8n-nodes-base.gmail
• Edit Fields (Set)n8n-nodes-base.set
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

AI Portfolio Analysis & Reporting using Google Sheets, RSS, Groq LLM & Gmail This n8n workflow automatically analyzes your stock portfolio every day at 4 PM. It fetches portfolio data from Google Sheets, enriches it with latest market news via RSS, generates…

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