JSFiddle - React, Tailwind, and code Playground

by yairamon

JavaScript

// general setup
var id = "1xCqAxBKNXHuATDgMmnstus8bOfdW_aUeHT4BJ-DuD-M";
var url = 'https://spreadsheets.google.com/feeds/cells/' + id + '/1/public/values?alt=json-in-script&callback=?';


$.getJSON(url, cellEntries);

function cellEntries(json) {
  var data = json.feed.entry;

  var allData = [];
  var rowData = [];
  var row = 0;

  for (var i = 0; i < data.length; i++) {
    var cell = data[i]["gs$cell"];

    if (cell.col == 1) {
      if (++row > 1) {
        allData.push(rowData);
        rowData = [];
      }
    }

    var val = cell["$t"];
    rowData.push(val);

  }

  allData.push(rowData);

  pokemonMetadata = allData;
  alert(JSON.stringify(allData));
}