Connecting to Salesforce

When you begin a Salesforce import for the first time, you will need to go through a few steps to connect Salesforce as a data source for Coefficient.

  1. Open the Coefficient Sidebar and click the Menu.

    Menu_Icon.png

  2. Select “Connected Sources”.

    Connected_Sources.png

  3. Select “Add Connection*”* at the bottom and then “Connect” to Salesforce.

    Screenshot 2023-03-10 at 7.49.59 PM.png

  4. Click “Authorize” to connect Coefficient to your Salesforce org.

    Note: If you need to connect to a Sandbox instance, click the “Advanced Settings” and check the “Sandbox Mode” box.

    Screenshot 2023-03-10 at 7.51.28 PM.png

  5. Enter your username and password to log in. Click “Allow” and you should be redirected back to your sheet. You can then start creating Salesforce imports.

Screenshot 2023-03-10 at 7.58.01 PM.png

Screenshot 2023-03-10 at 7.59.04 PM.png

Imports with Salesforce:

There are several ways to import data from Salesforce.

  1. Import from report
  2. Import from objects
  3. Import using SOQL

Let's go through each one!

Screenshot 2023-05-30 at 8.50.43 PM.png

Import from report

Import from an existing Salesforce Report

  1. Open the Coefficient Sidebar and click on the “Import from…” button.

    ImportFrom.png

  2. Select “Salesforce” from the list.

    Screenshot 2023-03-10 at 8.13.56 PM.png

  3. Select “From Existing Report”.

    Screenshot 2023-03-10 at 8.09.13 PM.png

  4. Select the report from the list and hit “Import Report”.

    Screenshot 2023-03-10 at 8.19.39 PM.png

  5. Congrats on importing a Salesforce Report with Coefficient. 🎉

Screenshot 2023-03-10 at 8.26.04 PM.png

Import from objects