Quickstart

1. Install:

npm

npm install holysheets

yarn

yarn add holysheets

pnpm

pnpm install holysheets

2. Authenticate with Google APIs (using a Service Account or OAuth).

3. Initialize HolySheets!:

import HolySheets from 'holysheets'

const sheets = new HolySheets({
  spreadsheetId: 'YOUR_SPREADSHEET_ID',
  auth: yourAuthClient
})

const users = sheets.base<{ name: string; email: string }>('Users')

4. Perform Operations:

await users.insert({ data: [{ name: 'Alice', email: 'alice@example.com' }] })
const found = await users.findMany({ where: { name: { equals: 'Alice' } } })
console.log(found.data)

Check out the guides and concepts sections for deeper explanations.