{"library":"spreadsheet-sql","type":"library","category":null,"description":"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.","language":"javascript","status":"active","version":"1.1.1","tags":["javascript","google","spreadsheet","sql","charts","visualization","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install spreadsheet-sql","imports":["import { PublicSpreadsheet } from 'spreadsheet-sql'","import { PrivateSpreadsheet } from 'spreadsheet-sql'","new PrivateSpreadsheet(sheetKey, sheetName, authClient)"]},{"cmd":"yarn add spreadsheet-sql","imports":[]},{"cmd":"pnpm add spreadsheet-sql","imports":[]}],"homepage":"https://github.com/JumpeiArashi/spreadsheet-sql#readme","github":"https://github.com/JumpeiArashi/spreadsheet-sql","docs":null,"changelog":null,"pypi":null,"npm":"spreadsheet-sql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}