# Personal Finances Automation

> Every rupiah I spend recorded in one Google Sheet, automatically.

- **Type:** Open source
- **Role:** Author
- **Period:** 2023
- **Focus:** Automation, Backend
- **Stack:** JavaScript, Pipedream, Google Sheets, Telegram
- **View on GitHub:** https://github.com/mychaelgo/personal-finances-automation
- **Page:** https://mychaelgo.com/projects/personal-finances-automation

## Problem

Spending is spread across banks, e-wallets and marketplaces, and copying a month of transactions into one sheet by hand takes hours.

## What Mychael did

- Connected the sources with Pipedream: transactions are fetched daily, saved to Google Sheets, and I get a Telegram message when it succeeds or fails.
- Wrote the libraries that fetch the data: a BCA PDF statement parser, plus Gojek, Shopee and SimInvest clients.

## Impact

- 17 stars on GitHub.

## Screenshots

- The background and the tools that connect it all. (https://mychaelgo.com/projects/personal-finances-automation/readme.webp): README section explaining the background and the tools: Google Sheets, Pipedream and Telegram
