Airtable — One record per run in an Airtable base.

What it does

[Airtable](https://airtable.com) is the spreadsheet-as-database service teams use for lightweight CRMs, content pipelines, and structured logs. This sink writes every peepshow run as one record in a chosen base + table — `Run ID`, `Title`, `Frames`, `Duration`, `Transcript`, `Thumbnail URL`, `Created At`. The columns must exist on the table (Airtable's API doesn't auto-create schema), but once set up the records flow into any Airtable view, automation, or interface you've built — perfect for non-engineer stakeholders who want a queryable log without standing up a real database.

When to reach for it

• Keep a stakeholder-friendly log of every video an agent processed — Airtable views beat SQL for non-engineers
• Trigger Airtable automations (Slack post, email, Make/Zapier flow) on each new peepshow run
• Bridge peepshow into team-facing dashboards (Airtable Interfaces) without writing a UI

Install

npm i -g peepshow

Use it

AIRTABLE_API_KEY="patXXXXXXXXXXXXXX" \
AIRTABLE_BASE_ID="appXXXXXXXXXXXXXX" \
AIRTABLE_TABLE_ID="tblXXXXXXXXXXXXXX" \
peepshow ./demo.mp4 --sink airtable

Make it automatic

Register the sink once — every run fires it afterward. Scope by --when so it only runs for matching videos.

peepshow sinks add airtable
peepshow sinks add airtable --when extension=mp4,mov
peepshow sinks add airtable --when path=/Volumes/Work/

Configuration

• AIRTABLE_API_KEY Personal access token (Bearer auth). Generate at https://airtable.com/create/tokens. required
• AIRTABLE_BASE_ID Base id (starts with `app`). Find it in the Airtable API docs URL for your base. required
• AIRTABLE_TABLE_ID Table id (starts with `tbl`). Preferred over `AIRTABLE_TABLE_NAME` — survives renames.
• AIRTABLE_TABLE_NAME Human-readable table name. Used when `AIRTABLE_TABLE_ID` is unset.
• AIRTABLE_API_URL Override the base URL for self-hosted / proxied Airtable endpoints.
• PEEPSHOW_FRAME_BASE_URL When set, the first frame URL is written to the `Thumbnail URL` column.

# Add to ~/.zshrc, ~/.bashrc, or a project .env the agent can load
export AIRTABLE_API_KEY="..."
export AIRTABLE_BASE_ID="..."

peepshow sinks add airtable
peepshow sinks add airtable --when extension=mp4,mov

Write your own

A sink is any executable that reads the --emit json payload on stdin. Shell, Node, Python, Go — the spec's in docs/PLUGINS.md. Register persistent ones with peepshow sinks add-cmd 'your-command'.