In a previous post I explained how to extract JSON data from a Google Spreadsheet via an API call.
However, when you actually get the data, the JSON isn’t really in the kind of structure you would imagine. Instead of a matrix of rows and columns, Google returns an RSS-style linear feed of “entries” for all of the cells!
Running this function we can then get the values from the resulting array using something like:
Note that the function doesn’t differentiate the labels from a header row (which is something you’d commonly see, and which R would usually expect) so there is definitely room for improvement in the function.