Pushbuild

How to update Airtable records when another table changes, with n8n

A frequent ask is to change a record in one table whenever a related record changes in another. n8n can do this with its Airtable Trigger and Airtable nodes.

Get a free written scope

We reply within 20 minutes with a written scope and a mockup of what we’d build.

At a glance

  1. Watch the source tableAdd an Airtable Trigger.
  2. Find the matching recordAdd an Airtable node with the List operation on the other table.
  3. Update itAdd an Airtable node with the Update operation, using the Record ID from the List step.

Watch the source table

  • Add an Airtable Trigger. It polls, so set Poll Times, for example every minute.
  • Set Trigger Field to a created or last-modified field in the table. The node uses it to find what changed since the last check.
  • Under Additional Fields, list the Fields you need. If you list none, the output holds only the Trigger Field, which is why later steps can look empty.
  • An optional Formula filters which changes start the workflow. It is applied only to production polling, not to manual executions.

Find the matching record

  • Add an Airtable node with the List operation on the other table.
  • Use Filter By Formula to find the related record, for example {Organization}='n8n' with your own field and value mapped in.
  • The List operation returns each record's Record ID along with its fields.
  1. Watch the source table
  2. Find the matching record
  3. Update it
The parts of this guide, in order.

Update it

  • Add an Airtable node with the Update operation, using the Record ID from the List step.
  • Airtable allows five requests per second per base. Over that you get a 429 and must wait 30 seconds, so batch or slow large updates.

Updated 2026-11-02. General guidance, not advice for your situation; we scope each project in writing before any work starts.

Questions people ask first

Why does my test run ignore the trigger's formula?

n8n's docs say the formula is not applied to manual executions, only to production polling.

Why do I get a Forbidden error?

The credential is missing the scopes it needs for that base or action. Check the token's scopes in Airtable.

Tell us what you need built.

Tell us the process and the tools involved, or call. We reply with questions or a written scope.

hello@pushbuild.com

(617) 299-8887