Airtable

When Airtable is the right tool

Notion handles "I want a database" for most one-person businesses. Airtable becomes worth considering when:

• You need real relational data (linked records, rollups, formulas across tables)
• You need form-driven data collection that feeds a structured base
• You want a backend for a small product without writing code
• You have specific views (calendar, kanban, gallery) that map to your workflow

For most simpler needs (CRM, content tracker, project log), Notion does it well enough. Airtable is the upgrade path when Notion's database features feel constraining.

What you actually use

• Bases. A base is a database. Multiple tables per base, linked records between them.
• Views. Same data, different presentations: grid (spreadsheet), kanban, calendar, gallery, timeline. Switch between them per user.
• Forms. Public forms that submit directly into a table. Useful for lead capture or applications.
• Automations. When a record matches a condition, do something: send an email, post to Slack, run a webhook. Native, no Zapier needed for simple cases.
• API. Every base has a REST API. Useful for using Airtable as a backend for a small site or product.

What stings

The 2024 pricing change moved Airtable from a more solo-friendly model to seat-based pricing. Team is $24/seat/mo. For one user that is the same monthly cost as a developer-tier Notion plus a Stripe subscription combined.

The free tier is generous on the surface but caps at 1,000 records per base. A real CRM or content tracker passes 1,000 records in months, not years. Once you cross it, you are paying $24/mo to keep using your own data.

The performance ceiling is also real. At 10,000+ records, Airtable can become noticeably slow without careful base design (avoid lookups in main views, avoid attached files, avoid heavy formulas). Most solo bases never hit this, but it is worth knowing.

When to skip Airtable

• You do not have a specific structured-data need (use Notion or a Google Sheet).
• Your data fits in under 1,000 records and that is not changing (free tier is fine).
• You are price-sensitive (Notion plus carefully-built databases is the budget alternative).

When Airtable earns its keep

• Operations like wedding planning, podcast guest tracking, content calendars with complex relationships.
• Internal tools for a small business (inventory, customer ops).
• A backend for a small product or directory site.

Verdict

A capable tool that has gotten more expensive. If you have a specific job that maps onto Airtable's strengths, the $24/mo can be worth it. If you are just experimenting with structured data, Notion is the better starting point.