When I was using Google sheets I was really looking at this company Tiller to auto-fetch my transactions. I never actually tried them out, but the service looks pretty compelling: https://www.tillerhq.com/
I've been using Tiller for a few months and really enjoy the flexibility of using spreadsheets to manage my finances. Some of the sheets aren't incredibly flexible because there are a lot of macros updating them behind the scenes, but Tiller is constantly developing new analyses, and it's very easy to extract data for your own custom sheets. Also, data entry (mostly for transaction categorization) is a breeze, which is a huge plus for me, and the ability to easily add custom categories is huge.