Sheetrock favicon

Sheetrock

Sheetrock is a JavaScript library for querying, retrieving, and displaying data from Google Sheets. In other words, use a Google spreadsheet as your database! Load entire worksheets or leverage SQL-like queries to sort, group, and filter data. All you need is the URL of a public Google Sheet. FEATURES:

  • No dependencies.
  • Can be used in the browser or in the server with Node.js.
  • 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).
  • Easily mix in your favorite templating system (Handlebars, Underscore, etc.)
  • Customize to your heart’s content with your own callbacks.