Automated Stock News Alerts with Google RSS, Gemini & Telegram Notifications

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

🎯 Purpose

This workflow helps you automatically monitor stock related news, extract the main content, summarize it using a LLM (via OpenRouter), and send real time alerts to Telegram and store them in Google Sheets.

⚙️ How It Works

Trigger

• A Cron node triggers the workflow every 15 minutes (adjustable).
• RSS Feed node checks latest articles from Google Alerts RSS.
• The workflow filters duplicates using Google Sheets as a log.
• The article URL is sent to Jina AI Readability API to extract the main body text.
• The content is summarized using a model from OpenRouter (e.g., Gemini, Claude, GPT-4).
• You can customize the prompt to suit your tone and analysis needs.
• The result is appended to a Google Sheets file.
• Sends the title, summary, and reccomendation to Telegram chat.

🧾 Google Sheets Template
Create a Google Sheet using this template: Stock Alert

🧰 Requirements

• Telegram Bot + your Chat ID
• OpenRouter account and API key
• Jina AI account for content extraction
• Google Account with access to Google Sheets
• Google Alerts RSS feed

🛠 Setup Instructions

• Install required credentials:
  • Add OpenRouter API key to n8n credentials.
  • Add Telegram Bot Token and Chat ID.
  • Add Google Sheets credentials.
  • Add Jina AI credentials.
• Create or copy the Google Sheet using the link above.
• Go to Google Alerts, create alerts, and copy the RSS feed URL.
• Replace placeholder API keys and URLs.
• Adjust Telegram Chat ID.

🔐 Security Note

All sensitive credentials (e.g., API keys, personal chat IDs) have been removed from this template. Please replace them using the n8n credentials manager before activating the workflow.