Leina 
Wanta 
Find matching records
Read column names and search using column conditions.
/oo SheetDB: Get SheetDB keys, then search query [column conditions JSON] with [AND/OR mode] and summarize returned rows.
Connect SheetDB to Your AI Agent
Ask your AI assistant to work with SheetDB: search spreadsheet rows and apply matching updates.
8 tools API key
Try a SheetDB Task
Copy a prompt into your agent with the oo Skill installed. Add your page links and source notes before running it.
oo Skill SheetDB
Update matching rows
Update all rows matching a column and value.
/oo SheetDB: Update SheetDB rows where searchColumn [column] equals searchValue [value] with data [JSON object]. Report the result.
Start Working with SheetDB
-
Install OOMOL
Set up oo CLI and the oo Skill in your agent.
Install OOMOL → -
Connect SheetDB
Connect with your SheetDB Bearer Token and spreadsheet API ID.
Connect SheetDB → -
Give Your Agent a Task
Use /oo with the pages to read, the changes to make, and where to save the result.
Connection Guide →
Choose Your Agent
- An account with access to the SheetDB resources used in your task.
SheetDB Tools
SheetDB exposes row operations for one connected spreadsheet API using dynamic column conditions.
Find matching records
Read column names and search using column conditions.
Update matching rows
Update all rows matching a column and value.
8 tools
List Rows
List rows from the connected SheetDB spreadsheet with optional paging and sorting.
sheetdb.list_rows Get Keys
Get the column names from the first row of the connected spreadsheet.
sheetdb.get_keys Get Document Name
Get the Google Sheets document name for the connected SheetDB API.
sheetdb.get_document_name Count Rows
Count data rows in the connected spreadsheet, excluding the header row.
sheetdb.count_rows Search Rows
Search spreadsheet rows using dynamic column conditions and AND or OR matching.
sheetdb.search_rows Create Rows
Append one or more JSON rows to the connected spreadsheet.
sheetdb.create_rows Update Rows
Update all rows matching one spreadsheet column and value.
sheetdb.update_rows Delete Rows
Delete all rows matching one spreadsheet column and value.
sheetdb.delete_rows No matching tools.
Frequently Asked Questions
Does update_rows affect only the first match?
It updates all rows matching the supplied column and value.
Does the row count include headers?
count_rows excludes the header row.
What extra connection value is needed?
Provide the SheetDB API ID with its Bearer Token.