Automated Expense Tracking from Emails & Telegram with Gemini AI & Google Sheets

This workflow automates expense tracking by monitoring Gmail for transaction emails from banks like HDFC, Indian Bank, Indian Overseas Bank, and UPI apps such as Google Pay and Paytm. It also integrates Telegram for notifications. Incoming emails are parsed to extract key details like date, amount, description, and parties involved. Gemini AI then intelligently categorizes transactions (e.g., groceries, utilities, entertainment) and structures the data.

Data is logged into a pre-formatted Google Sheets 'Expenses' tab with columns for timestamp, date, account, category, amount, and more. The workflow cross-references against a 'Budgets' tab to calculate variances and generate a yearly summary. If expenses exceed monthly budgets, real-time alerts are sent via Telegram, ensuring proactive budget control.

Ideal for individuals, families, or small teams managing personal finances. Benefits include eliminating manual entry errors, consolidating multi-source transactions, providing AI-powered insights, and saving hours weekly on tracking. Setup requires a self-hosted n8n with community nodes, Google Sheets template, and Gemini API key.