Airtable automation actions: Salesforce
  • 19 Jan 2024
  • 3 Minutes to read
  • Dark
  • PDF

Airtable automation actions: Salesforce

  • Dark
  • PDF

Article summary

Learn how to use Airtable’s Salesforce automation actions to seamlessly create or update Salesforce records directly from an Airtable base. Marketers typically use this to hand over contact or opportunity information to sales reps using Salesforce.


Plan availability

Enterprise Scale plans only


  • Owners/Creators - Create, delete, duplicate, configure, or rename an automation and edit an automation's description.

  • Editors - View an automation's configuration or copy an automation's URL.


Web/Browser, Mac app, and Windows app

Related reading

Getting started with Airtable Automations

Setting up an automation to create or update records in Salesforce


As a prerequisite, you will need to have an existing Salesforce account and “Record Type” configured in Salesforce.

Step 1: Create a new automation

To start creating an automation, from the open base of your choice click on Automations in the upper left corner of your screen to open the automation configuration window. Click the + Create automation option to begin the setup process. If you would like, you can rename the automation right away to make it easier to understand what it does.

Step 2: Configure a trigger

Next, you will need to click + Add trigger option. Once clicked, the available triggers will display for you to choose from. Click here to learn more about all available automation triggers. Once you have configured and tested the trigger, you can move on to the next step.

Step 3: Find a Salesforce action

  1. Click the + Add advanced logic or action option.

  2. Scroll down in the menu that appears and find the “Salesforce” section.

  3. While hovering over that option, click either the Create record or Update record option.

Step 4: Configure the Salesforce action

  1. Feel free to enter a description of what the action will do. You can always add one later if you prefer to skip this step.

  2. Under “Configuration,” click the dropdown below the “Salesforce account” section. From here, either select a previously connected account or connect a new account. More information on managing connected accounts is available here.

  3. After connecting an account, you’ll perform different options depending on the type of Salesforce action you chose to use in the automation:

    1. To create a Salesforce record, select the “Salesforce record type” you want to use by clicking the dropdown and clicking on the record type of your choice. There are different options available to configure for every Salesforce record type. Learn more about creating record types in Salesforce by consulting their documentation.

      If you choose a field to update but don’t fill it with a value, then that field will be cleared out in the related Salesforce record.

    2. To update an existing Salesforce record, you need to choose a trigger that will find records based on conditions you can set. We recommend using the “When a record matches conditions” trigger to setup matching criteria to identify records, but you can also use other available triggers depending on your needs. As an example, you may want the trigger to find records in the “Opportunity” table that have a status of “Qualification”. You will then be able to select the fields that you want to update by clicking the Choose field button under the Update Fields section. If you select a field but leave it blank, that field will be cleared out in Salesforce.


Step 5: Test and turn on the automation

Again, be sure to test all of the steps in the automation that you are building. Once every part of the automation has tested successfully, you’ll likely be ready to turn the automation on. Find the red colored “OFF” toggle and click it so the automation now appears as “ON” in green.


What type of access will Airtable have to my Salesforce account?

Airtable will only have access to the Salesforce records that the user who set up the Salesforce automation has access to.

How is data transmitted from Salesforce?

The data that we send to and receive from Salesforce’s API is transmitted securely via HTTPS and will not be used for any purpose other than the automation.

What happens to my automations if my Salesforce account gets deactivated?

If the Salesforce account for a related automation is deactivated, or disconnected, then the automation will cease to work until a new Salesforce account is connected and configured.

Was this article helpful?