SheetDB

SheetDB integration (Data, Productivity). Imported from open-connector.

API key5 toolshttps://sheetdb.io

GET

sheetdb_list_rows

List rows from the connected SheetDB spreadsheet with optional paging and sorting.

/api/v1/{apiId}{path}

11 parameters

Param	Type	Required	Description
sheet	string	optional	The optional spreadsheet tab name.
limit	integer	optional	The maximum number of rows to return.
offset	integer	optional	The number of rows to skip before returning results.
sortBy	string	optional	The column name used to sort rows.
sortOrder	string	optional	The row sort order.
sortMethod	string	optional	Use date-aware sorting.
sortDateFormat	string	optional	The date format used for date-aware sorting, such as Y-m-d.
castNumbers	array	optional	Column names whose values should be converted to numbers.
valueRenderOption	string	optional	How Google Sheets values should be rendered.
apiId	string	required	Path parameter: apiId
path	string	required	Path parameter: path

GET

sheetdb_get_keys

Get the column names from the first row of the connected spreadsheet.

/keys

1 parameter

Param	Type	Required	Description
sheet	string	optional	The optional spreadsheet tab name.

GET

sheetdb_search_rows

Search spreadsheet rows using dynamic column conditions and AND or OR matching.

/search_or

12 parameters

Param	Type	Required	Description
query	object	required	Search conditions keyed by spreadsheet column name.
match	string	optional	Whether all or any search conditions must match.
caseSensitive	boolean	optional	Whether string matching is case-sensitive.
sheet	string	optional	The optional spreadsheet tab name.
limit	integer	optional	The maximum number of rows to return.
offset	integer	optional	The number of rows to skip before returning results.
sortBy	string	optional	The column name used to sort rows.
sortOrder	string	optional	The row sort order.
sortMethod	string	optional	Use date-aware sorting.
sortDateFormat	string	optional	The date format used for date-aware sorting, such as Y-m-d.
castNumbers	array	optional	Column names whose values should be converted to numbers.
valueRenderOption	string	optional	How Google Sheets values should be rendered.

PATCH

sheetdb_update_rows

Update all rows matching one spreadsheet column and value.

/{searchColumn}/{searchValue}

5 parameters

Param	Type	Required	Description
searchColumn	string	required	The column name used to select rows for updating.
searchValue	string	required	The value used to select rows for updating.
data	object	required	A spreadsheet row keyed by column name.
sheet	string	optional	The optional spreadsheet tab name.
valueInputOption	string	optional	The Google Sheets value rendering or input mode.

DELETE

sheetdb_delete_rows

Delete all rows matching one spreadsheet column and value.

/{searchColumn}/{searchValue}

3 parameters

Param	Type	Required	Description
searchColumn	string	required	The column name used to select rows for deletion.
searchValue	string	required	The value used to select rows for deletion.
sheet	string	optional	The optional spreadsheet tab name.