Skip to main content

​
Overview

What it does

Airtable integration connects AI tools directly to your Airtable bases, enabling natural language interactions with bases, tables, records, views, and automations.Key Features:
  • List and access bases
  • Create, read, update, and delete records
  • Manage tables and fields
  • Work with views and filters
  • Query data with complex filters
  • Batch operations
  • Attachment handling
  • Field type support (text, number, date, attachments, etc.)

Use Cases

Data Management:
  • Automatically add records from external sources
  • Update records based on triggers or schedules
  • Sync data between Airtable and other systems
  • Archive or delete outdated records
Workflow Automation:
  • Create project tracking from emails
  • Generate reports from Airtable data
  • Send notifications for record updates
  • Build custom approval workflows
Integration Workflows:
  • Import customer data from forms
  • Create CRM entries from various sources
  • Generate invoices from Airtable records
  • Export data to analytics platforms

​
Quick Start

1

Connect Your Airtable Account

NimbleBrain Studio uses OAuth2 to securely connect to your Airtable account.
  1. Navigate to Connections in the sidebar
  2. Click Browse Catalog
  3. Search for “Airtable”
  4. Click Install
  5. Click Connect and authorize with your Airtable account
  6. Grant the requested permissions for Airtable access
OAuth2 provides secure, token-based authentication. You’ll need to authorize access to your Airtable bases.
2

Verify Connection

Once connected, test the integration:
"List all my Airtable bases"
Other test prompts:
  • “Show me the tables in my Marketing base”
  • “Get the first 10 records from my Contacts table”
  • “What fields are in my Projects table?”

​
Available Tools

The Airtable connection provides comprehensive tools for managing your bases and records:

​
Base Management

List and access your Airtable bases.
ToolDescription
AIRTABLE_LIST_BASESRetrieve all bases you have access to with metadata
AIRTABLE_GET_BASE_SCHEMAGet the complete schema of a base including all tables and fields
AIRTABLE_LIST_TABLESList all tables within a specific base
Example Usage:
"Show me all my Airtable bases and their IDs"
Base IDs and table names are required for most operations. Use these tools to discover them.

​
Record Operations

Create, read, update, and delete records in your tables.
ToolDescription
AIRTABLE_LIST_RECORDSRetrieve records with filtering, sorting, and pagination
AIRTABLE_GET_RECORDGet a specific record by ID with all field values
AIRTABLE_CREATE_RECORDCreate a new record with specified field values
AIRTABLE_UPDATE_RECORDUpdate an existing record (partial or complete)
AIRTABLE_DELETE_RECORDPermanently delete a record
AIRTABLE_BATCH_CREATE_RECORDSCreate multiple records in a single operation
AIRTABLE_BATCH_UPDATE_RECORDSUpdate multiple records simultaneously
AIRTABLE_BATCH_DELETE_RECORDSDelete multiple records at once
Example Usage:
"Create a new record in my Contacts table with name 'John Doe' and email '[email protected]'"
Use batch operations for better performance when working with multiple records.

​
Field & Table Operations

Manage table structures and field definitions.
ToolDescription
AIRTABLE_LIST_FIELDSGet all fields in a table with their types and properties
AIRTABLE_CREATE_FIELDAdd a new field to a table with specified type
AIRTABLE_UPDATE_FIELDModify field properties (name, description, options)
AIRTABLE_CREATE_TABLECreate a new table in a base
Example Usage:
"Add a new 'Status' field to my Projects table with options: To Do, In Progress, Done"
Schema changes affect the entire table. Ensure changes are intentional and won’t break existing workflows.

​
Views & Filtering

Work with views and apply filters to records.
ToolDescription
AIRTABLE_LIST_VIEWSGet all views in a table
AIRTABLE_QUERY_RECORDSQuery records with advanced filter formulas
AIRTABLE_SORT_RECORDSRetrieve records with custom sorting
Example Usage:
"Get all records from my Tasks table where Status is 'In Progress' and Priority is 'High'"
Airtable uses a formula syntax for filtering. The integration handles common filter patterns automatically.

​
Example Workflows

Scenario: Add new contacts from form submissions to AirtablePrompt:
"Create a new contact in my CRM base with name 'Sarah Johnson', email '[email protected]', company 'Acme Corp', and status 'Lead'"
What happens:
  • Creates a new record in the Contacts table
  • Populates all specified fields
  • Returns the created record with its ID

​
Authentication

OAuth2 Authentication: This connection uses OAuth2 for secure authentication.

​
How It Works

When you connect Airtable in NimbleBrain Studio:
  1. You’ll be redirected to Airtable’s authorization page
  2. Log in with your Airtable account
  3. Review and grant permissions
  4. You’re automatically redirected back to Studio

​
Required Scopes

The integration requests the following Airtable scopes: Data Scopes:
  • data.records:read - Read records from bases
  • data.records:write - Create, update, and delete records
  • schema.bases:read - Read base and table schemas
  • schema.bases:write - Create and modify tables and fields
Workspace Scopes:
  • workspace.bases:read - List all accessible bases
  • workspace.bases:write - Create new bases (optional)
You can manage connected apps in your Airtable account under Account → Connected apps.

​
Rate Limits

Airtable API enforces rate limits:
Limit TypeRestriction
Requests per second5 requests/second per base
Records per request10 records max (create/update)
Records in response100 records max per page
Field limit500 fields per table
Attachment size20MB per file
Best Practices:
  • Use batch operations to minimize request count
  • Implement pagination for large datasets
  • Cache schema information when possible
  • Respect rate limits to avoid throttling
Studio automatically handles rate limiting with exponential backoff for retries.

​
Troubleshooting

Issue: OAuth authorization didn’t completeSolutions:
  • Ensure you’re logged into the correct Airtable account
  • Try a different browser or incognito mode
  • Check popup blockers aren’t interfering
  • Verify your Airtable account is active
  • For Enterprise accounts, check workspace admin policies
Issue: Insufficient privileges errorSolutions:
  • Reconnect to grant additional scopes
  • Verify you have access to the specific base
  • For shared bases, ensure you have edit permissions
  • Check workspace-level permissions
  • Confirm base isn’t locked or read-only
Issue: Cannot find specified base or tableSolutions:
  • Verify base ID is correct (use LIST_BASES)
  • Check table name spelling and case sensitivity
  • Base may have been deleted or access revoked
  • Ensure base is in a workspace you have access to
Issue: Cannot create or update recordSolutions:
  • Verify all required fields are provided
  • Check field names match exactly (case-sensitive)
  • Ensure field values match expected types
  • Validate data against field constraints
  • Check for duplicate values in unique fields
Issue: Field type errorSolutions:
  • Verify field type (text, number, date, select, etc.)
  • Format dates correctly (ISO 8601 format)
  • For select fields, use exact option values
  • For linked records, use record IDs
  • Check field configuration for constraints
Issue: Too many requests errorSolutions:
  • Wait for rate limit to reset (1 second)
  • Reduce request frequency
  • Use batch operations to combine requests
  • Studio automatically handles retries
  • Consider caching frequently accessed data
Issue: Cannot upload attachmentsSolutions:
  • Check file size is under 20MB
  • Verify file URL is publicly accessible
  • Ensure attachment field exists in table
  • Use proper attachment format (array of objects)
  • Check network connectivity for upload

​
Best Practices

Data Organization

  • Use consistent naming conventions
  • Create views for common queries
  • Link related tables appropriately
  • Document field purposes in descriptions
  • Keep table schemas organized

Performance

  • Use batch operations for multiple records
  • Implement pagination for large datasets
  • Filter records server-side, not client-side
  • Cache base schemas to reduce API calls
  • Request only needed fields

Security

  • Review connected apps regularly
  • Use specific scopes, not full access
  • Don’t store sensitive data in public bases
  • Monitor for unusual activity
  • Revoke access when not needed

Data Quality

  • Validate data before creation
  • Use field constraints (required, unique)
  • Implement consistent data formats
  • Regular audits of record accuracy
  • Handle errors gracefully

Airtable API Reference

Official Airtable API documentation

Airtable Support

Airtable support and troubleshooting

Field Types Guide

Complete guide to Airtable field types

Formula Reference

Airtable formula syntax reference
Need help? Join the NimbleBrain Discord or email [email protected]