Search Spreadsheet Rows and Apply Matching Updates

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

What to Ask Leina to Do with SheetDB

Copy a prompt, add your details, and send it to Leina in your connected team chat.

Read column names and search using column conditions.

Get SheetDB keys, then search query [column conditions JSON] with [AND/OR mode] and summarize returned rows.

Update all rows matching a column and value.

Update SheetDB rows where searchColumn [column] equals searchValue [value] with data [JSON object]. Report the result.

Get Started with SheetDB

  1. Connect Your Account

    Connect with your SheetDB Bearer Token and spreadsheet API ID.

  2. Try a Task

    Tell Leina what you need in your team chat. Include the source, destination, and expected result.

    Set Up Leina in Your Chat →
  3. Check the Result

    Review the result and any changes in the connected app.

Supported SheetDB Capabilities

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.

View All 8 Actions
  • List Rows
  • Get Keys
  • Get Document Name
  • Count Rows
  • Search Rows
  • Create Rows
  • Update Rows
  • Delete Rows

Visit Provider Website ↗

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.

Your AI employee for SheetDB

Tell Leina what you need in your team chat. Include the source, destination, and expected result.