Google Spreadsheets API

使用 Google Spreadsheets API 搭建在线应用

利用 Google 問卷(試算表)當小型資料庫__更新版__（一）製作資料庫

利用 Google 問卷(試算表)當小型資料庫__（二）讀取、儲存資料庫

Simple example of retrieving JSON feeds from Spreadsheets Data API

https://spreadsheets.google.com/feeds/list/0AikclfTTti-0dHlSSnRRR0w5eGFzRExRTWRjbWNLN0E/od6/public/values?alt=json-in-script


https://docs.google.com/spreadsheets/d/1vUKbIhXPdoct6HXrBlvYJWRtX4KiUIMy1ICMuWAOgp8/pubhtml

https://spreadsheets.google.com/feeds/list/1vUKbIhXPdoct6HXrBlvYJWRtX4KiUIMy1ICMuWAOgp8/od6/public/values?alt=json

Use a Google Spreadsheet as your JSON backend

Using the Google Spreadsheets Data API to build a Recommended Reading List - Code Words

 
       items.push('

'+entry.gsx$name.$t+'

');

Query a Google Spreadsheet like a Database with

JavaScript 存取 google spreadsheets 試算表

https://docs.google.com/spreadsheet/pub?key=0Asp3dPzRohcndHE4dE0xNXFWWTI2d0dvN1g4VmRQOWc&single=true&gid=1&tq=select%20d&output=html

https://spreadsheets.google.com/tq?tqx=out:html&key=0Asp3dPzRohcndHE4dE0xNXFWWTI2d0dvN1g4VmRQOWc&gid=1&tq=select%20D%20limit%205

PS. 新版Google Sheets生成的key不能使用Google Sheets API的語法

Query Language Reference (Version 0.7) Use the tool to encode or decode a query string:

Google Apps Script

SheetAsJSON – Google Spreadsheet Data as JSON

Getting JSON data from Google spreadsheets and using it in Google maps

 json 1000 limit 
$.getJSON('https://spreadsheets.google.com/feeds/list//od6/public/values?alt=json', function(data) {
       
for (var i = 0; i < data.feed.entry.length; i++) {
 
  var id = data.feed.entry[i].gsx$benchid.$t;
  var photo = data.feed.entry[i].gsx$photourl.$t;
  var caption = data.feed.entry[i].gsx$captionoptional.$t;
  var string = '' + caption + '

';
         
  var lat = data.feed.entry[i].gsx$lat.$t;
  var long = data.feed.entry[i].gsx$long.$t;
 
  createMarker(lat, long);
  createInfoWindow(id, string);
 
};