sqlite-cache-for-google-sheets

Opinionated SQLite cache layer for Google Sheets data, designed for local development workflow where schema changes frequently. Version 9.0.0 is stable, actively maintained on GitHub. Ships TypeScript types. Provides a one-time load from Google Sheets into a local SQLite database, then allows querying via better-sqlite3. Unlike direct API queries, it avoids runtime dependency on Google Sheets and enables fast iteration. Requires API key, doc ID, and sheet ID. Uses a configurable map function to transform rows. Returns a better-sqlite3 database object for querying.