Airtable

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.

Usage overview

1. Choose the action that you'd like to perform in Airtable (query or write).

2. Establish a connection to Airtable by either signing in via the New Connection button or selecting an existing connection from the dropdown. The Airtable node requires a valid API key or OAuth connection to access your bases. Validate the connection is 'Healthy' with Test.

3. Fill out the parameters for the action that you'd like to take in Airtable by setting up the Inputs and Configurations (more details in dedicated sections below).

4. The node can be connected to input nodes (for dynamic queries), LLM nodes (for natural language queries), or other action nodes for advanced automation.

Available Actions and Triggers

1. Query Airtable

Description: Query an Airtable base using a structured query or natural language.

Inputs:

• Query (string, required):

  • The query is a plain English question or instruction that describes what data you want from the Airtable table. For example, you might write:

    • "Employees in the Marketing department"

    • "Employees hired after January 2024"

    • "Employees with the title 'Manager'"

Configurations:

• Base_id (string, required): The unique identifier of your Airtable base.

  • Example: app1234567890

  • You can locate this in the URL on your Airtable browser: https://airtable.com/app1234567890/tbl...

• Table (string, required): The name of the table to query.

  • Open your Airtable base.

  • Look at the tabs along the top (or left, depending on your layout). Each tab represents a table.

  • The table name is the label shown on each tab, e.g. Employees

  
• View (string, optional): Name of the view to use for filtering/sorting.

  • Open your Airtable base.

  • Navigate to the specific table you're working with.

  • At the top left of the table, next to the table name, you’ll see a dropdown with the current view name (e.g., Grid view , Kanban , Calendar ).

  • Click the dropdown to see all available views. The view you’re currently in is highlighted.

  
• AirtableSearchModeEnum (select, optional):

  • Determines how your query is interpreted and executed.

  • Formula mode ("formula"): Translates your natural language query into Airtable formula syntax—ideal for precise, rule-based filtering (e.g., your query may be “Find all employees in the Sales department”).

  • Semantic mode ("semantic"): Uses semantic search to find records by meaning, not exact wording—useful for broader, context-driven queries (e.g., your query may be “Show me people who work with customers”.)

• Max Records (integer, optional): Maximum number of records to return.

  • Example: 100

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:

    Copy

    [
      {
        "id": "rec1234567890",
        "fields": {
          "Name": "Task 1",
          "Status": "Open",
          "Due Date": "2025-07-10"
        }
      }
    ]
    

2. Write Airtable

Description:

Insert or update records in an Airtable base.

Inputs:

• Data (string, optional): Your intent in plain English, describing what record you want to create and what values to set for each field.

  • Examples:

    • Add an employee named Alice Johnson, email [email protected], department Engineering, and start date July 15, 2025.

    • Create a new product with name 'Widget X', price $99.99, and category 'Electronics'.

  • Tips

    • Be as specific as possible about the fields and values you want to set.

    • Use the field names as they appear in your Airtable table for best results.

    • You can add multiple fields in one sentence.

Configurations:

• Base Id (string, required): The unique identifier of your Airtable base.

  • Example: app1234567890

  • You can locate this in the URL on your Airtable browser: https://airtable.com/app1234567890/tbl...

• Table (string, required): The name of the table to query.

  • Open your Airtable base.

  • Look at the tabs along the top (or left, depending on your layout). Each tab represents a table.

  • The table name is the label shown on each tab, e.g. Employees

  
• View (string, optional): Expects either the name or the ID of a view in your Airtable table.

  • Open your Airtable base.

  • Navigate to the specific table you're working with.

  • At the top left of the table, next to the table name, you’ll see a dropdown with the current view name (e.g., Grid view , Kanban , Calendar ).

  • Click the dropdown to see all available views. The view you’re currently in is highlighted.

  

  • If you leave it blank, the default view (usually "Grid view") will be used.

  • Specifying a view can be useful if you want to restrict the write operation to records visible in that view

Outputs:

• records (array, required): List of records that were created or updated.

  • Each record includes field values and record ID.

  • Example:

    Copy

    [
      {
        "id": "rec0987654321",
        "fields": {
          "Name": "New Task",
          "Status": "In Progress"
        }
      }
    ]
    

Summary Table of Actions