Automatic expense tracking with Telegram, AI, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (9)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Http Request Tool
n8n-nodes-base.httpRequestTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Code
n8n-nodes-base.code
What it does
The Problem π« Tired of manually logging every coffee and cab ride? Stop wrestling with spreadsheets! This template automates your expense tracking so you can manage your finances effortlessly. It's perfect for freelancers, small business owners, and anyone who wants a simple, chat-based way to track spending. --- !Screen Shot 20250724 at 16.23.52 PM.png(fileId:1855) --- How It Works β¨ Just send a message to your personal Telegram bot like "5 usd for coffee with my card" and this workflow will automatically: π² Get your message from Telegram. π€ Use AI to understand the amount, category, currency, and payment method. π± Convert currencies automatically using live exchange rates. βοΈ Log everything neatly into a new row in your Google Sheet. π οΈ Quick Setup Guide 1. Google Sheets π Create a new Google Sheet. Make sure your first row has these exact column names: date, amount, category, description, userid, paymentmethod, currency, exchangerate, amountconverted Copy the Sheet ID from the browser's URL bar. 2. Telegram Bot π€ Chat with @BotFather on Telegram, use the /newbot command, and get your API Token. Chat with @userinfobot to get your personal Chat ID. 3. n8n Workflow π Add your credentials for Google Sheets, Telegram, and your AI model. Paste your Chat ID into the Telegram Trigger node. Paste your Sheet ID into the Append row in sheet node. Activate the workflow and start tracking! β