Automatically Update Notion Database Schema to Match Airtable
When Airtable field or table structures change, Notis updates your corresponding Notion database schema to stay in sync.
Trigger
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Action
Update database schema
Updates an existing notion database's title, description, and/or properties; at least one of these attributes must be provided to effect a change.
Why this helps
Airtable schema evolves and your Notion database falls behind structurally. You manually add new properties or reconfigure the schema in Notion, then forget which version is canonical.
- Notion always matches Airtable structure, eliminating confusion about which schema is correct
- Automatic updates save time compared to manual property reconfiguration
- Reduces data entry errors caused by mismatched field names or types
- Single source of truth simplifies team collaboration
Setup
Build it in a few focused steps.
- 1Connect Airtable and Notion to Notis.
- 2Create an automation with the prompt: 'When Airtable schema changes, update the corresponding Notion database to match, adding or modifying properties as needed'.
- 3Select 'Base Schema Changed' as the trigger.
- 4Identify which Notion databases correspond to Airtable bases and choose a notification channel.
- 5Test by adding a field to an Airtable base and verify the Notion database schema updates.
Questions about this workflow
What if the field names or types don't map 1:1 between Airtable and Notion?
Notion field types differ from Airtable. Mention type conversions in your prompt: e.g., 'map Airtable single select to Notion select' or 'long text to Notion rich text'.
Does this delete Notion properties that don't exist in Airtable?
By default, no. Notis adds or updates but doesn't delete. If you want to remove orphaned properties, specify that in the automation prompt.
Can this handle complex field types like lookups or rollups?
Airtable's complex field types don't always have direct Notion equivalents. Mention your complex fields in the prompt and Notis will handle them thoughtfully.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to Notion. A trigger fires from one place; an action lands in another.
Airtable triggers
Notion actions
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Add multiple content blocks (bulk, user-friendly)
Efficiently adds multiple standard content blocks to a notion page in a single api call with automatic markdown parsing. the 'content' field in notionrichtext blocks now automatically detects and parses markdown formatting including headers (# ## ###), bold (**text**), italic (*text*), strikethrough (~~text~~), inline code (`code`), links ([text](url)), and more. ideal for bulk content creation, ai agents, and replacing multiple individual add page content calls. supports automatic text formatting, content splitting, and up to 100 blocks per request.
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Add content to Notion page
Deprecated: appends a single content block to a notion page or a parent block (must be page, toggle, to-do, bulleted/numbered list, callout, or quote); invoke repeatedly to add multiple blocks.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
Append complex blocks (advanced, full control)
Appends complex blocks with full notion block structure to a parent block or page. use for advanced scenarios requiring precise control: code blocks, tables, embeds, nested children within blocks, or when working with pre-built notion block objects. requires full notion api block schema - use add multiple page content for simpler content creation.
View Created
Triggers when a new view is created in an Airtable base.
Archive Notion Page
Archives (moves to trash) or unarchives (restores from trash) a specified notion page.
View Deleted
Triggers when a previously known Airtable view is deleted.
Create comment
Adds a comment to a notion page (via `parent page id`) or to an existing discussion thread (via `discussion id`); cannot create new discussion threads on specific blocks (inline comments).
View Metadata Changed
Triggers when an Airtable view changes its name or type.
Create Notion Database
Creates a new notion database as a subpage under a specified parent page with a defined properties schema; use this action exclusively for creating new databases.
Create Notion page
Creates a new empty page in a notion workspace.
Delete a block
Archives a notion block, page, or database using its id, which sets its 'archived' property to true (like moving to "trash" in the ui) and allows it to be restored later.
Connect any two apps with Notis in the middle.
Not just Airtable and Notion. Any combination from 985+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Notion.