Open Sheets ORMA Prisma-inspired, type-safe ORM for Google Sheets.

A TypeScript/JavaScript library that turns any Google Spreadsheet into a queryable database with schema validation, type coercion, and a developer-friendly API.

Get Started

API Reference

NPM

GitHub

TypeScript/JavaScript

Built with TypeScript, works in any JS/TS project. Install via npm

Schema Compiler

Define models and fields with a fluent builder API. Supports string, number, boolean, date, and JSON field types.

Type Coercion

Raw cell values are automatically parsed into the correct TypeScript types — numbers, booleans, dates, and JSON.

CRUD Operations

findMany, findUnique, create, update, and delete with filtering, pagination, and uniqueness enforcement.

Auto-Generated Client

CLI tool produces a typed client from your schema with model-specific delegates and interfaces.

Google Sheets Integration

Built-in adapter for Google Sheets with service account authentication. Extensible adapter pattern for other providers.

A quick gotcha for the purists

Yes, this is technically clickbait. There's no relational database here, so "ORM" is a stretch. An "Object Sheet Mapper" (OSM) would be more accurate — but let's be honest, nobody would know what that means. We went with ORM because it instantly communicates the dev experience: define a schema, run queries, get typed results. Same vibes, different grid.