Airtable é uma plataforma baseada em nuvem poderosa que combina a funcionalidade de um banco de dados com a simplicidade de uma planilha. Permite que os usuários criem bancos de dados flexíveis para organizar, armazenar e colaborar em informações.
Com o Airtable, você pode:
- Criar bancos de dados personalizados: Construa soluções sob medida para gerenciamento de projetos, calendários de conteúdo, rastreamento de inventário e muito mais
- Visualizar dados: Visualize suas informações como uma grade, quadro Kanban, calendário ou galeria
- Automatizar fluxos de trabalho: Configure gatilhos e ações para automatizar tarefas repetitivas
- Integrar com outras ferramentas: Conecte-se com centenas de outros aplicativos por meio de integrações nativas e APIs
Na Zoen, a integração com o Airtable permite que seus agentes interajam com suas bases do Airtable de forma programática. Isso permite operações de dados perfeitas, como recuperar informações, criar novos registros e atualizar dados existentes - tudo dentro dos fluxos de trabalho dos seus agentes. Use o Airtable como uma fonte de dados ou destino dinâmico para seus agentes, permitindo que eles acessem e manipulem informações estruturadas como parte de seus processos de tomada de decisão e execução de tarefas.
Integrates Airtable into the workflow. Can list bases, list tables (with schema), and create, get, list, update, upsert, or delete records. Can also be used in trigger mode to trigger a workflow when an update is made to an Airtable table.
List all bases the authenticated user has access to
| Parameter | Type | Required | Description |
|---|
offset | string | No | Pagination offset for retrieving additional bases |
| Parameter | Type | Description |
|---|
bases | array | Array of Airtable bases with id, name, and permissionLevel |
↳ id | string | Base ID (starts with "app") |
↳ name | string | Base name |
↳ permissionLevel | string | Permission level (none, read, comment, edit, create) |
metadata | json | Pagination and count metadata |
↳ offset | string | Offset for next page of results |
↳ totalBases | number | Number of bases returned |
List all tables and their schema in an Airtable base
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
| Parameter | Type | Description |
|---|
tables | array | List of tables in the base with their schema |
↳ id | string | Table ID (starts with "tbl") |
↳ name | string | Table name |
↳ description | string | Table description |
↳ primaryFieldId | string | ID of the primary field |
↳ fields | array | List of fields in the table |
↳ id | string | Field ID (starts with "fld") |
↳ name | string | Field name |
↳ type | string | Field type (singleLineText, multilineText, number, checkbox, singleSelect, multipleSelects, date, dateTime, attachment, linkedRecord, etc.) |
↳ description | string | Field description |
↳ options | json | Field-specific options (choices, etc.) |
metadata | json | Base info and count metadata |
↳ baseId | string | The base ID queried |
↳ totalTables | number | Number of tables in the base |
Read records from an Airtable table
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
maxRecords | number | No | Maximum number of records to return (default: all records) |
filterFormula | string | No | Formula to filter records (e.g., "({Field Name} = 'Value')") |
| Parameter | Type | Description |
|---|
records | array | Array of retrieved Airtable records |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata including pagination offset and total records count |
↳ offset | string | Pagination offset for next page |
↳ totalRecords | number | Number of records returned |
Retrieve a single record from an Airtable table by its ID
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
recordId | string | Yes | Record ID to retrieve (starts with "rec", e.g., "recXXXXXXXXXXXXXX") |
| Parameter | Type | Description |
|---|
record | json | Retrieved Airtable record |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records returned (always 1) |
Write new records to an Airtable table
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
records | json | Yes | Array of records to create, each with a fields object |
typecast | boolean | No | When true, Airtable automatically converts string values to the field type |
| Parameter | Type | Description |
|---|
records | array | Array of created Airtable records |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records created |
Update an existing record in an Airtable table by ID
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
recordId | string | Yes | Record ID to update (starts with "rec", e.g., "recXXXXXXXXXXXXXX") |
fields | json | Yes | An object containing the field names and their new values |
typecast | boolean | No | When true, Airtable automatically converts string values to the field type |
| Parameter | Type | Description |
|---|
record | json | Updated Airtable record |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records updated (always 1) |
↳ updatedFields | array | List of field names that were updated |
Update multiple existing records in an Airtable table
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
records | json | Yes | Array of records to update, each with an id and a fields object |
typecast | boolean | No | When true, Airtable automatically converts string values to the field type |
| Parameter | Type | Description |
|---|
records | array | Array of updated Airtable records |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records updated |
↳ updatedRecordIds | array | List of updated record IDs |
Update existing records or create new ones in an Airtable table, matching on the specified merge fields
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
records | json | Yes | Array of records to upsert, each with a fields object |
fieldsToMergeOn | json | Yes | Array of field names used to match existing records (max 3). A record is updated when all merge fields match, otherwise it is created. Example: ["Name"] |
typecast | boolean | No | When true, Airtable automatically converts string values to the field type |
| Parameter | Type | Description |
|---|
records | array | Array of upserted Airtable records |
↳ id | string | Record ID |
↳ createdTime | string | Record creation timestamp |
↳ fields | json | Record field values |
createdRecords | array | IDs of records that were created |
updatedRecords | array | IDs of records that were updated |
metadata | json | Operation metadata |
↳ recordCount | number | Total number of records returned |
↳ createdCount | number | Number of records created |
↳ updatedCount | number | Number of records updated |
Delete one or more records from an Airtable table by ID
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
tableId | string | Yes | Table ID (starts with "tbl") or table name |
recordIds | json | Yes | Array of record IDs to delete (each starts with "rec", e.g., ["recXXXXXXXXXXXXXX"]). Pass a single-element array to delete one record. |
| Parameter | Type | Description |
|---|
records | array | Array of deleted Airtable records |
↳ id | string | Record ID |
↳ deleted | boolean | Whether the record was deleted |
metadata | json | Operation metadata |
↳ recordCount | number | Number of records deleted |
↳ deletedRecordIds | array | List of deleted record IDs |
Get the schema of all tables, fields, and views in an Airtable base
| Parameter | Type | Required | Description |
|---|
baseId | string | Yes | Airtable base ID (starts with "app", e.g., "appXXXXXXXXXXXXXX") |
| Parameter | Type | Description |
|---|
tables | json | Array of table schemas with fields and views |
metadata | json | Operation metadata including total tables count |
A Trigger is a block that starts a workflow when an event happens in this service.
Trigger workflow from Airtable record changes like create, update, and delete events (requires Airtable credentials)
| Parameter | Type | Required | Description |
|---|
triggerCredentials | string | Yes | This trigger requires airtable credentials to access your account. |
baseId | string | Yes | The ID of the Airtable Base this webhook will monitor. |
tableId | string | Yes | The ID of the table within the Base that the webhook will monitor. |
includeCellValues | boolean | No | Enable to receive the complete record data in the payload, not just changes. |
| Parameter | Type | Description |
|---|
payloads | array | The payloads of the Airtable changes |
↳ timestamp | string | Timestamp of the change |
↳ baseTransactionNumber | number | Transaction number |
latestPayload | object | The most recent payload from Airtable |
↳ timestamp | string | ISO 8601 timestamp of the change |
↳ baseTransactionNumber | number | Transaction number |
↳ payloadFormat | string | Payload format version (e.g., v0) |
↳ actionMetadata | object | Metadata about who made the change |
↳ source | string | Source of the change (e.g., client, publicApi) |
↳ sourceMetadata | object | Source metadata including user info |
↳ user | object | User who made the change |
↳ id | string | User ID |
↳ email | string | User email |
↳ name | string | User name |
↳ permissionLevel | string | User permission level |
↳ changedTablesById | object | Tables that were changed (keyed by table ID) |
↳ changedRecordsById | object | Changed records keyed by record ID |
↳ current | object | Current state of the record |
↳ cellValuesByFieldId | object | Cell values keyed by field ID |
↳ createdRecordsById | object | Created records by ID |
↳ destroyedRecordIds | array | Array of destroyed record IDs |
airtableChanges | array | Changes made to the Airtable table |
↳ tableId | string | Table ID |
↳ recordId | string | Record ID |
↳ changeType | string | Type of change (created, changed, destroyed) |
↳ cellValuesByFieldId | object | Cell values by field ID |