[Coda] Find row
The Coda Find Row block searches a specified table within a Coda document and returns the first row whose column values match the criteria you provide.
Find a row in a Coda table by column values
The Coda Find Row block searches a specified table within a Coda document and returns the first row whose column values match the criteria you provide. It connects to Coda via an OAuth connection and requires you to specify a document ID, a table ID, and a set of column-value pairs to match against. All column criteria are evaluated together, meaning only rows satisfying every specified condition are considered a match.
The block outputs a row object containing the row's Coda ID and a map of its column values keyed by column name. If no matching row is found, the output is null. The found row can be stored in a destination variable as JSON for use in subsequent workflow steps.
This block fits into workflows that need to look up existing records before deciding what to do next — for example, checking whether a contact already exists in a Coda table before creating a new entry, or retrieving a specific record to read its field values and pass them downstream. It works alongside other Coda blocks or general workflow logic to build data-driven automations on top of Coda documents.
What you can build
Real-world workflows powered by the [Coda] Find row block.
Check for Duplicate Contacts
Before adding a new contact to a Coda CRM table, use this block to search by email address and confirm whether the record already exists.
Retrieve Order Details
Look up a specific order row by order ID in a Coda table to fetch its status and line items for use in a fulfillment workflow.
Validate Form Submissions
After a form is submitted, search a Coda table to verify whether the submitted data matches an approved or registered entry.
Sync External Records
When processing data from an external source, find the corresponding row in a Coda table to compare values before deciding whether an update is needed.
Fetch Employee Records
Search an HR table in Coda by employee ID or name to retrieve role and department information for use in an onboarding or reporting workflow.
Conditional Workflow Routing
Use the returned row or null result to branch a workflow — taking one path if a matching record exists and another if it does not.
Ready to add [Coda] Find row to your workflow?
Get Started FreeCommon questions about [Coda] Find row
What parameters are required to use this block?
The block requires a Coda OAuth connection ID, a document ID identifying which Coda doc to search, a table ID specifying the table within that document, and a rowData object containing one or more column ID and value pairs to match against.
What does the block return when a match is found?
When a matching row is found, the block returns an object with two fields: the row's Coda row ID (a string) and a values map where each key is a column name and each value is the content of that column in the matched row.
What happens if no matching row is found?
If no row matches all of the specified column criteria, the block returns null. Downstream steps should account for this case, for example by checking whether the destination variable is null before attempting to use its values.
How are multiple column criteria handled?
All column-value pairs provided in the rowData field are combined with AND logic, meaning the block only returns a row that satisfies every specified condition simultaneously.
What kinds of workflows commonly use this block?
This block is commonly used in workflows that need to check for existing records before creating new ones, retrieve specific rows to read their field values, or route workflow logic based on whether a particular record exists in a Coda table.
Related capabilities
[Notion] Create Page
Create a new page in Notion as a child of an existing page.
[Notion] Update Page
Update the content of an existing Notion page.
[Coda] Create/Update page
Create a new page or update an existing page in a Coda document.
[Coda] Get table rows
Fetch rows from a Coda table with optional pagination.
[Coda] Create/Update row
Create a new row or update an existing row in a Coda table.
[Coda] Get page
Export and read the contents of a page from a Coda document.
Add [Coda] Find row to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.