MoneyForward2Gsheet

Downloading asset trends📈 from MoneyForward, and exporting them to google spreadsheet, in python.

env

• docker

setting

fill in src/config.ini

# case of single account
[MONEYFORWARD]
Email = [
    "<REGISTERED EMAIL>"
]
Password = [
    "<REGISTERED PASSWORD>"
]

# case of multi account
[MONEYFORWARD]
Email = [
    "<REGISTERED EMAIL 1>",
    "<REGISTERED EMAIL 2>",
    "<REGISTERED EMAIL 3>"
]
Password = [
    "<REGISTERED PASSWORD 1>",
    "<REGISTERED PASSWORD 2>",
    "<REGISTERED PASSWORD 3>"
]

[SPREAD_SHEET]
Key = <SPREADSHEET KEY got from URL>

google spreadsheet R/W

enable API, and allow client to edit your sheet.
reference

Place the obtained json file as src/client_secret.json .

run

$ pwd
~/MoneyForward2Gsheet
$ bash make_env.sh
$ docker-compose build
$ docker-compose up -d

Appendix

result

Asset transition data written to a spreadsheet. ( Of course, the numbers are dummy XD )

With this data, you can create any graph you like.
As shown below. reference