Grab it from "Try it yourself" and give it to your agent — it carries the whole marker convention.
Let AI build your Airtable
I let an AI agent build Airtable bases through the API, and flag what I must finish by hand.
▶ 3 min·Jun 2026·Business operation · Project management · AI·●●○ lvl 2·Free
01 · Story
Story behind
I build a lot of Airtable bases — my own and my clients'.
I describe the base to an AI agent,
and it builds most of it through the API.
But the API can't do everything.
It creates fields but can't delete them.
It can't edit a dropdown's options.
It can't make a lookup, rollup, or count.
Miss one of those,
and you ship a base with the wrong numbers in it.
So how do I let the agent do the fast 80%,
without leaving hidden mistakes behind?
It marks every gap as it goes, right in the field name:
- 🟡 — needs a manual fix
- 🔴 — delete this
Then I open the base and clear the markers in two minutes.
A base with no markers left is a finished base.
02 · Why
Why this helps you
Build in minutes, not hours — the agent does the repetitive 80% of schema-building in one pass.
Nothing breaks silently — every limit the API hits becomes a visible marker, not a hidden wrong-typed field.
A two-minute human finish — you do only the handful of clicks the API genuinely can't, guided to exactly where.
Formulas survive the cleanup — converting a placeholder keeps its field ID, so dependent formulas keep working untouched.
Reusable on every base — the same convention works for any AI-built Airtable, yours or a client's.
03 · Steps
How to
- Connect the Airtable MCP (or a PAT with API access) so the agent can build — needs Base read/write and Record read/write. Migrating? Connect the source tool too (e.g. Notion).
- Give it your work context — a Google Drive folder, plus a prompt describing what you need (sheets, PDFs, docs).
- Describe what you want built, in plain words.
- Let it plan — it splits what it can build via the API from what you'll finish by hand.
- Approve the plan it proposes.
- Watch it build ~80% in one pass — tables, fields, links, and the formulas the API allows.
- Find the flags it left — 🟡 to fix (lookup, rollup, count), 🔴 to delete.
- Clear them in the UI — about two minutes.
04 · Notes
Good to know
Never hand off a marker silently — the agent should list every 🟡 and 🔴 it left, and what each one needs, in the same message.
Test on a throwaway table first — verify what your API key can and can't do against a scratch table before it touches real schema.
Renaming is always safe — Airtable references fields by ID, so renaming a table or field never breaks a link, lookup, or formula.
Mind the rate limit — Airtable allows about five API calls a second per base; big rename sweeps need a small pause between calls.
05 · Try it yourself
Copy the skill
Build your Airtable base (with markers)
Paste it to your agent as the first message.
06 · Keep going
More how-tos
01
Connect MCPs. Build in one place
MCP lets an AI agent reach into the tools you already use and do the work — not just talk about it.
→
02
Ship your own website with an AI code agent
I left Framer's €24/month to build my own site with an AI agent — full design control, near-zero cost.
→
03
Build a second brain for your project work
I stopped re-explaining myself to every AI by giving it one folder it reads first — my context, on tap.
→