Database

Google sheets local sync: searchable entities, .search() filters, and operators.

The Google sheets plugin syncs data locally. Use corsair.googlesheets.db.<entity>.search({ data, limit?, offset? }) with the filters listed per entity.

New to Corsair? See database operations, data synchronization, and multi-tenancy.

Rows

Path: googlesheets.db.rows.search

const rows = await corsair.googlesheets.db.rows.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
rowId	string	equals, contains, startsWith, endsWith, in
spreadsheetId	string	equals, contains, startsWith, endsWith, in
sheetName	string	equals, contains, startsWith, endsWith, in
range	string	equals, contains, startsWith, endsWith, in
createdAt	date	equals, before, after, between

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---

Sheets

Path: googlesheets.db.sheets.search

const rows = await corsair.googlesheets.db.sheets.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
sheetId	string	equals, contains, startsWith, endsWith, in
spreadsheetId	string	equals, contains, startsWith, endsWith, in
title	string	equals, contains, startsWith, endsWith, in
index	number	equals, gt, gte, lt, lte, in
createdAt	date	equals, before, after, between

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---

Spreadsheets

Path: googlesheets.db.spreadsheets.search

const rows = await corsair.googlesheets.db.spreadsheets.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
spreadsheetId	string	equals, contains, startsWith, endsWith, in
title	string	equals, contains, startsWith, endsWith, in
spreadsheetUrl	string	equals, contains, startsWith, endsWith, in
createdAt	date	equals, before, after, between

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---