# AI-Powered news (stock, economy...) collector with Gemini: n8n workflow

> Started by a clock, and works across Gmail, RSS and n8n data table. It hands the judgement calls to Gemini and OpenAI.

Source: https://millionrounds.com/workflow/ai-powered-news-stock-economy-collector-with-gemini (Millionrounds; every figure on the page links to its filing or article)

[Automation library](https://millionrounds.com/workflows) · [Data collection](https://millionrounds.com/workflows?category=Data+collection#library)

# AI-Powered news (stock, economy...) collector with Gemini

Started by a clock, and works across Gmail, RSS and n8n data table. It hands the judgement calls to Gemini and OpenAI. 41 steps: large, and worth reading before you trust it with anything live.

Large Calls a model: Gemini, OpenAI

[Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fai-powered-news-stock-economy-collector-with-gemini)

**41 steps** Large: read it before trusting it with anything live

**0** Branches: places the flow splits

**0** Loops or waits

**3** Services it connects to

## The flow

Starts it 3 Model 8 Logic 22 Service 8

The steps in the order they run, from what starts it.

- 1 **Daily RSS Trigger (7.55AM)2** Schedule trigger *Starts it*
- 2 **Daily RSS Trigger (7:30AM)** Schedule trigger *Starts it*
- 3 **OpenAI GPT 4.1 nano** Lm Chat Open Ai *Model*
- 4 **Google Gemini Flash1** Lm Chat Google Gemini *Model*
- 5 **Google Gemini Flash2** Lm Chat Google Gemini *Model*
- 6 **RSS Trigger (7h, 18h)** Schedule trigger *Starts it*
- 7 **Create data table** Data Table *Service*
- 8 **Clean data Table (older than 3 days)** Data Table *Service*
- 9 **Get news from data table** Data Table *Service*
- 10 **Configure RSS Sources Group 1** Set *Logic*
- 11 **Configure RSS Group 2** Set *Logic*
- 12 **AI: Classify Finance/Insurance1** Text Classifier *Model*
- 13 **AI: Summarize Top 15 Articles** Agent *Model*
- 14 **JSON Parser: Summary1** Output Parser Structured *Model*
- 15 **AI: Summarize Top 15 Articles2** Agent *Model*
- 16 **JSON Parser: Summary2** Output Parser Structured *Model*
- 17 **Set keywords** Set *Logic*
- 18 **Get title+link** Set *Logic*
- 19 **Split RSS URLs1** Split Out *Logic*
- 20 **Split RSS URLs2** Split Out *Logic*
- 21 **Aggregate All Articles1** Aggregate *Logic*
- 22 **Aggregate All Articles2** Aggregate *Logic*
- 23 **Split Analysis Results1** Split Out *Logic*
- 24 **Split Analysis Results2** Split Out *Logic*
- 25 **Split Keywords** Split Out *Logic*
- 26 **Fetch RSS Content1** Rss Feed Read *Service*
- 27 **Fetch RSS Content2** Rss Feed Read *Service*
- 28 **Transform for Table1** Code *Logic*
- 29 **Transform for Table2** Code *Logic*
- 30 **Google Search News** Serp Api *Service*
- 31 **Normalize Article Data1** Set *Logic*
- 32 **Normalize Article Data2** Set *Logic*
- 33 **Build HTML Table** Code *Logic*
- 34 **Build HTML Table2** Code *Logic*
- 35 **Split News Results** Split Out *Logic*
- 36 **Insert to News Collection** Data Table *Service*
- 37 **Merge1** Merge *Logic*
- 38 **Create isoDate for News** Code *Logic*
- 39 **Build Email HTML** Code *Logic*
- 40 **Normalize Article Data3** Set *Logic*
- 41 **Send Report Email** Gmail *Service*

## How it's built

- **Starts on:** A clock
- **Steps:** 41
- **Size:** Large: read it before trusting it with anything live
- **Connects to:** Gmail, RSS, n8n data table
- **Model:** Gemini, OpenAI

## Questions

What does it need to run?

An n8n account, plus your own Gmail and RSS accounts, and a key for Gemini and OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls Gemini and OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 41 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

**Before you run it**

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 41 steps before you point it at anything that matters.

## Run it in n8n

- **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n)
- **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fai-powered-news-stock-economy-collector-with-gemini)
- **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts.

Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind.

## Connects to

Each opens the other workflows that use it.

[Gmail](https://millionrounds.com/workflows?service=Gmail#library)[RSS](https://millionrounds.com/workflows?service=RSS#library)[n8n data table](https://millionrounds.com/workflows?service=n8n+data+table#library)

## Workflows like it

Also data collection, with the same services where possible, closest in size first.

- [**Interactive knowledge base chat with Supabase RAG** 43 steps · calls a model · Gmail, Google Drive](https://millionrounds.com/workflow/interactive-knowledge-base-chat-with-supabase-rag)
- [**Score job listings and generate tailored cover letters** 39 steps · calls a model · Apify, Gmail](https://millionrounds.com/workflow/score-job-listings-and-generate-tailored-cover-letters)
- [**AI-Powered WhatsApp Device Inventory System with Excel** 39 steps · Excel, n8n data table](https://millionrounds.com/workflow/ai-powered-whatsapp-device-inventory-system-with-excel)
- [**An email assistant to manage your Gmail inbox with Gemini** 37 steps · calls a model · Email, Gmail](https://millionrounds.com/workflow/an-email-assistant-to-manage-your-gmail-inbox-with-gemini)
- [**Find and score event and speaker opportunities with Gumloop** 35 steps · Gmail, Postgres](https://millionrounds.com/workflow/find-and-score-event-and-speaker-opportunities-with-gumloop)
- [**Build a Google Drive internal knowledge base with OpenAI** 34 steps · calls a model · Gmail, Google Drive](https://millionrounds.com/workflow/build-a-google-drive-internal-knowledge-base-with-openai)