Verify leads in Airtable to prevent duplicates
When a new lead lands in Salesforce, Notis instantly queries your Airtable lead table to check if that prospect already exists. If they do, Notis alerts you to avoid wasted outreach and duplicate follow-ups. If they don't, you proceed with confidence. No more dropped balls from duplicate emails or conflicting follow-up sequences.
Trigger
New Lead Trigger
Triggers when a new Lead is created in Salesforce.
Action
List records
Retrieves records from an airtable table, with options for filtering, sorting, pagination, and specifying returned fields.
Why this helps
Duplicate leads slip through because you can't check multiple systems in the moment. You end up sending multiple emails to the same person, damaging credibility and creating confusion in your follow-up workflow.
- Catch duplicates in real time before outreach begins, protecting your professional reputation
- Use Airtable as your source of truth for lead history and avoid re-qualifying known prospects
- Reduce inbox chaos by preventing duplicate communications from automatic workflows
- Build confidence that your lead list is clean and ready for outreach
Setup
Build it in a few focused steps.
- 1Connect Salesforce and Airtable to Notis once; both integrations are available to all future automations.
- 2Create a new automation: 'When a new lead arrives in Salesforce, check Airtable for existing leads with the same email address.'
- 3Select 'New Lead Trigger' and choose Airtable as your lookup source.
- 4Pick the channel (Slack, email, or SMS) where Notis reports results.
- 5Test by adding a new lead in Salesforce; Notis will tell you whether a match exists in Airtable within seconds.
Questions about this workflow
How does Notis know if a lead is a duplicate?
You define the lookup rule in plain language (e.g., 'match by email' or 'match by first and last name'). Notis runs the query and tells you if a record exists.
What happens if a duplicate is found?
Notis sends you a notification with the existing Airtable record details. You can then decide whether to merge, skip, or create a separate entry.
Can I automate the response if a duplicate is found?
Yes. You can chain actions, e.g., 'If a duplicate exists, add a comment to the Airtable record instead of creating a new lead.'
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.