Send a Daily Nifty 50 Market Brief Using Gemini AI and Gmail

Scheduled trigger → fetch prices & news → data processing → AI analysis → merge & validate → generate brief → email delivery

Who

Traders, analysts, or portfolio managers who need a daily snapshot of the Indian Nifty 50 market

You get

Receive an AI-generated market brief under 120 words via email every day at 9:30 AM

You need

n8n · google-gemini · gmail

Steps

1. Import workflow and configure credentials

   Import the workflow JSON into n8n. Configure Google Gemini API credentials. Enter the recipient email in the Gmail node's sendTo field. Adjust the Schedule Trigger time if needed (default 9:30).

2. Fetch stock prices and market news

   After trigger, two HTTP Request nodes run in parallel: 1) Fetch Nifty 50 Stock Prices: POST to https://memic-nse-quotes-api.hf.space/quotes with a JSON body listing 50 Nifty symbols; 2) Fetch Market News: GET https://api.tradient.org/v1/api/market/news for latest financial news.

3. Process stock data

   A Set node extracts the prices object; a Code node converts it to an array with Object.values; another Code node sorts by pchange and picks top 10 gainers and top 10 losers.

4. Analyze news sentiment with AI

   Feed news data into the Google Gemini node. The model extracts stock names, assigns sentiment (Bullish/Bearish/Mixed), and gives a reason up to 50 words per item. A following Code node parses the AI response into structured JSON.

   Execution prompt · Source text。Analyze News Sentiment (AI) node messages.content field

   Copy prompt

   =Analyze the following financial news.
   
   Return:
   Every news object with added keys
   News Title:
   Stock Name: 
   Sentiment: Bullish / Bearish / Mixed
   Reason: (max 50 words)
   
   News:
   {{ JSON.stringify($json) }}

5. Merge, validate, and structure data

   A Merge node combines stock insights with news analysis; an If node checks data is not empty; an Aggregate Dataset Code node flattens outputs into combinedData; a Structure Final Payload Set node prepares top_gainers, top_losers, and news fields.

6. Generate market brief

   The Google Gemini node generates the email body. A system prompt sets the role as professional stock market analyst; the user prompt requests Nifty trend, news highlights, top gainers and losers, capped at 120 words in crisp bullet style.

   Execution prompt · Source text。Generate Market Brief (AI) node messages[0] (role=model)

   Copy prompt

   You are a professional stock market analyst. 
   Write concise, insightful and human-friendly summaries.

   Execution prompt · Source text。Generate Market Brief (AI) node messages[1] (role=user)

   Copy prompt

   =You are a professional Indian stock market analyst.
   
   Write a clean email.
   
   Format:
   Daily Market Brief
   
   - Mention Nifty trend
   - Market News: {{ JSON.stringify($json.combinedData[1].news) }}
   - Mention top gainers
   - Mention top losers
   
   Keep:
   - Max 120 words
   - Crisp bullet style
   - No fluff
   
   Top Gainers:
   {{ JSON.stringify($json.top_gainers) }}
   
   Top Losers:
   {{ JSON.stringify($json.top_losers) }}

7. Send email

   The Gmail node sends a text email with subject "Daily Market Brief (AI Summary)" and body from the previous AI output. Ensure sendTo is filled and Gmail credentials are valid.

You are an n8n setup assistant helping a user replicate the Daily Nifty 50 Market Brief workflow. Guide them to: 1) confirm they have an n8n instance, Gemini API key, and Gmail OAuth credentials; 2) import the workflow JSON and verify node connections; 3) check HTTP node URLs, Gemini model ID, and Gmail recipient; 4) run a manual test before activating the schedule trigger.