Generate dividend income reports via Telegram with Google Gemini

Description

Quick overview This workflow listens for Telegram messages, validates the sender, parses an investment amount and risk strategy, builds a predefined dividend ETF/stock allocation, calculates estimated yield and income, and uses Google Gemini to format a concise portfolio report that it sends back in Telegram. How it works Triggers when a new Telegram message is received. Checks the Telegram chat ID against an allowlist to ensure only an approved user can run the workflow. Parses the message text into investment capital and a strategy (conservative, moderate, or aggressive) and sends a Telegram “typing” action while processing. Builds a strategy-based portfolio from predefined tickers and allocations, enriches each holding with preset dividend yield and risk values, and calculates invested amount plus monthly and annual income per holding. Aggregates the holdings into a single portfolio summary with total income and overall portfolio yield. Uses Google Gemini via an AI Agent prompt to generate a Telegram-ready report based strictly on the calculated portfolio data. Sends the formatted DividendIQ report back to the configured Telegram chat. Setup Create a Telegram bot with @BotFather, add your Telegram credentials in n8n, and set the workflow to use your bot. Update the allowed Telegram chat ID in the authentication check and in the Telegram nodes that send the typing indicator and the final message. Add Google Gemini (PaLM) API credentials for the chat model, or replace the model with OpenAI and update the AI Agent accordingly. If desired, edit the predefined tickers, allocations, yields, and risk labels in the code steps to match your preferred portfolio universe. Requirements n8n Cloud or Self-Hosted n8n Telegram Bot Token (for receiving portfolio requests and delivering results) Google Gemini API Key or OpenAI API Key (for AI-generated portfolio summaries) Customization Modify portfolio strategies (Conservative, Moderate, Aggressive) to match your investment philosophy. Add or replace dividend stocks, ETFs, REITs, and income-focused assets. Adjust portfolio allocations and weightings for different risk levels. Replace Telegram with Slack, Discord, WhatsApp, Email, or other notification channels. An n8n automation workflow template by Blukaze Automations.

Categories

Tags

Capabilities

• 4 nodes
• 1 views