Track Finances From Telegram
Automatically log income and expenses from Telegram messages to Google Sheets with instant confirmations.
Telegram BotFinance TrackingGoogle SheetsExpense Management
Money Tracker Bot
This workflow tracks your income and expenses directly from Telegram messages. Whenever you send a money-related message to your Telegram bot, it automatically extracts the transaction details and logs them into a Google Sheet.
The workflow performs the following steps:
- Listens for new messages sent to your Telegram bot.
- Uses an AI model to interpret each message and extract structured financial data such as transaction type, amount, currency, category, and description.
- Filters out messages that do not pertain to money.
- Adds valid transactions as new rows in your specified Google Sheet.
- Sends a confirmation message back to you in Telegram showing the logged transaction.
What You Need
- A Telegram bot with permissions to receive message updates (Telegram Bot API credentials).
- A Needle account with access to the Needle AI connector.
- A Google Sheets account with a prepared sheet to log transactions.
- Connectors for Telegram and Google Sheets configured in Pipedream.
How It Works
| Node | Purpose |
|---|---|
| Telegram Bot API: Message Updates Trigger | Watches for new messages sent to your Telegram bot. |
| Needle AI v2 | Processes each message to generate structured JSON with transaction details. |
| Code Node | Filters out messages categorized as "ignore" (non-money-related messages). |
| Google Sheets: Upsert Row | Inserts the transaction data as a new row in your chosen Google Sheet. |
| Telegram Bot API: Send Text Message | Sends a confirmation message back in Telegram with the logged transaction details. |
Output
At the end of this workflow, your financial transactions mentioned in Telegram messages are neatly recorded in your Google Sheet. You also receive immediate confirmation messages in Telegram so you can be confident your transactions have been logged.
Additional Notes
- The AI recognizes Indian Rupees (₹, rs, rupees) and US Dollars ($, usd) based on currency symbols or keywords.
- Messages unrelated to finances are ignored without interrupting the workflow.
- Ensure your Google Sheet columns match the fields: transaction type, amount, currency, category, and description.
- You can customize expense categories in the AI prompt for more detailed tracking.
- Keep your Telegram bot token and Google Sheets credentials secure at all times.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.