Skip to main content

​
Overview

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. List all bases to find your inventory base
2. Get the base schema to understand table structure
3. Find products with low stock using filterByFormula
4. Update stock levels for specific products
5. Create records for new incoming products

1. Connect to customer database base
2. Search for customers by email or name
3. Update customer status or information
4. Add notes or tags to customer records

​
Troubleshooting

IssueSolution
”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
  • 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 support@langdock.com