Automate weekly lead syncs to Airtable
Every Friday morning, Notis queries Salesforce for all new leads from the past week and creates them as a batch in Airtable. You get one consolidated sync instead of dozens of individual record creations. Perfect for weekend review sessions or Monday morning strategy calls. No more scrambling to stay caught up on inbound leads; they're all in Airtable waiting for your analysis.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create multiple records
Creates multiple new records in a specified airtable table.
Why this helps
New leads arrive constantly throughout the week, and you fall behind on logging them in Airtable. Come Friday or Monday, you have a backlog of leads to manually enter or a fragmented view across both systems.
- Consolidate a week of leads into one Airtable batch instead of dozens of individual additions
- Schedule syncs to fit your workflow (Friday evening, Monday morning, end of month)
- Reduce daily context-switching by grouping lead work into one session
- Zero re-entry; all lead details transfer automatically
Setup
Build it in a few focused steps.
- 1Connect Salesforce and Airtable to Notis.
- 2Tell Notis: 'Every Friday at 9 AM, create Airtable records for all new Salesforce leads from the past week, including name, email, phone, and company.'
- 3Choose 'Weekly Schedule' and pick Friday at your preferred time.
- 4Select your notification channel.
- 5Test by running the sync manually to confirm the batch appears in Airtable with all expected fields.
Questions about this workflow
Can I change the schedule (e.g., daily or twice a week)?
Absolutely. Tell Notis 'run every Monday and Thursday' or 'daily at 8 AM,' and it adjusts the schedule.
What if no new leads were added that week?
Notis skips the batch creation and notifies you that no new leads arrived. Zero wasted operations.
How many leads can be synced in one batch?
Notis can handle large batches (hundreds of records). If you have exceptionally high lead volume, Notis splits it into manageable chunks and reports each one.
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.