[Airtable] Get record
The Airtable Get Record block retrieves a single record from a specified Airtable table using that record's unique record ID.
Fetch a single Airtable record by its ID
The Airtable Get Record block retrieves a single record from a specified Airtable table using that record's unique record ID. To use it, you provide an Airtable OAuth connection, a base ID, a table ID, and the record ID you want to fetch. The result can be stored in a workflow variable for use in later steps.
When a record is found, the block returns an object containing the record's ID, a createdTime timestamp in ISO 8601 format, and a fields object whose keys are the field names from your Airtable table and whose values are the corresponding field data. If no matching record is found, the output is null.
This block fits into workflows that need to look up specific Airtable entries by a known ID — for example, retrieving a customer record after an ID has been passed in from a form submission, pulling a task's details mid-workflow, or reading configuration data stored in Airtable before proceeding to a downstream processing step.
What you can build
Real-world workflows powered by the [Airtable] Get record block.
Customer Profile Lookup
When a user submits a support request with their Airtable record ID, fetch their full profile from an Airtable CRM base to personalize the AI response.
Order Details Retrieval
Pull a specific order record from an Airtable orders table using an order ID passed in from an upstream workflow step or webhook trigger.
Task Status Check
Retrieve a project task record by ID to read its current status and field values before deciding which workflow branch to follow.
Content Record Fetch
Look up a specific content item stored in Airtable — such as a blog post draft or product description — to feed into an AI text processing block.
Configuration Data Load
Read a configuration or settings record from Airtable at the start of a workflow to supply dynamic parameters to subsequent blocks.
Employee Record Access
Fetch an individual employee record from an HR base using a known record ID to populate onboarding or notification workflows.
Ready to add [Airtable] Get record to your workflow?
Get Started FreeCommon questions about [Airtable] Get record
What parameters are required to use this block?
The block requires an Airtable OAuth connection ID (connectionId), a base ID (e.g. appXXXXXX), a table ID (e.g. tblXXXXXX), and the record ID to fetch (e.g. recXXXXXX). You can optionally specify a destination variable name to store the result.
What does the block return when a record is found?
When a record is found, the block returns an object with three fields: id (the Airtable record ID as a string), fields (an object whose keys are field names and whose values are the corresponding field data), and createdTime (an ISO 8601 timestamp string).
What happens if the record ID does not exist in the table?
If no matching record is found, the block returns null for the record output.
What kinds of workflows commonly use this block?
This block is commonly used in workflows that receive a record ID from an external source — such as a form submission, webhook, or earlier workflow step — and need to retrieve the full record data before performing further processing, routing, or AI-based operations.
How is the fetched record made available to later workflow steps?
You can specify a destination variable name in the destinationVar field. The block stores the returned JSON result in that variable, making it accessible to downstream blocks in the workflow.
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 [Airtable] Get record to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.