# Connect SheetDB with Open Flow

Source: https://openflow.run/en/integrations/sheetdb/

[All integrations](https://openflow.run/en/integrations/)

Ask your AI assistant to work with SheetDB: search spreadsheet rows and apply matching updates.

*   [8 actions](https://openflow.run/en/integrations/sheetdb/#integration-actions)
*   API key
*   Data & analytics
*   Productivity

[Connect SheetDB](https://console.openflow.run/connections/sheetdb)

20,000 free app calls per month (paid services billed separately)

## What you can do

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.

## All actions

8 actions

### 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 actions match your search.

## Connect SheetDB with Open Flow

[Connect SheetDB](https://console.openflow.run/connections/sheetdb)

20,000 free app calls per month (paid services billed separately)
