Keep Airtable and Affinity structures in view
When an Airtable table or field changes, get a concise view of the Affinity lists that may need a corresponding review.
Trigger
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Action
Get metadata on all lists
Returns metadata on lists.
Why this helps
Airtable structure changes can be easy to miss when Affinity pipelines are managed elsewhere.
- See Affinity list names and metadata alongside an Airtable structure change.
- Get a focused summary of potential follow-up instead of checking lists manually.
- Keep pipeline structure reviews from getting lost after database changes.
Setup
Build it in a few focused steps.
- 1Connect Airtable and Affinity once in Notis.
- 2Create an automation in plain language or in Automations, New Automation.
- 3In one instruction, ask Notis to retrieve Affinity list metadata and summarize which lists may need review after an Airtable schema change.
- 4Choose the Airtable Base Schema Changed trigger and a channel for run reports.
- 5Test with one real schema change and confirm the summary is useful.
Questions about this workflow
Does this automatically change Affinity lists?
No. The available Affinity action retrieves list metadata; Notis can summarize potential follow-up, but this workflow does not edit Affinity.
What Airtable changes start it?
The Base Schema Changed event covers changes to tables, fields, or views in a base.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to Affinity. A trigger fires from one place; an action lands in another.
Airtable triggers
Affinity actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get a company s list entries
Summarize company data across all lists, including list-specific fields and metadata like creation date and author. access requires "export data from lists" permission.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get a company s lists
Returns metadata for all the lists on which the given company appears.
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Get all companies
Affinity api allows paginated access to company info and custom fields. use `fieldids` or `fieldtypes` to specify data in a request. retrieve field ids/types via get `/v2/companies/fields`. export permission needed.
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Get all list entries on a list
Access and export essential data and metadata for companies, persons, or opportunities from a list, specifying data via `fieldids` or `fieldtypes`. "export data from lists" permission is necessary.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
Get all list entries on a saved view
Use the endpoint to access rows in a saved view with specific filters and selected fields from a web app. it doesn't maintain sort order, supports only sheet-type views, and requires export permissions.
View Created
Triggers when a new view is created in an Airtable base.
Get all opportunities
Pagination through opportunities in affinity yields basic info but excludes field data. for field data, use specified get endpoints. "export data from lists" permission needed.
View Deleted
Triggers when a previously known Airtable view is deleted.
Get all persons
The affinity api offers paginated access to person data using `fieldids` or `fieldtypes`. bulk extraction needs special permissions and supports multiple parameters.
View Metadata Changed
Triggers when an Airtable view changes its name or type.
Get a person s list entries
Summary: browse rows for a person in all lists, showing field data and entry metadata like creation time and author. requires "export data from lists" permission.
Connect any two apps with Notis in the middle.
Airtable and Affinity, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Affinity.