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