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

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.