Automation library · Data collection

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.

LargeCalls a model: Gemini, OpenAI

Download free
41 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 3Model 8Logic 22Service 8

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

  1. 1Daily RSS Trigger (7.55AM)2Schedule triggerStarts it
  2. 2Daily RSS Trigger (7:30AM)Schedule triggerStarts it
  3. 3OpenAI GPT 4.1 nanoLm Chat Open AiModel
  4. 4Google Gemini Flash1Lm Chat Google GeminiModel
  5. 5Google Gemini Flash2Lm Chat Google GeminiModel
  6. 6RSS Trigger (7h, 18h)Schedule triggerStarts it
  7. 7Create data tableData TableService
  8. 8Clean data Table (older than 3 days)Data TableService
  9. 9Get news from data tableData TableService
  10. 10Configure RSS Sources Group 1SetLogic
  11. 11Configure RSS Group 2SetLogic
  12. 12AI: Classify Finance/Insurance1Text ClassifierModel
  13. 13AI: Summarize Top 15 ArticlesAgentModel
  14. 14JSON Parser: Summary1Output Parser StructuredModel
  15. 15AI: Summarize Top 15 Articles2AgentModel
  16. 16JSON Parser: Summary2Output Parser StructuredModel
  17. 17Set keywordsSetLogic
  18. 18Get title+linkSetLogic
  19. 19Split RSS URLs1Split OutLogic
  20. 20Split RSS URLs2Split OutLogic
  21. 21Aggregate All Articles1AggregateLogic
  22. 22Aggregate All Articles2AggregateLogic
  23. 23Split Analysis Results1Split OutLogic
  24. 24Split Analysis Results2Split OutLogic
  25. 25Split KeywordsSplit OutLogic
  26. 26Fetch RSS Content1Rss Feed ReadService
  27. 27Fetch RSS Content2Rss Feed ReadService
  28. 28Transform for Table1CodeLogic
  29. 29Transform for Table2CodeLogic
  30. 30Google Search NewsSerp ApiService
  31. 31Normalize Article Data1SetLogic
  32. 32Normalize Article Data2SetLogic
  33. 33Build HTML TableCodeLogic
  34. 34Build HTML Table2CodeLogic
  35. 35Split News ResultsSplit OutLogic
  36. 36Insert to News CollectionData TableService
  37. 37Merge1MergeLogic
  38. 38Create isoDate for NewsCodeLogic
  39. 39Build Email HTMLCodeLogic
  40. 40Normalize Article Data3SetLogic
  41. 41Send Report EmailGmailService

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.