I use the GoCardless API to pull transactions and balances into a Google Sheet. They have pretty good coverage for UK and EU it looks like [1]

[1] https://developer.gocardless.com/bank-account-data/overview#...