alexcinovoj.devby TechTide AI
Back to Airtable notes
Pattern · Airtable workflow examples

Inspecting Airtable dependencies

I list the automations, scripts, integrations, views, forms, and human processes that depend on an Airtable base before planning changes. For example, a scheduled PDF email or a partner intake form may depend on a field being preserved. The inventory informs whether to stay, repair, connect tools, or migrate.

Reference example

I use this reference example to explain the method and checks to try. It includes no client names, schemas, data, or reported results.

Short answer

How do I find the dependencies in an Airtable base?

I list the automations, scripts, integrations, views, forms, and human processes that depend on an Airtable base before planning changes. For example, a scheduled PDF email or a partner intake form may depend on a field being preserved.

Method

  • Pull base schema through the Airtable metadata API: tables, fields, field types, and linked-record relations.
  • List every automation and script action in the base, with its trigger and its side effects.
  • List external consumers: Zapier and Make scenarios, webhooks, embedded views, forms, interface pages, and API keys in use.
  • List human processes: who opens which view, and what they do next.
  • Score each dependency by blast radius and by whether a like-for-like replacement exists.
Inventory row shape
| dependency        | type       | trigger        | consumer      | replacement      | blast radius |
|-------------------|------------|----------------|---------------|------------------|--------------|
| Weekly PDF email  | automation | scheduled Mon  | finance team  | pg_cron + worker | medium       |
| Partner intake    | form       | public link    | external      | hosted form      | high         |
| Ops board         | view       | manual         | ops team      | app view         | low          |

What can go wrong

  • A table count alone misses integrations, automations, forms, and human processes.
  • An inventory can miss personal API keys held outside the workspace.
  • Interface pages can depend on fields and records that a change affects.

Checks to try

  • Freeze the base for one business day and confirm nothing unexpected breaks.
  • Reconcile the inventory against the workspace audit log for the last ninety days.

Questions this pattern answers

How do I find the dependencies in an Airtable base?

I list the automations, scripts, integrations, views, forms, and human processes that depend on an Airtable base before planning changes. For example, a scheduled PDF email or a partner intake form may depend on a field being preserved.

What steps does this method use?

Pull base schema through the Airtable metadata API: tables, fields, field types, and linked-record relations. List every automation and script action in the base, with its trigger and its side effects. List external consumers: Zapier and Make scenarios, webhooks, embedded views, forms, interface pages, and API keys in use. List human processes: who opens which view, and what they do next. Score each dependency by blast radius and by whether a like-for-like replacement exists.

How can I check the result?

Freeze the base for one business day and confirm nothing unexpected breaks. Reconcile the inventory against the workspace audit log for the last ninety days.

What can go wrong with this approach?

A table count alone misses integrations, automations, forms, and human processes. An inventory can miss personal API keys held outside the workspace. Interface pages can depend on fields and records that a change affects.

Related patterns

Related projects

I explain this method here. The Airtable Rescue Decision Sprint can recommend staying, repairing, connecting tools, or migration. TechTide AI publishes current scope, prices, and terms.

Airtable Rescue Decision Sprint at TechTide AI