Optional ยท Advanced ยท Free
Let your bank emails log your spending
Your bank already emails you after every debit. A small script can read those emails and add each spend to your Tereka sheet. Every hour. No typing.
๐ Your email stays yours
- The script runs in your own Google account, inside your Tereka sheet. Not on Tereka's side.
- Tereka never sees your email. The script sends nothing anywhere.
- It keeps only the amount, the date and a short description. Account numbers and balances are ignored.
- The code is short and open. Read every line.
Before you start
- โ Your Tereka Google Sheet. In Tereka, tap Sign in with Google once. It makes your sheet.
- โ Bank alerts by email. Turn on email alerts in your bank app, if they're off.
- ๐ป A laptop is easier for the setup. It takes about 5 minutes, once.
Set it up in 6 steps
- 1Open your Tereka sheet. Go to Google Drive and open the sheet called "Tereka ยท your name".
- 2Click Extensions, then Apps Script. A code page opens.
- 3Delete what's there and paste the code.
- 4Click Save ๐พ. Then at the top, choose setup and click Run.
- 5Allow access. Google will say "Google hasn't verified this app". That's normal. It's your own script, not a Tereka app. Click Advanced, then Go to your project, then Allow.
- 6Done โ Every hour, new debit alerts go into your sheet. In Tereka's Tracker, tap Get new alerts from my Sheet to bring them in.
Want to try it first? In step 4, choose preview instead of setup. It shows what it would add, without adding anything.
Good to know
- ๐ท๏ธ Each email it reads gets the Gmail label Tereka/logged. So nothing is added twice.
- ๐ฅค Tereka guesses the cup from the description. You can change it in the Tracker.
- ๐ฆ Only debits are added, never credits. Some banks write alerts in unusual ways. If yours doesn't work, use Paste alerts instead, and tell us at financepamo@gmail.com.
- โน๏ธ To stop: open Apps Script again, choose stop and click Run. Or delete the script.