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

Action Name
Description
Required Inputs
Required Configurations
Outputs

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?