Read this in other languages: русский
Telegram bot that allows you to keep track of finances in Google Sheet. Through the bot, you can add records of expenses, income, and transactions between accounts directly to Google Sheet which is stored in your account. You can also get the amount of finances available. The bot only works with a specific Google Sheet template (read more in Quickstart). This bot does not store any financial information and does not connect to the bank apps. All the data is provided by user himself. It is currently active @telexpense_bot.
This code is not intended to run locally, only for demonstration purposes.
- Adding expenses and income records
- Adding records of transfers between accounts
- Getting a list of accounts and their balances
Detailed instructions can be found in the wiki. Here is only a brief summary.
To use the bot you need to complete registration. If you are already registered, you will see buttons to add expenses and income. If you are not in the database, you will see the /register button. Registration is as follows:
- Copy Google Sheet template to your account
- Add bot service account as an editor to your sheet: [email protected]
- Start the @telexpense_bot with command /start
- Tap or type /register
- Paste link to copied Google Sheet from your account to bot chat
- Add expenses and income, they will be displayed on the "Transactions" sheet
You can support the author through the bot. To do this, use the command /donate. Donated money is used to pay for hosting and functional development.