Hello {reader.name} my name is Miha Jan Strehovec I love working with computers, and I am passionate about web development, user experience and digitalization. Through which I aim to make peoples lives easier. At 24, my journey has been diverse and forward-thinking, shaped by experiences that range from web development, QA and digital media leadership. In my free time I like to tackle personal projects that derive from my ideas or the ideas of my friends. Through them I attain new skills that I can then apply in my professional life.
Personal Finance Tracker
Telegram bot script for finances
DESCRIPTION
I've tried out multiple personal finance apps and I didn't manage to stick with any of them. The user flow was clunky and before I knew it the app that was trying to save me money, was costing me 2.99€ per month to collect digital dust. For that reason I joined forces with my colleague who has already started the development (hoping that I will stick with something that developed).
Over the weekend I developed a Telegram bot that interacts withGoogle Sheets to help me report and manage my expenses. Communication between the bot and Google sheets is handled with a Google script, that based on the users input executes a task. For example generating a weekly report can be done by sending the keyword “weekly“ and the script sends the user a text report, a Pie chart representing expense categories and a line chart for daily spendings.
PROJECT ROLE
KEY FEATURES
- Telegram bot: Set up a Telegram bot and connect it with Google scripts to receive commands.
- Google sheets: Storing and manipulating data in Google Spreadsheet for ease of parsing and user interaction.
- Expense charts: Creating charts using Googles Charts and uploading them to Google Drive for sharing with Telegram bot.
- Data parsing: Working with differnet data types across different platforms with a highlight on Date objects.
- Automation: Making sure the script will be able to run for years to come with minimal user interaction.
