Automated Stock News Monitoring and Alerts Workflow

This n8n workflow automates the process of monitoring stock-related news via Google Alerts RSS feeds, extracting and summarizing content, and sending real-time alerts. It starts with a scheduled trigger that activates every 15 minutes, fetches news articles, and filters out duplicates using Google Sheets. The workflow then extracts the main article content using Jina AI, and employs an LLM from OpenRouter to generate concise summaries and sentiment analysis. The summarized insights are stored in Google Sheets for record-keeping, and immediate alerts are sent through Telegram. Practical use cases include investors tracking stock news, financial analysts automating trend monitoring, or corporate teams keeping abreast of market developments without manual effort. Key nodes include schedule triggers, Google Sheets, RSS feed readers, URL content extractors, content summarization via Jina AI and OpenRouter, and message delivery on Telegram.