Automatically update Airtable when opportunities change
Every time an opportunity moves stages, closes, or gets updated in Salesforce, Notis instantly updates the matching Airtable record. Your deal pipeline stays in sync across both tools. You see opportunity progress at a glance without context-switching between Salesforce and Airtable. No more guessing which deals are stuck or what the latest status is; everything updates automatically.
Trigger
New or Updated Opportunity
Triggers when a Salesforce Opportunity is created or updated.
Action
Update record
Modifies specified fields of an existing record in an airtable base and table; the base, table, and record must exist.
Why this helps
Opportunity status changes in Salesforce but Airtable falls behind, forcing you to manually update both systems or worse, make decisions on stale deal data. Your view of the pipeline is fragmented across two tools.
- One source of truth for deal status; no more guessing which tool is current
- Catch stuck deals faster by seeing status stalls in Airtable's timeline view
- Reduce context-switching by reading all deal progress from your preferred tool
- Built-in history means you can review when deals moved stages and why
Setup
Build it in a few focused steps.
- 1Connect both Salesforce and Airtable to Notis (a one-time integration step).
- 2Create an automation: 'When an opportunity is updated in Salesforce, update the matching Airtable record with the new stage, close date, and amount.'
- 3Choose 'New or Updated Opportunity' as your trigger.
- 4Select your notification channel.
- 5Test by moving a deal to a new stage in Salesforce; watch the Airtable record update within seconds.
Questions about this workflow
What fields should I sync from Salesforce to Airtable?
Common ones are stage, close date, amount, and probability. Tell Notis which fields matter to you in plain language, and it syncs only those.
What if the Airtable field type doesn't match the Salesforce type?
Notis adapts automatically. If Salesforce sends a date and Airtable expects text, Notis converts it intelligently.
Can I sync deals that were updated before this automation was enabled?
Yes. Ask Notis to run a backfill query to sync all existing opportunities into Airtable, then turn on the live trigger for new changes.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Salesforce to Airtable. A trigger fires from one place; an action lands in another.
Salesforce triggers
Airtable actions
Account Created or Updated
Triggers when an Account is created or updated in Salesforce. Uses LastModifiedDate high-watermark to capture both creations and updates.
Create base
Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.
Contact Updated
Triggers when an existing Salesforce Contact record is modified. Emits changed fields alongside relevant timestamps.
Create Comment
Creates a new comment on a specific record within an airtable base and table.
Record Updated (Generic SObject)
Triggers when monitored fields change on any Salesforce SObject. You specify the SObject type and which field values should be returned in the payload. The trigger uses SystemModstamp to detect changes regardless of which specific field changed.
Create Field
Creates a new field within a specified table in an airtable base.
New Contact Trigger
Triggers when a new Contact is Created in Salesforce.
Create multiple records
Creates multiple new records in a specified airtable table.
New Lead Trigger
Triggers when a new Lead is created in Salesforce.
Create a record
Creates a new record in a specified airtable table; field values must conform to the table's column types.
New or Updated Opportunity
Triggers when a Salesforce Opportunity is created or updated.
Create table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
Task Created or Completed
Triggers when a Task is created or when its status changes to Completed in Salesforce. Supports optional filtering by task Status or Subject.
Delete Comment
Deletes an existing comment from a specified record in an airtable table.
Delete multiple records
Deletes up to 10 specified records from a table within an airtable base.
Connect any two apps with Notis in the middle.
Not just Salesforce and Airtable. Any combination from 1,000+ 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 Airtable.