Connect Airtable to Your AI Agent with the Airtable Skill: Full CRUD Operations from Clawdbot

If you've ever wished your AI agent could directly interact with your Airtable bases—reading records, creating entries, updating data, or deleting rows—the Airtable skill makes this seamless. Using managed OAuth through the Maton gateway, you can connect Clawdbot to your Airtable workspaces without dealing with complex token management.

What Problem Does This Solve?

Airtable is a powerful no-code database that many teams use for CRM, inventory, project management, and more. But querying it programmatically usually means setting up API keys, handling OAuth flows, and writing boilerplate code.

The Airtable skill eliminates this friction. Your agent can:

List all your bases and explore their schemas
Query records with filters, sorting, and field selection
Create, update, and delete records with natural commands
Handle pagination automatically for large datasets

This is perfect for automating data entry, syncing information across systems, or letting your agent answer questions from your Airtable data.

Installation

Install the skill with a single command:

npx clawhub@latest install airtable

Setup: Getting Your Maton API Key

The skill uses Maton's managed OAuth gateway, which handles Airtable authentication for you. Here's how to set it up:

Create a Maton account at maton.ai
Get your API key from maton.ai/settings
Set the environment variable:

export MATON_API_KEY="your-api-key-here"

Add this to your shell profile (.bashrc, .zshrc) for persistence.

Connecting Your Airtable Account

Before using the skill, you need to authorize Maton to access your Airtable. Create a connection:

python <<'EOF'
import urllib.request, os, json
data = json.dumps({"app": "airtable"}).encode()
req = urllib.request.Request("https://ctrl.maton.ai/connections", data=data, method="POST")
req.add_header("Authorization", f"Bearer {os.environ[MATON_API_KEY]}")
req.add_header("Content-Type", "application/json")
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
EOF

This returns a URL—open it in your browser to complete the OAuth flow with Airtable.

Usage Examples

Example 1: List Your Bases

See all the Airtable bases you have access to:

curl -g "https://gateway.maton.ai/airtable/v0/meta/bases" \
  -H "Authorization: Bearer $MATON_API_KEY"

Example 2: Query Records with Filters

Fetch active tasks from a table, sorted by creation date:

curl -g "https://gateway.maton.ai/airtable/v0/appXXXXX/Tasks?filterByFormula={Status}=Active&sort[0][field]=Created&sort[0][direction]=desc&maxRecords=50" \
  -H "Authorization: Bearer $MATON_API_KEY"

Example 3: Create a New Record

import os, requests, json

response = requests.post(
    "https://gateway.maton.ai/airtable/v0/appXXXXX/Contacts",
    headers={"Authorization": f"Bearer {os.environ[MATON_API_KEY]}"},
    json={
        "records": [{
            "fields": {
                "Name": "Jane Doe",
                "Email": "jane@example.com",
                "Status": "Lead"
            }
        }]
    }
)
print(response.json())

Pro Tips

Use the -g flag with curl when your URLs contain brackets (fields[], sort[]) to disable glob parsing
Base IDs start with app, Table IDs with tbl, and Record IDs with rec
Filter formulas use Airtable's formula syntax—check their Formula Reference
Rate limits are 10 requests/second per account—batch operations when possible
Multiple connections? Use the Maton-Connection header to specify which Airtable account to use

Security Notes

The skill has been verified as Benign with high confidence by both VirusTotal and OpenClaw's security scanner. Your Airtable data flows through the Maton gateway, which handles OAuth tokens securely—you never have to store Airtable credentials locally.

Conclusion

The Airtable skill transforms your AI agent into a powerful database assistant. Whether you're building a CRM workflow, automating data collection, or syncing records across systems, having direct Airtable access from Clawdbot opens up countless automation possibilities.

Links:

Happy automating!