A python telegram bot to help track daily expenses onto google sheet
- Access the bot on telegram
- Use the /start command and follow the instructions given.
- Remember to edit the
Dropdown
sheet on Google Sheet to get started. - Happy using!
- Set up Google Sheet API
- Set up Firebase Realtime Database / or use SQLite3
- Retrieve your service accounts for both Google Services and put it under the account folders as service_account.json & firebase_account.json
- Retrieve your database url and set it under .env
- Set up telegram bot via BotFather
- Retrieve your bot API token and set it under .env
- Clone the repo and run to get required dependencies
pip install -r requirements.txt
- Run
python3 main.py
/start - Start the bot and configure your Google Sheet for tracking expenses and other entries.
/config - Update your Google Sheet settings or configure quick settings for adding transport and other entries.
/addentry - Add a new entry to your expense tracking system.
/addtransports - Quickly add a new transport entry to your expense tracker.
/addothers - Quickly add another type of entry to your expense tracker.
/cancel - Cancel the previous conversation with the bot and start fresh.
/help - Show help message
- More options for /addothers
- Retrieve your last few transaction
- /addincome
- Recurring transaction
- Budgeting notification
- Reminders
- Use webhook instead of polling
- Host onto serverless function
Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.
If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!
- Fork the Project
- Create your Feature Branch (
git checkout -b feature/AmazingFeature
) - Commit your Changes (
git commit -m 'Add some AmazingFeature'
) - Push to the Branch (
git push origin feature/AmazingFeature
) - Open a Pull Request
Distributed under the MIT License. See LICENSE.txt
for more information.
Bruce Wang: [email protected]
LinkedIn: https://www.linkedin.com/in/brucewzj/
Project Link: https://github.com/brucewzj99/tele-tracker