Airtable
Query and manage your Airtable bases directly from StackAI workflows.
What is Airtable?

https://www.stack-ai.com/dashboard/folder/68657ff180e85a21dc5691e8
The Airtable node in StackAI enables seamless integration with your Airtable workspaces. You can perform database queries, retrieve records, and automate data management tasks as part of your workflow automation.
How to use it?
Choose the action that you'd like to perform in Airtable (e.g., query, write).
Connect to Airtable by signing in to your account. The Airtable node requires a valid Airtable connection (API key or OAuth connection) to access your bases.
Fill out the parameters for the action that you'd like to take in Airtable by setting up the inputs and configurations.
The node can be connected to input nodes (for dynamic queries), LLM nodes (for natural language queries), or other action nodes for advanced automation.
Example of usage
Suppose you want to search for all records in an Airtable base where the "Status" field is "Open".
Connect an Input node to the Airtable node.
Set the action to "database_query_airtable".
Provide the base ID, table name, and filter formula as input parameters.
The output will be a list of matching records.
Available Actions and Triggers
1. Database Query Airtable
Description: Query an Airtable base using a structured query or natural language.
Inputs:
base_id (string, required): The unique identifier of your Airtable base.
Example:
"app1234567890"
table_name (string, required): The name of the table to query.
Example:
"Tasks"
filter_formula (string, optional): Airtable formula to filter records.
Example:
"Status = 'Open'"
fields (array of strings, optional): List of fields to return.
Example:
["Name", "Status", "Due Date"]
max_records (integer, optional): Maximum number of records to return.
Example:
100
view (string, optional): Name of the view to use for filtering/sorting.
Example:
"All Tasks"
Configurations:
connection_id (string, required): The connection ID for your Airtable account.
Example:
"your-connection-id"
Outputs:
records (array, required): List of records matching the query.
Each record includes field values and record ID.
Example:
[ { "id": "rec1234567890", "fields": { "Name": "Task 1", "Status": "Open", "Due Date": "2025-07-10" } } ]
2. Database Write Airtable
Description: Insert or update records in an Airtable base.
Inputs:
base_id (string, required): The unique identifier of your Airtable base.
Example:
"app1234567890"
table_name (string, required): The name of the table to write to.
Example:
"Tasks"
records (array of objects, required): List of records to insert or update.
Each object should include field names and values.
Example:
[ { "fields": { "Name": "New Task", "Status": "In Progress" } } ]
typecast (boolean, optional): Automatically convert field values to the correct type.
Example:
true
Configurations:
connection_id (string, required): The connection ID for your Airtable account.
Example:
"your-connection-id"
Outputs:
records (array, required): List of records that were created or updated.
Each record includes field values and record ID.
Example:
[ { "id": "rec0987654321", "fields": { "Name": "New Task", "Status": "In Progress" } } ]
Summary Table of Actions
Database Query Airtable
Query records from a base/table
base_id, table_name
connection_id
records
Database Write Airtable
Insert/update records in a table
base_id, table_name, records
connection_id
records
Last updated
Was this helpful?