pushboard template (Google Spreadsheets backend)

JSONP & Google Spreadsheetz to retrieve dataz

HTML

<div id="results"></div>

CSS

td {
    padding-right: 1em;
}
.name{
    font-weight: 900;
}
.date{
    background-color: #666;
    border: #fff 0.75em solid;
    color: #ccc;
}

JavaScript

var spreadsheet_id = '1PugfDgRTtRQosAqCb-C9OaRr0rvpFdpcQrP5tZA5oLE';
var url = 'https://spreadsheets.google.com/feeds/cells/'+spreadsheet_id+'/od6/public/values?alt=json-in-script&callback=?';


$.getJSON(url, cellEntries);

function cellEntries(json) {
  var table = document.createElement('table');
  table.setAttribute('id', 'output');
  var tbody = document.createElement('tbody');
  
  var tr;
  var thead;
  var header_col = [];
  var number_of_header_cellz = 8;
    
  for (var i=0; i < json.feed.entry.length; i++) { 

    if(i < number_of_header_cellz){
      header_col[(i)] = json.feed.entry[i].content.$t;
      continue;
    }
      
    var entry = json.feed.entry[i];
    
      
    if (entry.gs$cell.col == '1') {
      if (tr != null) {
        tbody.appendChild(tr);   
      }
      tr = document.createElement('tr');
    }
    
    
    var td = document.createElement('td');
    td.setAttribute('class', header_col[(i%number_of_header_cellz)]);
    td.appendChild(document.createTextNode(entry.content.$t));
    tr.appendChild(td);
  } 

  tbody.appendChild(tr);
  table.appendChild(tbody);
  document.getElementById('results').appendChild(table);
}