Operator
← All integrations
Airtable logo+Salesforce logo

Connect Airtable to Salesforce

Automate Airtable and Salesforce with AI

Airtable bases often track the same accounts Salesforce owns with friendlier views and formulas. On Operator.io, an OpenClaw agent syncs both so new Airtable rows create or update Salesforce contacts and opportunities, CRM stage changes write back to linked records, and chat can reconcile a view against live pipeline data. Tell it to refresh a segment and it flags rows where email, owner, or amount drifted from Salesforce.

It reaches both apps directly or through connectors like Composio MCP and Pipedream MCP, which handle the sign in and token refresh, so there is no Zap to build and no API keys to paste.

What your agent can do with Airtable and Salesforce

What your agent does in Airtable

  • Create base

    Creates a new Airtable base with specified tables and fields within a workspace.

  • Create Comment

    Tool to create a comment on a specific Airtable record. Use when adding comments to records, mentioning collaborators using @[userId] syntax, or creating threaded comment replies. Supports optional parentCommentId for threaded conversati...

  • Create Field

    Creates a new field within a specified table in an Airtable base.

  • Create Record From Natural Language

    Creates a new record in an Airtable table from a natural language description. Fetches the table schema, uses an LLM to generate the correct field payload, and creates the record with typecast enabled for automatic type conversion.

  • Create records

    Tool to create multiple records (up to 10) in a specified Airtable table. Use when you need to add new rows to a table with field values. Rate limit: 5 requests per second per base.

  • Create table

    Creates a new table within a specified existing Airtable base, allowing definition of its name, description, and field structure.

All 23 Airtable actions →

What your agent does in Salesforce

  • Add contact to campaign

    Adds a contact to a campaign by creating a CampaignMember record to track campaign engagement. Fails if the contact is already a member of the campaign; pre-check membership via SOQL before calling.

  • Add lead to campaign

    Adds a lead to a campaign by creating a CampaignMember record, allowing you to track campaign engagement. Both `campaign_id` and `lead_id` must be valid Salesforce IDs of active, existing records — names or emails cannot be substituted,...

  • Add product to opportunity

    Adds a product (line item) to an opportunity. The product must exist in a pricebook entry that's associated with the opportunity's pricebook.

  • Apply lead assignment rules

    Applies configured lead assignment rules to a specific lead, automatically routing it to the appropriate owner based on your organization's rules. Allow a brief propagation delay before querying updated ownership or field values after ru...

  • Associate contact to account

    Associates a contact with an account by updating the contact's AccountId field. Overwrites any existing AccountId on the contact. For broader contact field updates alongside the account association, use SALESFORCE_UPDATE_CONTACT instead.

  • Clone opportunity with products

    Clones an opportunity and optionally its products (line items). Creates a new opportunity with the same field values and products as the original.

All 179 Salesforce actions →

How it works

Tell the agent what you want to happen between Airtable and Salesforce, for example to watch one and act in the other, or to keep the two in step. It reads what it needs from Airtable, works out what to do, and runs the matching action in Salesforce without you mapping a single field.

You can have it run once, on a schedule, or whenever something changes. Ask it for a status any time and it reads the latest from both apps back to you in the same chat.

Common questions about Airtable and Salesforce

How do I connect Airtable and Salesforce to Operator?
You authorize Airtable and Salesforce once each from your Operator dashboard. Operator holds both connections and refreshes the access tokens for you, so your agent keeps working across them without you signing in again.
What can my agent do across Airtable and Salesforce?
Tell it the job and it moves between Airtable and Salesforce as one task, choosing which actions to run on each side. There is nothing to map and no trigger to configure; you give instructions the way you would to a person.
Can my agent keep Airtable and Salesforce in sync?
Yes. It can watch Airtable and act in Salesforce, or keep both in step, reading from one and running the matching update in the other. This runs on demand when you ask or on a schedule you set.
Do I need to build a workflow or write code?
No. There is no workflow to build, no fields to map, and no API keys to paste. Operator manages both connections, and you give the agent instructions in plain language.

Airtable and Salesforce integrations

Put your agent on Airtable and Salesforce

Sign in, connect both apps, and hand your agent the work. The same setup reaches every app in the catalog. Your first week is free.

Try for free