Telegram Timesheet Bot
What It Does
Built a custom Telegram bot that fully automates the weekly timesheet and expense tracking process. Instead of spending 30 minutes per week manually filling out an Excel spreadsheet, expenses and dates are texted to the bot as they occur. The system auto-calculates totals, formats everything into the required Excel template, and auto-emails the completed timesheet for review on a weekly schedule. Exploring sharing this tool with coworkers to shift from personal automation to internal tooling.
Key Features
- Telegram bot accepting expense entries and dates via text message
- Auto-calculates totals and formats into required Excel timesheet template
- Scheduled email delivery of completed timesheet for review
- Template system for different client formats
- Time entry validation and error checking
Why I Built It
I was spending 30+ minutes every Friday formatting timesheets manually. Automating it saved hours per month and eliminated formatting errors.
What I Learned
Learned Excel generation programmatically, email integration with attachments, and how to design scheduling systems that handle edge cases like holidays. Now exploring how to turn this into a shared internal tool for the organization.