[Airtable] Get table records
The Airtable Get Table Records block retrieves multiple records from a specified Airtable table, with support for optional pagination through a configurable record limit.
Fetch multiple records from an Airtable table
The Airtable Get Table Records block retrieves multiple records from a specified Airtable table, with support for optional pagination through a configurable record limit. To use it, you provide an Airtable OAuth connection ID, a base ID, and a table ID — these three parameters identify exactly which data to fetch. You can also set a limit on how many records to return, with a default of 100 and a maximum of 1000.
The block returns an array of records, where each record includes its Airtable record ID, a createdTime timestamp in ISO 8601 format, and a fields object containing all field values keyed by field name. You can choose to receive the output as either JSON or CSV text, and the result can be stored in a workflow variable for use in downstream steps.
This block fits naturally into workflows that need to read and process structured data from Airtable — for example, pulling a list of contacts to send through a messaging step, loading product inventory for an AI analysis block, or syncing records into another system. It works alongside other workflow blocks that consume tabular data, making it a straightforward way to bring Airtable content into an AI-powered workflow.
What you can build
Real-world workflows powered by the [Airtable] Get table records block.
Sync Contacts to CRM
Fetch a list of contacts stored in Airtable and pass them to a downstream block that updates or creates records in another CRM system.
Inventory Analysis with AI
Pull product inventory records from an Airtable table and feed them into an AI block to identify low-stock items or generate reorder recommendations.
Automated Report Generation
Retrieve project or task records from Airtable and use them as input for a block that formats and delivers a structured status report.
Batch Email Campaigns
Load a table of subscriber records from Airtable and route each entry through a messaging block to send personalized emails at scale.
Data Export to CSV
Fetch Airtable records in CSV output format and pass the resulting text to a file-writing or data-transfer block for downstream processing.
Content Pipeline Ingestion
Retrieve a table of content briefs or assets from Airtable to feed into an AI writing or classification block as part of a content production workflow.
Ready to add [Airtable] Get table records to your workflow?
Get Started FreeCommon questions about [Airtable] Get table records
What parameters are required to use this block?
The block requires three parameters: a connectionId (an active Airtable OAuth connection ID), a baseId (the ID of the Airtable base), and a tableId (the ID of the specific table to query). Without all three, the block cannot fetch records.
How many records can this block return?
The block returns up to 1000 records per request. The default limit is 100 records, but you can set the limit parameter to any value up to 1000 to retrieve more records in a single call.
What does the block return for each record?
Each record in the output array includes three fields: an id (the Airtable record ID), a fields object containing all field values keyed by field name, and a createdTime string in ISO 8601 format.
Can I get the output as CSV instead of JSON?
Yes. Setting the outputFormat parameter to 'csv' causes the variable specified in destinationVar to receive the data as CSV text. The default output format is JSON.
What kinds of workflows commonly use this block?
This block is commonly used in workflows that need to read structured data from Airtable before passing it to AI analysis blocks, messaging blocks, reporting blocks, or data-sync steps that write to other systems.
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 table records to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.