Airtable + Salesforce
Connect Airtable and Salesforce to Unify Your Data and Close Deals Faster
Automate two-way sync between Airtable's flexible databases and Salesforce's CRM to cut manual work and keep every team on the same page.
Why integrate Airtable and Salesforce?
Airtable and Salesforce are the operational backbone for thousands of modern businesses — Airtable as a flexible, visual database for project tracking, content pipelines, and cross-functional work, and Salesforce as the authoritative CRM for managing leads, opportunities, and customer relationships. When the two run separately, data gets duplicated, delayed, or lost in translation between sales, marketing, and operations. Integrating Airtable with Salesforce on tray.ai creates an automated data bridge that keeps every stakeholder working from a single source of truth.
Automate & integrate Airtable & Salesforce
Use case
Sync New Salesforce Leads into Airtable for Marketing Campaign Tracking
Every time a new lead is created in Salesforce, a corresponding record gets added to an Airtable marketing tracker automatically. Marketing teams can annotate leads with campaign source details, content touchpoints, and nurture statuses without ever needing Salesforce access. Closed-loop reporting gets a lot easier when both systems stay in sync.
Use case
Push Closed-Won Opportunities to Airtable for Post-Sale Onboarding
When a Salesforce opportunity moves to Closed-Won, tray.ai instantly creates a new onboarding project record in Airtable, pre-populated with account details, deal value, and key contacts. Customer success and implementation teams get everything they need to hit the ground running without waiting on a sales handoff email. That alone can compress the time between signature and kickoff.
Use case
Update Salesforce Contact Records from Airtable Form Submissions
Teams that collect information via Airtable forms — event registrations, partner inquiries, customer surveys — can automatically create or update corresponding Salesforce contacts and leads. The CRM stays the authoritative record of all customer interactions regardless of where the data entered the system. Smart record-matching logic built into tray.ai handles deduplication so you don't end up with a mess of duplicate contacts.
Use case
Reflect Salesforce Opportunity Stage Changes in Airtable Deal Trackers
Revenue operations teams often maintain Airtable-based pipeline dashboards for cross-functional visibility. With tray.ai, any stage change on a Salesforce opportunity is automatically reflected in the corresponding Airtable record in real time. Executives and operations teams always see a current pipeline view without waiting on scheduled reports or manual updates.
Use case
Create Salesforce Accounts and Contacts from Airtable Partner or Vendor Records
When business development or partnerships teams add new partners or vendors to an Airtable database, tray.ai automatically creates the corresponding Account and Contact records in Salesforce. Partner relationships get tracked in the CRM for sales follow-up and reporting, while partnerships teams keep working in their preferred tool. Bidirectional updates keep both records aligned over time.
Use case
Aggregate Salesforce Activity and Task Data into Airtable for Reporting
Pull Salesforce task completions, call logs, and email activities into an Airtable reporting base on a schedule to give sales managers a flexible, visual layer for analyzing rep activity. Airtable's grouping, filtering, and charting make it easy to build custom activity dashboards without Salesforce reporting licenses or complex SOQL queries. Data refreshes automatically on a cadence you define.
Use case
Trigger Airtable Action Records from Salesforce Account Health Score Changes
When customer health scores or account status fields are updated in Salesforce, tray.ai automatically creates action items or escalation records in an Airtable customer success workspace. CSM teams can triage at-risk accounts, assign owners, and track remediation steps inside Airtable while the CRM stays the authoritative source of health data. The gap between a bad signal and an actual response shrinks considerably.
Get started with Airtable & Salesforce integration today
Airtable & Salesforce Challenges
What challenges are there when working with Airtable & Salesforce and how will using Tray.ai help?
Challenge
Mapping Disparate Field Schemas Between Airtable and Salesforce
Salesforce has a rigid, structured schema with specific field types and validation rules, while Airtable lets you configure fields however you like. Mapping between the two manually is error-prone, especially when Airtable uses multi-select fields, linked records, or attachments that have no direct Salesforce equivalent.
How Tray.ai Can Help:
tray.ai's visual data mapper lets you define precise field-level transformations between Airtable and Salesforce, including type conversions, value normalization, and conditional logic. You can handle complex cases like flattening multi-select values into Salesforce picklists or serializing Airtable linked records into lookup field references without writing custom code.
Challenge
Avoiding Duplicate Records During Bidirectional Sync
Syncing data in both directions makes it easy to create infinite update loops or duplicate records. An update written from Salesforce to Airtable can trigger the Airtable webhook, which then attempts to write back to Salesforce. Without deduplication and loop-prevention logic, data integrity degrades fast.
How Tray.ai Can Help:
tray.ai supports configurable deduplication logic using shared unique identifiers like email address or a synced external ID field. Built-in conditional branching lets you check for existing records before creating new ones, and timestamp-based conflict resolution ensures only the most recently modified record wins during bidirectional syncs.
Challenge
Handling Salesforce API Rate Limits at Scale
Salesforce enforces strict API call limits that vary by edition and org configuration. When syncing large volumes of Airtable records or running frequent polling workflows, it's easy to hit those limits — causing sync failures or delays that are difficult to diagnose without solid error handling.
How Tray.ai Can Help:
tray.ai's workflow engine has built-in rate limit awareness, retry logic, and error handling steps that manage Salesforce API constraints without falling over. You can configure bulk processing patterns, batch record upserts using the Salesforce Bulk API, and dead-letter queues for failed records so no data gets silently dropped during high-volume operations.
Challenge
Keeping Airtable Base Structures Aligned with Salesforce Object Changes
Salesforce admins regularly add custom fields, rename picklist values, or restructure objects as the business changes. When that happens without a corresponding update to the Airtable integration, workflows silently break or start writing incorrect data — often going unnoticed until the data quality damage is already done.
How Tray.ai Can Help:
tray.ai gives you centralized workflow management with clear field mapping visibility, making it straightforward to audit and update integrations when either system changes. Automated alerting on workflow failures catches schema drift quickly, and tray.ai's connector automatically reflects the latest Salesforce metadata so you can update mappings without rebuilding workflows from scratch.
Challenge
Managing Authentication and Permissions Across Teams
Airtable and Salesforce each have distinct permission models — Salesforce uses profiles, roles, and permission sets while Airtable uses workspace and base-level sharing. Integration workflows need credentials with sufficient access in both systems without over-provisioning sensitive permissions or breaking when individual user credentials are rotated.
How Tray.ai Can Help:
tray.ai supports secure, centralized credential management through its authentication framework, letting teams connect Salesforce via OAuth and Airtable via API key or OAuth without embedding credentials in individual workflows. Service account best practices are straightforward to implement, and credential rotation is handled at the connector level so no individual workflow needs updating when credentials change.
Start using our pre-built Airtable & Salesforce templates today
Start from scratch or use one of our pre-built Airtable & Salesforce templates to quickly solve your most common use cases.
Airtable & Salesforce Templates
Find pre-built Airtable & Salesforce solutions for common use cases
Template
New Salesforce Lead to Airtable Record Sync
Automatically creates a new row in a designated Airtable base whenever a lead is created in Salesforce, mapping all relevant fields including name, email, company, lead source, and owner.
Steps:
- Trigger fires when a new Lead record is created in Salesforce
- tray.ai maps Salesforce lead fields to the corresponding Airtable column schema
- A new record is created in the target Airtable base with all mapped field values
Connectors Used: Salesforce, Airtable
Template
Closed-Won Opportunity to Airtable Onboarding Project Creator
When a Salesforce opportunity reaches the Closed-Won stage, this template automatically generates a new onboarding project record in Airtable with deal metadata, account info, and assigned CSM details.
Steps:
- Trigger fires on an Opportunity stage change to Closed-Won in Salesforce
- tray.ai retrieves related Account and Contact details from Salesforce
- A new onboarding record is created in Airtable with all deal and account fields pre-populated
- Optional notification step alerts the assigned CS team member via Slack or email
Connectors Used: Salesforce, Airtable
Template
Bidirectional Airtable and Salesforce Contact Sync
Keeps Contact records synchronized between Salesforce and Airtable in both directions, using record-matching logic to update existing entries or create new ones when changes are detected in either platform.
Steps:
- Polling trigger checks for new or updated records in both Airtable and Salesforce on a defined interval
- tray.ai applies deduplication logic to match records by email address or a shared unique identifier
- Updated fields are written to the non-originating platform to keep both records in sync
- Conflict resolution rules prioritize the most recently modified record
Connectors Used: Airtable, Salesforce
Template
Airtable Form Submission to Salesforce Lead Creator
Converts new Airtable form or record submissions into Salesforce leads or contacts, covering use cases like event registrations, content downloads, and partner inquiries collected outside of Salesforce.
Steps:
- Trigger fires when a new record is added to a specified Airtable form or table
- tray.ai checks Salesforce for an existing lead or contact matching the submitted email address
- If no match exists, a new Lead is created in Salesforce with all relevant field mappings
- If a match exists, the existing record is updated with the new submission data
Connectors Used: Airtable, Salesforce
Template
Scheduled Salesforce Pipeline Export to Airtable Dashboard
Runs on a recurring schedule to pull open opportunity data from Salesforce and upsert it into an Airtable pipeline dashboard, giving cross-functional teams a refreshed, visual view of the current revenue pipeline.
Steps:
- Scheduled trigger fires on a defined cadence (hourly, daily, or weekly)
- tray.ai queries Salesforce for all open opportunities using configurable filter criteria
- Each opportunity record is upserted into Airtable using the Salesforce Opportunity ID as the unique key
- Airtable views and dashboards reflect the latest pipeline data automatically
Connectors Used: Salesforce, Airtable
Template
Salesforce Account Health Alert to Airtable CS Action Tracker
Monitors Salesforce for account health score or status field changes and automatically creates or updates action item records in an Airtable customer success tracker for CSM team triage.
Steps:
- Trigger fires when a health score or risk status field is updated on a Salesforce Account record
- tray.ai evaluates the new value against defined threshold rules to determine escalation priority
- A new action record is created or an existing record is updated in the Airtable CS tracker
- Priority, assigned owner, and due date fields are auto-populated based on risk tier
Connectors Used: Salesforce, Airtable