Sync your bank transactions with google sheets using Open Banking APIs
this is a markdown version of the copy on the site landing page: https://youneedaspreadsheet.com
Get on top of your finances by tracking all of your bank accounts in Google Sheets. Having a high level view of your money is a budgeting superpower, you’ll be able to analyse your spending & savings over the long term, and work out how to hit your money goals. But it’d be a pain to manually update a spreadsheet with your transactions & balances, why not let the robots do it for you? 🤖
£4 per month, billed via Stripe.
If you’d like to connect a business account check out the business page.
You can find the list of supported banks here.
UK banks have a pretty cool, but under-adopted feature called ‘open banking’ which is a set of APIs provided by all banks that allow users & companies to read data, pay & accept payments via a common interface. This page uses Truelayer to connect to your bank and read the balance & transactions, then writes that data into a spreadsheet using the Google Sheets API.
I use this tool to have my current bank balance in a few different spreadsheets, i also feed it into BigQuery as an external table so i can make a Grafana dashboard for my daily spending & budgets, you can find a guide on how to do that here.