Connectors / Integration
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.
Airtable + Salesforce integration
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.
Sales teams live in Salesforce while operations, marketing, and project teams build their workflows in Airtable. Without an automated connection, reps manually export CSVs, ops teams re-enter deal data, and leadership struggles to reconcile reports from two disconnected systems. By integrating Airtable and Salesforce through tray.ai, you can automatically push new Salesforce leads and opportunities into Airtable project trackers, sync deal stage updates back to corresponding Airtable records, trigger onboarding workflows the moment an opportunity closes, and surface real-time CRM data inside the collaborative views your non-sales teams already rely on. The result is faster handoffs, fewer data errors, and a complete operational picture across every department.
Automate & integrate Airtable + Salesforce
Automating Airtable and Salesforce business processes or integrating data is made easy with Tray.ai.
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.
- Marketing teams get instant visibility into new leads without Salesforce licenses
- Campaign attribution data is captured alongside CRM lead records automatically
- No more daily manual exports from Salesforce to spreadsheets or Airtable
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.
- Reduces onboarding lag by automating the sales-to-CS handoff
- Onboarding records are always populated with accurate deal data
- Triggers downstream tasks and notifications for CS teams automatically
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.
- CRM stays current with data collected outside of Salesforce
- Prevents duplicate contact records through automated deduplication
- Saves manual data entry time for sales and RevOps teams
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.
- Keeps Airtable pipeline dashboards accurate without manual intervention
- Gives non-Salesforce users real-time deal stage visibility
- Supports more reliable revenue forecasting across the business
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.
- Partner data lands in Salesforce without requiring BD teams to use the CRM directly
- No more missing partner accounts from CRM reporting
- Bidirectional sync prevents conflicting data between the two platforms
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.
- Unlocks custom sales activity reporting without additional Salesforce licenses
- Non-technical managers can build and modify reports in Airtable
- Automated data pulls keep dashboards current
Challenges Tray.ai solves
Common obstacles when integrating Airtable and Salesforce — and how Tray.ai handles them.
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 helps
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 helps
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 helps
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.
Templates
Pre-built workflows for Airtable and Salesforce you can deploy in minutes.
New Salesforce Lead to Airtable Record Sync
Salesforce 
Airtable 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.
Closed-Won Opportunity to Airtable Onboarding Project Creator
Salesforce Airtable 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.
Bidirectional Airtable and Salesforce Contact Sync
Airtable Salesforce 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.
Airtable Form Submission to Salesforce Lead Creator
Airtable Salesforce 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.
Scheduled Salesforce Pipeline Export to Airtable Dashboard
Salesforce Airtable 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.
Salesforce Account Health Alert to Airtable CS Action Tracker
Salesforce Airtable 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.
How Tray.ai makes this work
Airtable + Salesforce runs on the full Tray.ai platform
Intelligent iPaaS
Integrate and automate across 700+ connectors with visual workflows, error handling, and observability.
Learn more →Agent Builder
Build AI agents that read, write, and take action in Airtable and Salesforce — with guardrails, audit, and human-in-the-loop.
Learn more →Agent Gateway for MCP
Expose Airtable + Salesforce actions as governed MCP tools — observable, rate-limited, authenticated.
Learn more →Ship your Airtable + Salesforce integration.
We'll walk through the exact integration you're imagining in a tailored demo.