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:
We see Apps Script is a strong signal that this kind of thing is useful. Apps Script adds so much power to Sheets but it could be so much easier to use. With Neptyne, since your spreadsheet engine runs in a Jupyter kernel, you get an interactive REPL and a very straightforward bidirectional API for reading/writing data.
Includes easy fetching: https://developers.google.com/apps-script/reference/url-fetc...
I suppose python could be better for this use case but javascript seems to work fine. And it's all built righ in to Google Sheets.