Chatspark
⌘K
⌘K

Airtable

Give teams and customers a conversational way to look up records and structured data stored in Airtable bases.

6 min read

Updated February 2026

Overview

Many teams use Airtable to track everything from inventory and event registrations to customer onboarding checklists. The problem is that only the people who built the base know how to find things in it. Everyone else ends up asking someone or struggling with filters.

The Airtable integration lets your AI agent query records, search across tables, and inspect the base schema. Anyone on the team (or visiting your website) can ask a natural-language question and get an immediate answer pulled from your Airtable data.

When to Enable This

  • Your team tracks inventory, catalogs, or event data in Airtable and needs a faster way to look things up
  • Customer-facing agents should be able to answer “Is item X in stock?” or “What's the status of my order?”
  • Non-technical team members need to query Airtable data without learning filter syntax

Available Actions

ActionDescription
Query RecordsFilter and retrieve records from a specific table using field-based criteria
Search RecordsFull-text search across records in a table
Get Base SchemaRetrieve the structure of a base including table names and field definitions
Schema-Aware AI
Get Base Schema lets the AI understand your table structure first, which makes record queries more accurate. The agent learns your field names and types automatically.

Prerequisites

Before connecting Airtable, make sure you have:

  • An Airtable account with at least one base you want to query
  • A personal access token with the correct scopes

Setup Instructions

Step 1: Create a Personal Access Token

  1. Go to airtable.com/create/tokens
  2. Click Create new token
  3. Name it “ChatSpark Integration”
  4. Add scopes: data.records:read and schema.bases:read
  5. Under Access, select the bases you want to expose
  6. Click Create token and copy it
Scope Carefully
Only grant access to the specific bases your AI agent needs. You can always add more bases later without regenerating the token.

Step 2: Enable in ChatSpark

  1. In ChatSpark, go to AI Actions
  2. Find Airtable in the Library and click Enable
  3. Select the chatbot(s) that should have access
  4. Paste your Personal Access Token
  5. Click Save

Configuration Fields

FieldDescriptionExample
API KeyYour Airtable personal access tokenpat1234567.abcdef...

Testing Your Integration

After setup, open your chatbot widget and try these realistic queries:

  1. Ask: “Is the Bluetooth Speaker still in stock?”
  2. The AI should query your Airtable base and return the matching record

More test phrases:

  • “How many open applications do we have in the hiring tracker?”
  • “Look up the event details for the March workshop”
  • “What fields are in our product catalog table?”

Troubleshooting

403 Forbidden

Your personal access token may not have access to the base being queried. Edit the token at airtable.com/create/tokens and add the missing base.

No records returned

Check that the table name and field names match exactly. Airtable is case-sensitive for field names. The AI uses Get Base Schema to learn your field names, so make sure that scope is enabled.

Rate limits

Airtable limits API requests to 5 per second per base. If you see 429 errors during heavy usage, the AI will retry automatically after a short delay.

Need Help?
If you're having trouble with the Airtable integration, contact our support team and we'll help you troubleshoot.

Previous

ActiveCampaign

Next

Asana