📈 Generate Indian stock investment ideas using Groq AI, Google Sheets and stock API
⚡ 153 views · 📈 Crypto Trading & Stock Market
Description
AI Investment Idea Generator using n8n, Groq AI, Google Sheets & Stock API
This workflow automatically generates 2–3 high-quality Indian stock investment ideas daily by combining trending stock data + latest market news, processing it with AI (Groq/OpenAI), avoiding duplicates using Google Sheets and storing results for tracking.
Quick Implementation Steps
- Import the workflow into n8n
- Add credentials:
- Stock API (HTTP Headers Auth)
- Google Sheets OAuth2
- Groq / OpenAI API
- Connect your Google Sheet (same structure as defined)
- Activate the workflow (runs daily at 9 AM)
- Check your Google Sheet for generated ideas
What It Does
This workflow acts as a mini AI-powered equity research assistant for the Indian stock market. It automatically gathers real-time market insights by pulling:
- Trending stocks (top gainers & losers)
- Latest market-related news (via Google News RSS)
It then processes this data into a structured format and feeds it into an AI agent configured with strict rules to generate actionable, non-generic investment ideas.
To maintain quality and avoid repetition, the workflow:
- Fetches historical ideas from Google Sheets
- Uses memory to avoid recent duplicates
- Ensures each new idea is unique, data-backed and sector-driven
Finally, it stores structured results into Google Sheets for easy tracking and analysis.
Who’s It For
- Retail investors looking for daily stock ideas
- Financial analysts and research teams
- Algo trading enthusiasts
- Content creators (finance blogs, newsletters)
- Automation enthusiasts using n8n
Requirements
To use this workflow, you need:
- n8n instance (self-hosted or cloud)
- Stock API access (via HTTP headers auth)
- Google Sheets account (read + append permissions)
- Groq or OpenAI API access
- A Google Sheet with columns: Date | Title | Stock | Reason | Horizon
How It Works & Set Up
- Schedule Trigger (runs daily at 9 AM)
- Fetch trending stocks via API
- Fetch latest market news via RSS
- Merge and format data
- Generate investment ideas using AI
- Validate and parse output
- Store results in Google Sheets
- Handle errors and send alerts
How To Customize Nodes
- Modify API endpoint in stock node
- Change RSS keywords for news
- Adjust AI prompt rules
- Change number of generated ideas
- Modify Google Sheets mapping
- Update schedule timing
Add-ons (Enhancements)
- Slack/Telegram alerts
- Email digest
- Sentiment analysis
- Performance tracking
- Global market support
Use Case Examples
- Daily investment newsletter
- Personal research assistant
- Trading strategy ideas
- Content creation
- Portfolio tracking
Troubleshooting Guide
| Issue | Possible Cause | Solution |
|---|---|---|
| No stock data | API issue | Check API credentials |
| AI empty output | Model issue | Retry / check logs |
| JSON error | Format issue | Fix prompt output |
| No sheet data | Mapping issue | Verify columns |
| No alerts | Gmail not set | Reconnect Gmail |
Need Help?
For setup, customization or advanced automation solutions, contact our n8n workflow developers at WeblineIndia.
🔗 Nodes Used
Google Sheets, HTTP Request, RSS Read, Gmail, Schedule Trigger, AI Agent
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File