Airtable

Airtable is a cloud-based database platform that combines the simplicity of a spreadsheet with the power of a database. Through Langdock’s integration, you can manage records, schemas, and bases directly from your conversations.

Authentication: OAuth Category: Productivity & Collaboration Availability: All workspace plans

Available Actions

List Bases

airtable.listBases

Lists all available bases in your Airtable workspace. Requires Confirmation: No

Parameters: None

Example Response:

// JSON example removed for MDX compatibility

---

Get Base Schema

airtable.getBaseSchema

Returns the complete schema of tables in the specified base, including field types and relationships. Requires Confirmation: No

Parameters:

• baseId (string, required): The unique identifier of the base

Example Usage:

“Get the schema for base appXXXXXXXXXXXXXX”

Example Response:

// JSON example removed for MDX compatibility

---

Find Records

airtable.findRecords

Searches for records in a table with optional filtering. Requires Confirmation: No

Parameters:

• baseId (string, required): The unique identifier of the base

• tableIdOrName (string, required): The table ID or name

• filterByFormula (string, optional): Airtable formula to filter records

• maxRecords (number, optional): Maximum number of records to return

Filter Formula Examples:

• Status equals ‘Active’: "Status = 'Active'"

• Age greater than 25: "Age > 25"

• Date after specific date: "IS_AFTER(CreatedDate, '2023-01-01')"

• Text search: "FIND('urgent', Description)"

• Multiple conditions: "AND(Status = 'Active', Priority = 'High')"

• Check non-empty field: "NOT({Email} = '')"

Example Usage:

“Find all active products in the Products table where price is greater than 100”

---

Create Records

airtable.createRecords

Creates new records in a specified table. Requires Confirmation: Yes

Parameters:

• baseId (string, required): The unique identifier of the base

• tableIdOrName (string, required): The table ID or name

• records (object, required): The records to create

Example Request:

// JSON example removed for MDX compatibility

Example Usage:

“Create a new product called ‘Premium Widget’ with price $199.99 in the Products table”

---

Update Records

airtable.updateRecords

Updates existing records in a table. Requires Confirmation: Yes

Parameters:

• baseId (string, required): The unique identifier of the base

• tableIdOrName (string, required): The table ID or name

• recordId (string, required): The unique identifier of the record to update

• records (object, required): The fields to update

Example Request:

// JSON example removed for MDX compatibility

Example Usage:

“Update the price of product recXXXXXXXXXXXXXX to $149.99 and set status to Sale”

---

Delete Record

airtable.deleteRecord

Deletes a specified record from a table. Requires Confirmation: Yes

Parameters:

• baseId (string, required): The unique identifier of the base

• tableIdOrName (string, required): The table ID or name

• recordId (string, required): The unique identifier of the record to delete

Example Usage:

“Delete record recXXXXXXXXXXXXXX from the Products table”

Common Use Cases

Database Management

• Create and update product catalogs

• Manage inventory records

• Track project tasks and milestones

CRM Operations

• Add new customer records

• Update contact information

• Search for customer data

Content Management

• Organize content calendars

• Track publication status

• Manage editorial workflows

Data Analysis

• Filter records by criteria

• Export specific data sets

• Generate reports from bases

Best Practices

Performance Tips:

• Use maxRecords parameter to limit large result sets

• Prefer table IDs over names for better reliability

• Use filter formulas to reduce data transfer

• Batch create/update operations when possible

Important Considerations:

• Record IDs are permanent and cannot be reused after deletion

• Base and table IDs are more reliable than names

• Filter formulas are case-sensitive

• API rate limits apply (5 requests per second per base)

Workflow Examples

Example 1: Product Inventory Update

1

Identify inventory base

List all bases to find your inventory base.

2

Inspect table structure

Get the base schema to understand table structure.

3

Find low-stock products

Find products with low stock using filterByFormula.

4

Update stock levels

Update stock levels for specific products.

5

Add incoming products

Create records for new incoming products.

Example 2: Customer Data Search

1

Connect to customer base

Connect to customer database base.

2

Search customers

Search for customers by email or name.

3

Update customer info

Update customer status or information.

4

Add notes or tags

Add notes or tags to customer records.

Troubleshooting

Issue	Solution
"Base not found"	Verify the base ID using List Bases action
"Invalid formula"	Check formula syntax and field names
"Permission denied"	Ensure OAuth token has necessary permissions
"Rate limit exceeded"	Implement delays between requests

Related Integrations

• Google Sheets - For simpler spreadsheet operations

• Notion - For wiki-style databases

• Excel - For advanced spreadsheet analysis

Support

For additional help with the Airtable integration, contact [email protected]