Google SheetAsJSON + Filtering
This is an extension of DJ Adams’ excellent SheetAsJSON Google Apps Script, which provides a way to GET a published Google Spreadsheet as a JSON feed. This version allows generic filtering for terms, more specific control over which rows to parse, and correct MIME type for JSONP output.
Minimal Usage
The following parameters are required for the script to work.
<span style="color: #24292e;"></span> <span style="color: #24292e;">+ id=<spreadsheet key></span> <span style="color: #24292e;">+ sheet=<sheet name on spreadsheet> </span>Per the original, the above script serves a representation of all the sheet’s data as JSON, using the first row as the set of keys:
{ records : [ { (row1, column1): (row2, column1), (row1, column2): (row2, column2), ..}, { (row1, column1): (row3, column1), (row1, column2): (row3, column2), ..}, ... ] }