An AI-powered automation built using n8n that captures expense details from a Telegram bot and logs them into an Excel sheet β smartly extracting insights using the Gemini API.
Whenever a user sends an expense message via Telegram (e.g., βΉ200 lunch at Subway or Cab - βΉ450), this AI agent:
-
Uses Gemini API to extract and interpret:
- Amount
- Item
- Category (e.g., Food, Travel, Entertainment)
- Description
- Date (or assigns the current timestamp if missing)
-
Writes the parsed data into an Excel file with the following structure:
Date | Item | Amount | Category | Description
β
Supports messages with currency symbols
β
Intelligently categorizes expenses using Gemini
β
Uses current timestamp when date is missing
- Clone this repository:
git clone https://github.com/yourusername/expense-ai-agent.git
- Open n8n and import the provided .json workflow.
- Configure the node with the required credentials.
- Deploy the workflow and test it by sending an expense message to your Telegram bot. Your Excel sheet should update instantly!
Feel free to fork this project, improve the logic, or add new features like multi-user support, analytics dashboard, or budget alerts. PRs are welcome!
