Automate Your Expenses With Telegram and Google Sheets
detail.loadingPreview
Effortlessly track your daily expenses by forwarding transaction messages from Telegram directly to a Google Sheet. This workflow automatically parses various transaction formats, ensuring your financial data is organized and accessible.
About This Workflow
The 'Transactions' n8n workflow is designed to streamline your personal finance management. It begins by listening for messages on Telegram. Upon receiving a message, an 'If' node checks if it contains specific transaction keywords. If a match is found, a custom JavaScript code node analyzes the message text, extracting key details such as the amount, merchant, card information, date, and available limit. This extracted data is then seamlessly appended to a dedicated Google Sheet, creating a real-time, automated expense log. This eliminates manual data entry and provides a clear overview of your spending habits.
Key Features
- Real-time Expense Logging: Automatically record transactions as they happen.
- Intelligent Data Parsing: Supports multiple common transaction message formats.
- Seamless Telegram Integration: Forward messages directly from your preferred chat app.
- Google Sheets Synchronization: Centralize your financial data in a familiar spreadsheet.
- Customizable Workflow: Easily adapt the code node for different message formats or additional data points.
How To Use
- Set up Telegram Trigger: Configure the
Telegram Triggernode with your Telegram bot API credentials to receive messages. - Configure 'If' Node: Adjust the
Ifnode's conditions to accurately identify transaction messages based on keywords. - Customize 'transactions' Code Node: Review and potentially modify the JavaScript code within the
transactionsnode to match any unique transaction message formats you encounter. The current code supports three common formats. - Link to Google Sheets: Update the
Google Sheetsnode with your Google Sheet's Document ID and Sheet Name. Ensure the column headers in your sheet match the keys output by thetransactionsnode (e.g., 'Amount', 'Merchant', 'Card Ending'). - Activate Workflow: Ensure the workflow is set to active to begin automated expense tracking.
Apps Used
Workflow JSON
{
"id": "3a4e99f8-98d4-40de-8781-b58d7cfc7098",
"name": "Automate Your Expenses With Telegram and Google Sheets",
"nodes": 18,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 3a4e99f8-98d4...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.