Google API v1 is no longer supportive of a non-API key based approach
A jQuery plugin that allows you to convert a google spreadsheet into an array of JSON objects.
Easily Convert Google Spreadsheets such as this one into a usable JSON object that you can use within a webpage.
Simply call $.gsr(documentId, callback); to generate a JSON definition of the sheet in reference.
The definition looks like the following:
{
knownHeaders: [array of headers in the spreadsheet],
table: [
array of JSON objects representing the spreadsheet
]
}
Visit: https://gsr-jquery.netlify.com/ for reference documentation and an example