Sheetrock is a jQuery plugin for querying, retrieving, and displaying data from Google Spreadsheets. Use it to load entire sheets or leverage SQL-like queries to treat Google Spreadsheets as a quick-and-dirty JSON datastore. All you need is the URL of a public Google Spreadsheet. It requires no backend code whatsoever—everything is done in the browser.
Features:
Query sheets using the SQL-like Google Visualization query language (filters, pivots, sorting, grouping, and more)
Lazy-load large data sets (infinite scroll with ease)
Mix in your favorite templating system (Handlebars, Underscore, etc.)
Customize to your heart’s content with your own handlers and callbacks