Send Stock News Alerts to Telegram from Google RSS

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