Googleスプレッドシートの情報を取得

var GoogleSpreadsheetsDataAPI = function(){
  
  var that = this;
  var surl = 'https://spreadsheets.google.com/feeds/cells/';
  var callBack = {};

  that.view =function(){
    getGoogleSpreadsheetsData({
      spreadsheetsUrl : 'https://docs.google.com/spreadsheet/pub?key=0AhTtJ3k83Y6RdHVjcGkyRC1hUVFCNnlHRTZ1VmZWeVE&output=html',
      worksheetId : 1,
      range : 'A2:A500',
    });
  }

  var getGoogleSpreadsheetsData = function(obj) {
    var obj = obj || {
      spreadsheetsUrl : null,
      worksheetId : null,
      range : null,
    };
  	var url = surl
     + obj.spreadsheetsUrl.replace(/.*[\?&]key=([^&]+).*/, '$1')
     + '/' + obj.worksheetId
     + '/public/values';

  	var params = {
  		alt: 'json-in-script'
  	};
  	if(obj.range) {
  		params.range = obj.range;
  	}
    console.log(obj);
    console.log(url);
  	$.ajax({
  		url: url,
  		dataType: 'jsonp',
  		data: params,
  		success: onLoadData
  	});
  }

  var onLoadData = function(data) {
  	var rows = [];
  	$(data.feed.entry).each(function(){
  		var row = parseInt(this.gs$cell.row);
  		var col = parseInt(this.gs$cell.col);
  		var t = this.gs$cell.$t;
  		while(rows.length < row) {
  			rows.push([]);
  		}
  		while(rows[row-1].length < col) {
  			rows[row-1].push('');
  		}
  		rows[row-1][col-1] = t;
  	});
    console.log(rows);

    if(callBack){
      //callBack(rows);
    }

    setTableGoogleSpreadsheetsData(rows);
    return rows;
  }

  var setTableGoogleSpreadsheetsData = function(rows){
  	var table = $('<table>');
    var domain = 'https://plus.google.com/';
    var ary =[];
  	$(rows).each(function(){
  		var tr = $('<tr>');
  		$(this).each(function(){
  			tr.append($('<td>').html('' + this));
        ary.push('' + this);
  		});
  		table.append(tr);
  	});
  	$('#ssview').empty().append(table);
  }

  return that;
}
var gs = GoogleSpreadsheetsDataAPI();
gs.view();

label{
  display:block;
}
td{
  border:1px solid #000000;
}

ページのソースを表示 : Ctrl+U , DevTools : F12

view-source:https://hi0a.com/demo/-js/js-api-google-spreadsheets/