Have you looked into the plaid[0] free(test) tier? They hook into a bunch of different banks and the free tier exposes balance and transaction history.
It imports live bank transactions into a Google Sheet for you to use however you want.
To that end, I looked into using Plaid's API to craft my own but it's a bit daunting, especially with a couple of my financial institutions continually failing and having to be reauthenticated, so I don't envy these developers their tasks.