✓ Verified 🌐 Web Scrapers ✓ Enhanced Data

Native Airtable

Read Airtable bases, tables, and records directly via the Airtable API.

Rating: 5 (367 reviews)
Downloads: 44,706 downloads
Version: 1.0.0

Overview

Read Airtable bases, tables, and records directly via the Airtable API.

Complete Documentation

View Source →

Airtable

Read bases, tables, and records directly via api.airtable.com.

Setup (one-time)

Go to https://airtable.com/create/tokens
Click + Create new token, give it a name
Add scopes:
data.records:read
schema.bases:read
Under Access, select which bases to grant access to (or all)
Copy the token — it starts with pat
Set the environment variable:

text

AIRTABLE_PAT=pat_your_token_here

Commands

List all accessible bases

bash

python3 /mnt/skills/user/airtable/scripts/airtable.py list-bases

List tables in a base

bash

python3 /mnt/skills/user/airtable/scripts/airtable.py list-tables <base_id>

List records in a table

bash

python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Table Name"
python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Table Name" --limit 50

Filter records with a formula

bash

python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Tasks" --filter "{Status}='Done'"
python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Contacts" --filter "NOT({Email}='')"

Filter to specific fields only

bash

python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "People" --fields "Name,Email,Company"

Use a specific view

bash

python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Tasks" --view "Active Tasks"

Get a specific record

bash

python3 /mnt/skills/user/airtable/scripts/airtable.py get-record <base_id> "Table Name" <record_id>

Search records

bash

python3 /mnt/skills/user/airtable/scripts/airtable.py search-records <base_id> "Contacts" "Smith"
python3 /mnt/skills/user/airtable/scripts/airtable.py search-records <base_id> "Contacts" "[email protected]" --field "Email"

Notes

Free plan: unlimited bases, 1,000 records per base. API reads work on free.
Base IDs start with app, record IDs start with rec.
Table names are case-sensitive and must match exactly. Use quotes if the name has spaces.
Airtable deprecated old API keys in Feb 2024. Only Personal Access Tokens (PAT) work now.

Installation

Terminal bash


openclaw install native-airtable

Copied!

💻Code Examples

### List records in a table

-list-records-in-a-table.sh

python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Table Name"
python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Table Name" --limit 50

### Filter records with a formula

-filter-records-with-a-formula.sh

python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Tasks" --filter "{Status}='Done'"
python3 /mnt/skills/user/airtable/scripts/airtable.py list-records <base_id> "Contacts" --filter "NOT({Email}='')"

### Search records

-search-records.sh

python3 /mnt/skills/user/airtable/scripts/airtable.py search-records <base_id> "Contacts" "Smith"
python3 /mnt/skills/user/airtable/scripts/airtable.py search-records <base_id> "Contacts" "[email protected]" --field "Email"