spreadsheet-sql

Query Google Spreadsheets using SQL-like syntax. Version 1.1.1 currently stable. The library wraps the Google Visualization API Query Language, allowing SELECT, WHERE, and other SQL-like clauses on spreadsheet data. It supports both public spreadsheets (no auth) and private spreadsheets via any google-auth-library AuthClient (breaking change from v1: previously required direct OAuth2 parameters). The first row is always treated as column headers. Ship with TypeScript type definitions. Release cadence is low, last update was in 2021.