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

Productivity Spreadsheets Databases Web del proveedor

Acciones

Triggers

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.