emonteiroD1

// call this function on a cell via =ImportJSON("http://...") and data will show up verbatim
function ImportJSON(url) {  
    var response = UrlFetchApp.fetch(url);
    var data = JSON.parse(response.getContentText());

    if (!data.length) {
        return [];
    }

    var rows = [];