Track Expenses: Parse Telegram Transactions to Google Sheets

This n8n workflow template automatically monitors a Telegram bot or chat for incoming transaction notifications, parses key details such as amount, sender, date, and transaction ID using custom logic, and appends them in real-time to a Google Sheet. Designed for self-hosted n8n instances with community nodes, it eliminates manual data entry, reducing errors and saving hours of tedious work.

Ideal for individuals, freelancers, and small businesses receiving payment alerts via Telegram channels or groups. Benefits include centralized expense tracking, easy reporting with Sheets formulas/charts, and scalability for high-volume transactions. It solves the pain of copying scattered message data into spreadsheets.

Use cases: Personal finance logging from bank bots, freelance invoice tracking from client groups, or small business sales monitoring. Customize parsing for different message formats and integrate further with tools like email alerts or dashboards.

Setup is straightforward: Create a Telegram bot, prepare your Google Sheet, import the workflow, configure credentials/nodes, and install community nodes. Requires self-hosted n8n for full functionality.