I feel like I should plug something I've been helping with for a while- it's not documented well yet, nor fully CRUD capable, but if you want to interface with Google Sheets a little better (and get things out in arrays of objects) this might be a good start:
...I logged back into my lurker account just because of how annoying this was- I use Google Sheets all the time to do data visualization and analysis work because it just works, and because I can share my results with other people, and let them explore the data in a format that they understand.
There's a reason lots of MBA types get issued high-performance, high RAM machines- because asking them to learn SQL or whatever AND asking them to learn how data structures and query syntax work instead of just doing things a little more slowly and throwing more performance at Excel makes a lot of sense.
Not saying it's perfect, but please don't hate on Excel et al because they aren't the perfect world way of doing things.
This was my single biggest hurdle when I was trying to set up a personal VPN to remote manage things- I didn't really understand what I was supposed to do, or why things just never quite worked.
https://github.com/texas-mcallen-mission/sheetCore