Automated Stock News Alerts via Google RSS, Openrouter & Telegram

## 🎯 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](https://docs.google.com/spreadsheets/d/109kj97ABR37XviIpxARCFviZwq8opOoe--rayOeFDSo/edit?usp=sharing)

## 🧰 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.