{"product_id":"telegram-expense-tracker-with-n8n-data-tables-monthly-reports","title":"Telegram Expense Tracker with n8n Data Tables \u0026 Monthly Reports","description":"\u003ch3\u003eTurn Telegram messages into instant expense logs—and get monthly spending reports from n8n\u003c\/h3\u003e\n\u003cp\u003eThis \u003cb\u003eTelegram Expense Tracker\u003c\/b\u003e workflow captures your expenses sent via Telegram, stores them in an \u003cb\u003en8n Data Table\u003c\/b\u003e, and replies with confirmations, category-based \u003cb\u003emonthly reports\u003c\/b\u003e, an \u003cb\u003eundo\u003c\/b\u003e option, and a built-in \u003cb\u003ehelp\u003c\/b\u003e menu—without any external databases or AI services.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eListens on Telegram:\u003c\/b\u003e Triggers whenever your Telegram bot receives a new message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUnderstands commands and expense messages:\u003c\/b\u003e Detects \u003ccode\u003e\/report\u003c\/code\u003e, \u003ccode\u003e\/undo\u003c\/code\u003e, and \u003ccode\u003e\/help\u003c\/code\u003e commands, or extracts expense details such as amount, category (from keywords or a \u003ccode\u003e#tag\u003c\/code\u003e), note, and month.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eStores expenses in n8n Data Table:\u003c\/b\u003e When an expense is found, the workflow saves a normalized row to the Data Table named \u003ccode\u003eexpenses\u003c\/code\u003e (including \u003ccode\u003echat_id\u003c\/code\u003e, \u003ccode\u003eamount\u003c\/code\u003e, \u003ccode\u003ecategory\u003c\/code\u003e, \u003ccode\u003enote\u003c\/code\u003e, \u003ccode\u003emonth\u003c\/code\u003e, and \u003ccode\u003espent_at\u003c\/code\u003e), then sends a formatted confirmation back in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates monthly reports:\u003c\/b\u003e When you send \u003ccode\u003e\/report\u003c\/code\u003e (optionally with \u003ccode\u003eYYYY-MM\u003c\/code\u003e), it fetches that month’s rows for your chat ID, aggregates totals by category, and returns a summary in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUndo the latest entry:\u003c\/b\u003e \u003ccode\u003e\/undo\u003c\/code\u003e deletes your most recent expense row from the \u003ccode\u003eexpenses\u003c\/code\u003e Data Table and notifies you in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGuides you interactively:\u003c\/b\u003e \u003ccode\u003e\/help\u003c\/code\u003e (or missing amount) sends usage examples and available commands.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack everyday expenses by messaging your amount, category, and note directly in Telegram.\u003c\/li\u003e\n  \u003cli\u003eGet a quick monthly spending breakdown by category for personal finance or SaaS operator budget tracking.\u003c\/li\u003e\n  \u003cli\u003eCorrect mistakes instantly with the \u003ccode\u003e\/undo\u003c\/code\u003e command—no spreadsheets required.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations \/ nodes:\u003c\/b\u003e Telegram Trigger, Telegram send-message, \u003cb\u003eData Table\u003c\/b\u003e, Code, Switch, Set, and Sticky Note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eData storage:\u003c\/b\u003e n8n Data Table named \u003ccode\u003eexpenses\u003c\/code\u003e with columns: \u003ccode\u003echat_id\u003c\/code\u003e, \u003ccode\u003eamount\u003c\/code\u003e, \u003ccode\u003ecategory\u003c\/code\u003e, \u003ccode\u003enote\u003c\/code\u003e, \u003ccode\u003emonth\u003c\/code\u003e, \u003ccode\u003espent_at\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDesign goal:\u003c\/b\u003e Runs fully within n8n using the Data Table—no external DBs or AI services.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146226225331,"sku":"N8N-20277","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fS7W5qf2OcGFizztSN6HR_MgT1abUm.png?v=1790845266","url":"https:\/\/buyflowscripts.com\/products\/telegram-expense-tracker-with-n8n-data-tables-monthly-reports","provider":"N8N Commerce","version":"1.0","type":"link"}