Yep, I occasionally email the CSV to myself through the app, then open it in gmail and copy paste the whole thing into a sheet in my master spreadsheet of doom. Within that master spreadsheet of doom I also have a sheet that automatically pulls in my personal spending from the auto export using the IMPORTRANGE formula.
I call it the master spreadsheet of doom as it also aggregates data on the following;
- google fit (i.e. step counts and locations etc)
- solar panel usage
- utilities (exported from octopus watch)
- car mileage
So in theory, I could look up any date for the past 5 years (as far back as 10 years for some of the metrics) and tell you where I was, how many steps I walked, how far I drove, what I spent money on, whether I had the heating on and how sunny it was. All super useful haha…