Base Schema Restructuring to Property Cleanup: Stay Organized
As your business evolves, your Airtable schema changes. Rather than manually hunting down orphaned properties in Hubspot, Notis identifies outdated fields and archives them automatically, keeping your CRM clean and organized.
Trigger
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Action
Archive batch of properties
Archives a batch of properties by their internal names for a specified hubspot crm object type; this operation is idempotent and safe to retry.
Why this helps
When Airtable schemas shift, Hubspot properties become stale and duplicate. Manually tracking which properties to archive is tedious and often forgotten.
- Hubspot properties stay aligned with your current Airtable structure
- Eliminate orphaned or outdated fields automatically
- Reduce cognitive load of manual CRM maintenance
- Maintain a clean, performant CRM without distractions
Setup
Build it in a few focused steps.
- 1Connect your Airtable and Hubspot accounts to Notis.
- 2Tell Notis: 'When my base schema changes, identify properties in Hubspot that are no longer in my Airtable schema and archive them.'
- 3Select 'Base Schema Changed' as your trigger event.
- 4Set a notification channel so you're informed when properties are archived.
- 5Review the first run to confirm Notis identified the right properties, then it runs automatically for future schema changes.
Questions about this workflow
Will this delete properties permanently?
No, archiving moves properties to Hubspot's recycling bin. You can restore them if needed. This is safe and reversible.
Can I protect certain properties from being archived?
Yes. In your automation prompt, you can specify properties to never archive, like 'Always keep Lead Status and Company Name.'
How does Notis know which properties to archive?
You teach it once. Notis compares your current Airtable fields with Hubspot properties and uses that list to identify candidates for archiving going forward.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to Hubspot. A trigger fires from one place; an action lands in another.
Airtable triggers
Hubspot actions
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Add asset association
Associates an existing asset ('form', 'object list', or 'external web url') with a specified hubspot marketing campaign.
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Add token to event template
Adds a new custom data token to an existing event template for a specified hubspot application, optionally populating a crm object property if objectpropertyname is provided.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
Archive email
Archives the hubspot email specified by `emailid` by moving it to the recycling bin, making it inaccessible unless restored.
View Created
Triggers when a new view is created in an Airtable base.
Archive a batch of emails by ID
Archives multiple hubspot crm emails by id; ids must exist as archiving is irreversible.
View Deleted
Triggers when a previously known Airtable view is deleted.
Archive a batch of quotes by id
Archives a batch of existing, non-archived quotes by their ids; this action is irreversible and useful for managing outdated or irrelevant quotes.
View Metadata Changed
Triggers when an Airtable view changes its name or type.
Archive batch of companies by id
Archives a batch of companies by their unique ids; targeted companies must exist, not be previously archived, and this api operation is irreversible.
Archive batch of contacts by id
Archives a batch of existing contacts by their hubspot crm ids, rendering them inactive; this action is irreversible via the api and requires manual restoration or a separate unarchive endpoint.
Archive batch of deals by id
Archives a batch of existing deals by their unique hubspot ids, removing them from active views and reports (soft delete); archived deals may be restorable.
Connect any two apps with Notis in the middle.
Not just Airtable and Hubspot. 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 Hubspot.