Telegram Expense Tracker with n8n Data Tables & Monthly Reports

Turn Telegram messages into instant expense logs—and get monthly spending reports from n8n

This Telegram Expense Tracker workflow captures your expenses sent via Telegram, stores them in an n8n Data Table, and replies with confirmations, category-based monthly reports, an undo option, and a built-in help menu—without any external databases or AI services.

What this workflow does

• Listens on Telegram: Triggers whenever your Telegram bot receives a new message.
• Understands commands and expense messages: Detects /report, /undo, and /help commands, or extracts expense details such as amount, category (from keywords or a #tag), note, and month.
• Stores expenses in n8n Data Table: When an expense is found, the workflow saves a normalized row to the Data Table named expenses (including chat_id, amount, category, note, month, and spent_at), then sends a formatted confirmation back in Telegram.
• Generates monthly reports: When you send /report (optionally with YYYY-MM), it fetches that month’s rows for your chat ID, aggregates totals by category, and returns a summary in Telegram.
• Undo the latest entry: /undo deletes your most recent expense row from the expenses Data Table and notifies you in Telegram.
• Guides you interactively: /help (or missing amount) sends usage examples and available commands.

Use cases

• Track everyday expenses by messaging your amount, category, and note directly in Telegram.
• Get a quick monthly spending breakdown by category for personal finance or SaaS operator budget tracking.
• Correct mistakes instantly with the /undo command—no spreadsheets required.

Technical details

• Integrations / nodes: Telegram Trigger, Telegram send-message, Data Table, Code, Switch, Set, and Sticky Note.
• Data storage: n8n Data Table named expenses with columns: chat_id, amount, category, note, month, spent_at.
• Design goal: Runs fully within n8n using the Data Table—no external DBs or AI services.