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.
https://github.com/texas-mcallen-mission/sheetCore