Generate Indian stock investment ideas using Groq AI, Google Sheets and stock API

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.