Skip to content

Instantly share code, notes, and snippets.


SoonKhen OwYong owyongsk

View GitHub Profile
ronaldsmartin /
Last active Sep 13, 2021
Google Spreadsheet JSON Queries

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.
+ id=<spreadsheet key>
+ sheet=<sheet name on spreadsheet>
View gist:1276293
Copyright 2011 Martin Hawksey
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
Unless required by applicable law or agreed to in writing, software