Show HN: Connect your bank account to Google Sheets

I haven't used its online data-fetching features, but instead save manually save OFX and QFX files periodically from banking Web sites, and later import them into GnuCash (which includes transaction matchup features). I also use the statement reconciliation features.

I save all the OFX, QFX, and PDF files separately, in case I ever want to do something different with the data. (One of my financial services won't let you download transaction data older than 90 days, and most of my services won't let you download data or statements more than 1-2 years old.)

If you don't care about spreadsheets specifically -- if you're just looking for scriptable access to your financials -- Lunch Money (https://lunchmoney.app) has a public API. They'll also be opening the beta of rollover budgeting any day now, which has me excited!

Connecting my bank account to google sheets: -1000000

I do see the intention and the utility - people should be able to easily access and make sense of their data from whatever source and in whatever form. That you are enabling that and showcasing examples is admirable.

Google services in particular are so deeply exposed across people's devices and accounts, past and present, that they have for a long time been one of the largest attack surfaces:

- for incidental or targeted fraud from a distance

- for intrusion by personal contacts: stalking, coercive control

- for relinquishing control of personal data unintentionally: to an employer, to a state, or to arbitrary contacts by oversight because it's incredibly hard to track the myriad dimensions of sharing permissions

In general I applaud what you're doing. I would love to see an example of how to have insight into and oversight of your banking data on your own machine, with a focus on privacy - that's missing from the ecosystem I think.

from this nordigen's information handling section in TOS

> 2.3. As the Services also allow User to upload Information and/or obtain Account Information and personal data therein, User further acknowledges and agrees that by uploading or entering any Information for the Services and by using the Services, User grants Nordigen permission to make anonymized data based on personal and non-personal data collected from User or through User's use of the Services, and combine such anonymized data with that of other Users in order to make anonymized aggregate data. Nordigen may use the anonymized data and anonymized aggregate data for various business purposes and legitimate interests of Nordigen, including but not limited to improving the Services, developing and improving other Nordigen products and services, and distributing or licensing such data to third parties with whom Nordigen has a business relationship.

Every time the word "anonymized" is mentioned here you have to understand that everything in software is at risk of bugs or mistakes. But even if, they'll definitely sell your data.

Everytime I made purchase my bank (BankOfAmerica) send me an email, I parse that email and write data to a google sheet.

It's great because I don't need to give credential to service like Plaid.

I used webhook of service like https://hanami.run and configure my bank to send email notification to name@domain.com (my own domain). Hook it up with hanami.run webhook (or any email to webhook service) and voila, now you can parse the email body and do whatever you want with it, in real time. Bank sends email pretty quick.

I strongly agree on putting a list of supported banks before signing up though. I've had experiences with other providers where sign up and verification takes time, and then after spending 24h being verified it doesn't support your bank anyway... So that up front is good

I understand the need for limits, but 2500 rows x 7 columns?! This isn't exactly "Big Data."

Thank you for sharing these tools.

Is this information, or a list of banks available anywhere?

I'd rather know if this might work for me before spending time on it.