Google Spreadsheets Data Plugin

[weilonge]

Use this link to get a google spreadsheet data in JSON format:
http://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values?alt=json

Example format:

{
    "version": "1.0",
    "encoding": "UTF-8",
    "feed": {
        "xmlns": "http://www.w3.org/2005/Atom",
        "xmlns$openSearch": "http://a9.com/-/spec/opensearchrss/1.0/",
        "xmlns$gsx": "http://schemas.google.com/spreadsheets/2006/extended",
        "id": {
            "$t": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values"
        },
        "updated": {
            "$t": "2015-10-04T06:20:33.843Z"
        },
        "category": [{
            "scheme": "http://schemas.google.com/spreadsheets/2006",
            "term": "http://schemas.google.com/spreadsheets/2006#list"
        }],
        "title": {
            "type": "text",
            "$t": "工作表1"
        },
        "link": [{
            "rel": "alternate",
            "type": "application/atom+xml",
            "href": "https://docs.google.com/spreadsheets/d/[SPREADSHEETS_KEY]/pubhtml"
        }, {
            "rel": "http://schemas.google.com/g/2005#feed",
            "type": "application/atom+xml",
            "href": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values"
        }, {
            "rel": "http://schemas.google.com/g/2005#post",
            "type": "application/atom+xml",
            "href": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values"
        }, {
            "rel": "self",
            "type": "application/atom+xml",
            "href": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values?alt\u003djson"
        }],
        "author": [{
            "name": {
                "$t": "weilonge"
            },
            "email": {
                "$t": "weilonge@gmail.com"
            }
        }],
        "openSearch$totalResults": {
            "$t": "4"
        },
        "openSearch$startIndex": {
            "$t": "1"
        },
        "entry": [{
            "id": {
                "$t": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values/cokwr"
            },
            "updated": {
                "$t": "2015-10-04T06:20:33.843Z"
            },
            "category": [{
                "scheme": "http://schemas.google.com/spreadsheets/2006",
                "term": "http://schemas.google.com/spreadsheets/2006#list"
            }],
            "title": {
                "type": "text",
                "$t": "Sharon"
            },
            "content": {
                "type": "text",
                "$t": "age: 12, gender: Female"
            },
            "link": [{
                "rel": "self",
                "type": "application/atom+xml",
                "href": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values/cokwr"
            }],
            "gsx$name": {
                "$t": "Sharon"
            },
            "gsx$age": {
                "$t": "12"
            },
            "gsx$gender": {
                "$t": "Female"
            }
        }, {
            "id": {
                "$t": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values/cpzh4"
            },
            "updated": {
                "$t": "2015-10-04T06:20:33.843Z"
            },
            "category": [{
                "scheme": "http://schemas.google.com/spreadsheets/2006",
                "term": "http://schemas.google.com/spreadsheets/2006#list"
            }],
            "title": {
                "type": "text",
                "$t": "Tim"
            },
            "content": {
                "type": "text",
                "$t": "age: 8, gender: Male"
            },
            "link": [{
                "rel": "self",
                "type": "application/atom+xml",
                "href": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values/cpzh4"
            }],
            "gsx$name": {
                "$t": "Tim"
            },
            "gsx$age": {
                "$t": "8"
            },
            "gsx$gender": {
                "$t": "Male"
            }
        }, {
            "id": {
                "$t": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values/cre1l"
            },
            "updated": {
                "$t": "2015-10-04T06:20:33.843Z"
            },
            "category": [{
                "scheme": "http://schemas.google.com/spreadsheets/2006",
                "term": "http://schemas.google.com/spreadsheets/2006#list"
            }],
            "title": {
                "type": "text",
                "$t": "Gina"
            },
            "content": {
                "type": "text",
                "$t": "age: 10, gender: Female"
            },
            "link": [{
                "rel": "self",
                "type": "application/atom+xml",
                "href": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values/cre1l"
            }],
            "gsx$name": {
                "$t": "Gina"
            },
            "gsx$age": {
                "$t": "10"
            },
            "gsx$gender": {
                "$t": "Female"
            }
        }, {
            "id": {
                "$t": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values/chk2m"
            },
            "updated": {
                "$t": "2015-10-04T06:20:33.843Z"
            },
            "category": [{
                "scheme": "http://schemas.google.com/spreadsheets/2006",
                "term": "http://schemas.google.com/spreadsheets/2006#list"
            }],
            "title": {
                "type": "text",
                "$t": "Frank"
            },
            "content": {
                "type": "text",
                "$t": "age: 6, gender: Male"
            },
            "link": [{
                "rel": "self",
                "type": "application/atom+xml",
                "href": "https://spreadsheets.google.com/feeds/list/[SPREADSHEETS_KEY]/od6/public/values/chk2m"
            }],
            "gsx$name": {
                "$t": "Frank"
            },
            "gsx$age": {
                "$t": "6"
            },
            "gsx$gender": {
                "$t": "Male"
            }
        }]
    }
}