NAiOS IconNAiOS Logo
Contacto
Volver al catálogo

Airtable

airtable

Airtable merges spreadsheet functionality with database power, enabling teams to organize projects, track tasks, and collaborate through customizable views, automation, and integrations for data management

ProductivitySpreadsheetsDatabasesWeb del proveedor
Acciones
17
Triggers
6
Autenticación
—
OAuth gestionado
Sí
Información técnica: el detalle de parámetros, schemas y triggers de esta página está pensado para equipos de integración. Si solo necesitas saber si tu herramienta favorita está disponible, basta con ver la lista de acciones.

Acciones disponibles (17)

Cada acción es una operación que el agente puede ejecutar contra este conector. Haz clic en una acción para ver sus parámetros.

Create baseAIRTABLE_CREATE_BASEAcción

Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.

Parámetros de entrada

  • namestringObligatorio

    Name for the new Airtable base, visible in the UI.

  • tablesobject[]Obligatorio

    Configurations for tables to be created in the new base; each table needs 'name' and 'fields'.

  • workspaceIdstringObligatorio

    Unique ID of the Airtable workspace (e.g., 'wspXXXXXXXXXXXXXX') for base creation.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create CommentAIRTABLE_CREATE_COMMENTAcción

Creates a new comment on a specific record within an airtable base and table.

Parámetros de entrada

  • textstringObligatorio

    The content of the comment. To mention a user, use the format @[userId] (e.g., @[usrGISFlfA7l5F7kY6]).

  • baseIdstringObligatorio

    The unique identifier of the Airtable base. This typically starts with 'app'.

  • recordIdstringObligatorio

    The unique identifier of the record on which the comment will be created. This typically starts with 'rec'.

  • tableIdOrNamestringObligatorio

    The unique identifier (typically starting with 'tbl') or the name of the table within the base.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create FieldAIRTABLE_CREATE_FIELDAcción

Creates a new field within a specified table in an airtable base.

Parámetros de entrada

  • namestringObligatorio

    The name for the new field. Field names must be unique within a table.

  • typestring

    The type for the new field. If not provided, it defaults to 'singleLineText'. Supported types include 'singleLineText', 'multilineText', 'richText', 'singleSelect', 'multipleSelects', 'checkbox', 'number', 'percent', 'currency', 'date', 'dateTime', 'duration', 'phoneNumber', 'email', 'url', 'attachment', 'formula', 'rollup', 'count', 'lookup', 'multipleLookupValues', 'autonumber', 'barcode', 'rating', 'button', 'createdBy', 'createdTime', 'lastModifiedBy', 'lastModifiedTime', and 'externalSyncSource'.

  • baseIdstringObligatorio

    The unique identifier of the base where the field will be created.

  • optionsobject

    Optional type-specific configuration for the new field. The structure of this object depends on the 'type' chosen. For example, for a 'singleSelect' or 'multipleSelects' field, 'options' would include a 'choices' array. For a 'number' field, 'options' could include 'precision'. For a 'date' or 'dateTime' field, 'options' could include 'dateFormat' or 'timeFormat'. Consult the Airtable API documentation for specific options available for each field type.

  • tableIdstringObligatorio

    The unique identifier of the table within the base where the field will be created.

  • descriptionstring

    An optional description for the new field. This can provide context or instructions for the field's usage.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create multiple recordsAIRTABLE_CREATE_MULTIPLE_RECORDSAcción

Creates multiple new records in a specified airtable table.

Parámetros de entrada

  • baseIdstringObligatorio

    Identifier of the Airtable base.

  • recordsobject[]Obligatorio

    List of new records, typically up to 10 per request. Each record object must have a `fields` key, mapping case-sensitive field names to values that align with Airtable field data types.

  • tableIdOrNamestringObligatorio

    Identifier or name of the table for record creation.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create a recordAIRTABLE_CREATE_RECORDAcción

Creates a new record in a specified airtable table; field values must conform to the table's column types.

Parámetros de entrada

  • baseIdstringObligatorio

    The unique identifier of the Airtable base.

  • fieldsobjectObligatorio

    A dictionary of field names (or IDs) and their values for the new record. Ensure values conform to the target table's field types.

  • tableIdOrNamestringObligatorio

    The unique identifier or name of the table.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create tableAIRTABLE_CREATE_TABLEAcción

Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.

Parámetros de entrada

  • namestringObligatorio

    The desired name for the new table.

  • baseIdstringObligatorio

    The unique identifier of the base where the new table will be created.

  • fieldsobject[]Obligatorio

    A list of field configurations for the new table. Each configuration defines a column and must include a 'name' (string) and 'type' (string, e.g., 'singleLineText', 'number', 'date'). Some field types may also require an 'options' object for further configuration (e.g., 'choices' for 'singleSelect' or 'multipleSelects' types).

  • descriptionstring

    An optional textual description for the new table.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Delete CommentAIRTABLE_DELETE_COMMENTAcción

Deletes an existing comment from a specified record in an airtable table.

Parámetros de entrada

  • baseIdstringObligatorio

    The unique identifier of the Airtable base from which the comment will be deleted.

  • recordIdstringObligatorio

    The unique identifier of the record within the specified table from which the comment will be deleted.

  • rowCommentIdstringObligatorio

    The unique identifier of the comment to be deleted from the specified record.

  • tableIdOrNamestringObligatorio

    The unique identifier (ID) or name of the table within the specified base that contains the record and comment.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Delete multiple recordsAIRTABLE_DELETE_MULTIPLE_RECORDSAcción

Deletes up to 10 specified records from a table within an airtable base.

Parámetros de entrada

  • baseIdstringObligatorio

    The unique identifier of the Airtable base containing the records to be deleted.

  • recordIdsstring[]Obligatorio

    A list of unique identifiers for the records to be deleted.

  • tableIdOrNamestringObligatorio

    The unique identifier (e.g., 'tbluIzIsxPIM2V3Y4') or the name (e.g., 'Marketing Leads') of the table within the base from which records will be deleted.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Delete RecordAIRTABLE_DELETE_RECORDAcción

Permanently deletes a specific record from an existing table within an existing airtable base.

Parámetros de entrada

  • baseIdstringObligatorio

    Unique identifier of the Airtable base, typically starting with 'app'.

  • recordIdstringObligatorio

    Unique identifier of the record to be deleted, typically starting with 'rec'.

  • tableIdOrNamestringObligatorio

    Unique identifier (typically starting with 'tbl') or name of the table within the specified base.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Base SchemaAIRTABLE_GET_BASE_SCHEMAAcción

Retrieves the detailed schema for a specified airtable base, including its tables, fields, field types, and configurations, using the `baseid`.

Parámetros de entrada

  • baseIdstringObligatorio

    The unique identifier for the Airtable base. This ID typically starts with 'app' and is followed by a string of alphanumeric characters. It can be found in the URL when viewing the base.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get RecordAIRTABLE_GET_RECORDAcción

Retrieves a specific record from a table within an airtable base.

Parámetros de entrada

  • baseIdstringObligatorio

    ID of the Airtable base.

  • recordIdstringObligatorio

    ID of the record to retrieve.

  • cellFormatstringenum

    Controls cell value formatting: 'json' for native types, 'string' for all values as strings.

    jsonstring
  • tableIdOrNamestringObligatorio

    ID or name of the table.

  • returnFieldsByFieldIdboolean

    If true, field keys in the response are field IDs; otherwise, field names.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get user informationAIRTABLE_GET_USER_INFOAcción

Retrieves information, such as id and permission scopes, for the currently authenticated airtable user from the `/meta/whoami` endpoint.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List basesAIRTABLE_LIST_BASESAcción

Retrieves all airtable bases accessible to the authenticated user, which may include an 'offset' for pagination.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List CommentsAIRTABLE_LIST_COMMENTSAcción

Retrieves all comments for a specific record in an airtable table, requiring existing `baseid`, `tableidorname`, and `recordid`.

Parámetros de entrada

  • baseIdstringObligatorio

    The unique identifier of the Airtable base from which to list comments.

  • recordIdstringObligatorio

    The unique identifier of the record for which comments are to be listed.

  • tableIdOrNamestringObligatorio

    The unique identifier or name of the table within the specified base containing the record.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List recordsAIRTABLE_LIST_RECORDSAcción

Retrieves records from an airtable table, with options for filtering, sorting, pagination, and specifying returned fields.

Parámetros de entrada

  • sortobject[]

    A list of sort objects to apply to the records. Records are sorted by the first sort object, then by the second, and so on. If not specified, records are returned in the order they appear in the table or view.

  • viewstring

    The name or ID of an existing view in the table. If specified, records will be returned according to the sort order and filters of this view.

  • baseIdstringObligatorio

    The ID of the Airtable base.

  • fieldsstring[]

    An array of field names or IDs to include in the response. If empty, all fields are returned. Cannot be used with `returnFieldsByFieldId` when that is true.

  • offsetstring

    The opaque offset for pagination, used to retrieve the next page of records. This value is provided in the previous response.

  • pageSizeinteger

    The number of records to return per page. Must be between 1 and 100, inclusive. Defaults to 100.

  • timeZonestringenum

    The time zone to use for formatting date and time fields. Defaults to UTC. This affects how formulas like CREATED_TIME() are computed.

    utcclientAfrica/AbidjanAfrica/AccraAfrica/Addis_AbabaAfrica/AlgiersAfrica/AsmaraAfrica/BamakoAfrica/BanguiAfrica/BanjulAfrica/BissauAfrica/Blantyre+420
  • cellFormatstringenum

    Specifies how cell values are returned. 'json' returns rich structured JSON values, while 'string' returns simple string representations. Defaults to 'json'.

    jsonstring
  • maxRecordsinteger

    The maximum total number of records to return. If not specified, all records matching the query will be returned, up to Airtable's limits.

  • userLocalestring

    The user locale to use for formatting cell values. For example, 'en-US' or 'fr-FR'. This affects how values like dates and numbers are displayed. This field is required when `cellFormat` is set to 'string'.

  • tableIdOrNamestringObligatorio

    The ID or name of the table within the base.

  • recordMetadatastring[]

    An array of strings specifying which record metadata to include. Currently, the only supported value is 'commentCount'.

  • filterByFormulastring

    A formula used to filter records. The formula follows Airtable's formula syntax. Only records for which the formula evaluates to true will be returned.

  • returnFieldsByFieldIdboolean

    If true, field names in the response will be field IDs instead of field names. This is useful if you need stable field identifiers, as field names can change.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update multiple recordsAIRTABLE_UPDATE_MULTIPLE_RECORDSAcción

Updates multiple existing records in a specified airtable table; these updates are not performed atomically.

Parámetros de entrada

  • baseIdstringObligatorio

    The ID of the Airtable base containing the table.

  • recordsobject[]Obligatorio

    List of records to be updated. A maximum of 10 records can be updated per request.

  • tableIdOrNamestringObligatorio

    The ID or name of the table within the base where records will be updated.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update recordAIRTABLE_UPDATE_RECORDAcción

Modifies specified fields of an existing record in an airtable base and table; the base, table, and record must exist.

Parámetros de entrada

  • baseIdstringObligatorio

    The unique identifier of the Airtable base containing the record to be updated.

  • fieldsobjectObligatorio

    Specifies fields to update. Keys are field names or IDs; values are new content. Only included fields are modified; others remain unchanged.

  • recordIdstringObligatorio

    The unique identifier (ID) of the record to be updated within the specified table.

  • tableIdOrNamestringObligatorio

    The unique identifier (ID) or the name of the table within the base that contains the record to be updated.

  • returnFieldsByFieldIdboolean

    If `True`, API response keys record fields by field ID instead of name. Using field IDs is recommended for integrations resilient to field name changes.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Triggers (6)

Los triggers son eventos externos que pueden iniciar un flujo en tus agentes (ej: nuevo email, mensaje recibido, registro creado).

Base Metadata ChangedAIRTABLE_BASE_METADATA_CHANGED_TRIGGERTrigger

Triggers when an existing Airtable base changes its name or permission level.

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

Payload del evento

  • base_idstringObligatorio

    The unique identifier of the base.

  • change_typestringObligatorio

    Type of metadata change: name_changed, permission_changed, or both_changed.

  • event_typestring

    Type of event that occurred.

  • new_metadataobjectObligatorio

    Current metadata for the base after the change.

  • old_metadataobject

    Snapshot of the Airtable base metadata we track.

Instrucciones

**Instructions for Setting Up the Trigger:** - This trigger monitors Airtable bases accessible to the connected account. - It detects changes to existing base metadata, specifically the base name and permission level. - On the first poll, the trigger initializes its snapshot and emits no events. - Subsequent polls compare the current snapshot against the previous one and emit only real metadata changes.

Base Schema ChangedAIRTABLE_BASE_SCHEMA_CHANGED_TRIGGERTrigger

Triggers when tables, fields, or views change in an Airtable base.

Configuración

  • baseIdstringObligatorio

    Unique identifier of the Airtable base to monitor.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

Payload del evento

  • change_typestringObligatorio

    Type of schema change: table_added, table_deleted, table_modified, field_added, field_deleted, field_modified, view_added, view_deleted, or view_modified.

  • detailsobject

    Additional change details, including old and new snapshots.

  • event_typestring

    Type of event that occurred.

  • item_idstring

    Unique identifier of the affected field or view, if applicable.

  • item_namestring

    Display name of the affected field or view, if applicable.

  • table_idstringObligatorio

    Unique identifier of the affected table.

  • table_namestringObligatorio

    Display name of the affected table.

Instrucciones

**Instructions for Setting Up the Trigger:** - Provide the Airtable base ID you want to monitor. - On the first poll, the trigger records the current table, field, and view schema and emits no events. - Subsequent polls detect table additions/deletions, table metadata changes, and field/view additions, deletions, and modifications.

User Profile ChangedAIRTABLE_USER_PROFILE_CHANGED_TRIGGERTrigger

Triggers when the connected Airtable user's profile information changes.

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

Payload del evento

  • changed_fieldsobjectObligatorio

    Dictionary describing the old and new value for each changed field.

  • event_typestring

    Type of event that occurred.

  • user_idstringObligatorio

    Unique identifier of the user.

Instrucciones

**Instructions for Setting Up the Trigger:** - This trigger monitors the connected Airtable user's profile information. - It detects changes to the user ID, email address, and granted OAuth scopes. - On the first poll, the trigger records the current profile and emits no events. - Subsequent polls compare the latest profile snapshot against the previous one.

View CreatedAIRTABLE_VIEW_CREATED_TRIGGERTrigger

Triggers when a new view is created in an Airtable base.

Configuración

  • baseIdstringObligatorio

    Unique identifier of the Airtable base to monitor.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • tableIdstring

    Optional Airtable table ID. If provided, only this table is monitored.

Payload del evento

  • base_idstringObligatorio

    Base ID that owns the table.

  • event_typestring

    Type of event that occurred.

  • tableobjectObligatorio

    Table that owns the new view.

  • viewobjectObligatorio

    The newly created Airtable view.

Instrucciones

**Instructions for Setting Up the Trigger:** - Provide the Airtable base ID you want to monitor. - Optionally provide a table ID to limit monitoring to a single table. - On the first poll, the trigger records the current view IDs and emits no events. - Subsequent polls emit events for views that did not exist in the previous snapshot.

View DeletedAIRTABLE_VIEW_DELETED_TRIGGERTrigger

Triggers when a previously known Airtable view is deleted.

Configuración

  • baseIdstringObligatorio

    Unique identifier of the Airtable base to monitor.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

Payload del evento

  • event_typestring

    Type of event that occurred.

  • viewobjectObligatorio

    Metadata of the deleted view.

Instrucciones

**Instructions for Setting Up the Trigger:** - Provide the Airtable base ID you want to monitor. - On the first poll, the trigger records the current set of views and emits no events. - Subsequent polls compare the current snapshot against the previous one and emit deleted views.

View Metadata ChangedAIRTABLE_VIEW_METADATA_CHANGED_TRIGGERTrigger

Triggers when an Airtable view changes its name or type.

Configuración

  • baseIdstringObligatorio

    Unique identifier of the Airtable base to monitor.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • tableIdstring

    Optional Airtable table ID. If provided, only this table is monitored.

Payload del evento

  • base_idstringObligatorio

    Base containing the changed view.

  • changesobjectObligatorio

    Dictionary describing the old and new value for each changed field.

  • event_typestring

    Type of event that occurred.

  • new_metadataobjectObligatorio

    Current metadata for the changed view.

  • old_metadataobject

    Basic view metadata used for snapshot diffing.

  • tableobjectObligatorio

    Table containing the changed view.

  • view_idstringObligatorio

    Unique identifier of the changed view.

Instrucciones

**Instructions for Setting Up the Trigger:** - Provide the Airtable base ID you want to monitor. - Optionally provide a table ID to limit monitoring to a single table. - This trigger monitors existing views for name or type changes. - New views and deleted views are ignored by this trigger and should be handled by dedicated create/delete triggers.