Make a JSON feed from Google Sheets more pretty to work with – removes "gsx$" key prefixes, un-nests unnecessarily nested objects. Make a GET request to a URL in this format: https://spreadsheets.google.com/feeds/list/126o06NkYz3rLRrIbzKAeLtrK-4a_Eosccmoser11hnk/od6/public/values?alt=json, and pass the resulting JSON to this function.

googleSheetsPrettify.js

function prettifyGoogleSheetsJSON(data) {
    for (var i = 0; i < data.feed.entry.length; i++) {
        for (var key in data.feed.entry[i]) {
            if (data.feed.entry[i].hasOwnProperty(key) && key.substr(0,4) === 'gsx$') {
                // copy the value in the key up a level and delete the original key
                data.feed.entry[i][key.substr(4)] = data.feed.entry[i][key].$t;
                delete data.feed.entry[i][key];
            }
        }
    }
    return data.feed.entry;
}