Airtable
Automate database operations with Airtable and emma
With emma's Airtable integration, you can directly interact with the spreadsheet-style cloud database. Retrieve base/table schemas, perform CRUD operations on records, and automate filtering and searching through workflows.
Airtable Features
Schema Retrieval
Get base list and table structure/field definitions
Record Operations
Support for record get, create, update, and delete
Advanced Filtering
Filter, sort, and search using Airtable formula format
Features
Authentication Method
Airtable integration uses secure OAuth 2.0 authentication. No API key management required, and only necessary permissions are granted.
Airtable_Operator supports the following 9 tools:
| Category | Tools |
|---|---|
Schema Operations | 2 |
Record Retrieval | 3 |
Record Operations | 4 |
Main Parameters
| Parameter | Description |
|---|---|
| base_id | Airtable base ID (e.g., appXXXXXXXXXXXXXX) |
| table_id_or_name | Table ID or name |
| record_id | Record ID (e.g., recXXXXXXXXXXXXXX) |
| fields_json | Field data (JSON format) |
| filter_formula | Filter formula (Airtable formula format) |
| typecast | Enable automatic type conversion |
Filter Formula Examples
| Use Case | Formula |
|---|---|
| Equality comparison | {Status}='Done' |
| Multiple conditions (AND) | AND({Status}='Active', {Priority}='High') |
| Multiple conditions (OR) | OR({Status}='Todo', {Status}='In Progress') |
| Date comparison | IS_AFTER({Due Date}, TODAY()) |
| Not blank | {Email}!=BLANK() |
Prerequisites
- emma account
- Airtable account
- OAuth 2.0 connection setup
Setup
1. Create Airtable OAuth 2.0 App
Create an OAuth 2.0 app in Airtable Developer Hub (https://airtable.com/create/oauth) and configure required scopes (schema.bases:read, data.records:read, data.records:write).
2. Configure OAuth in emma
Start Airtable integration from emma's integration settings page and authorize access via OAuth.