Airtable programmatic icon

Airtable programmatic

Create and manage Airtable bases, tables, and fields programmatically
Join our community

Actions5

Overview

This node allows you to programmatically create and manage Airtable schema components such as bases, tables, and fields. Specifically, the "Table - Create" operation lets you create a new table within an existing Airtable base. You can optionally add initial fields to the table during creation.

This is useful when automating Airtable schema setup or dynamically managing your Airtable structure without manual intervention in the Airtable UI. For example, you might use this node to:

  • Automatically create new project tables in a shared base for each client.
  • Set up standardized tables with predefined fields as part of a deployment workflow.
  • Integrate Airtable schema changes into CI/CD pipelines or other automation systems.

Properties

Name Meaning
Base ID ID of the Airtable base where the new table will be created.
Table Name The name to assign to the newly created table.
Table Description Optional description text for the new table.
Include Initial Fields Boolean flag indicating whether to create initial fields along with the table.
Initial Fields Collection of fields to create initially if "Include Initial Fields" is true. Each field includes:
- Field Name: Name of the field.
- Field Type: Type of the field (e.g., Attachments, Barcode, Checkbox, Count, Created By, Created Time, Currency, Date, Date and Time, Duration, Email, Formula, Last Modified By, Last Modified Time, Link to Another Record, Long Text, Lookup, Multiple Select, Number, Percent, Phone Number, Rating, Rich Text, Rollup, Single Line Text, Single Select, URL).
- Description: Optional description of the field.

Output

The output JSON contains information about the created table. It typically includes the table's metadata such as its ID, name, description, and details about any fields created with it. This output can be used downstream in workflows to reference the new table or verify successful creation.

If initial fields are included, their creation results are also reflected in the output.

Dependencies

  • Requires an API key credential for Airtable Enterprise API access.
  • The node uses workspace and base IDs from Airtable to identify where to create tables.
  • Proper permissions on the Airtable account are necessary to create tables and fields.

Troubleshooting

  • Common issues:
    • Invalid or missing Base ID: Ensure the Base ID provided exists and is accessible with the API key.
    • Insufficient permissions: The API key must have rights to modify the base schema.
    • Incorrect field types or missing required field properties may cause errors during field creation.
  • Error messages:
    • Errors related to authentication usually indicate invalid or expired API credentials.
    • Validation errors on input parameters (e.g., missing table name) will prompt you to check required fields.
  • To resolve errors, verify all required inputs, confirm API credentials, and ensure the Airtable base and workspace IDs are correct.

Links and References

Discussion