Applies to

Smartsheet Advance Package

Capabilities

Who can use this capability

To create or edit a workflow using the Smartsheet Salesforce Connector, you must adhere to the following permissions guidelines:

  • You must be  a Licensed User
  • You must have Editor permissions or higher on any mapped sheet
  • You must be  able to log in to Salesforce and have access to the records they’d like to build a workflow to
  • If your system admin activates the Restrict Users setting in the Salesforce Connector, you must also hold the Salesforce User role in Smartsheet. 
  • Smartsheet Salesforce Connector is a premium application available on the plan and initial connection to the Salesforce environment has already been established

Administration and setup of the Smartsheet Salesforce Connector

PLANS

  • Smartsheet Advance Package

Permissions

To create or edit a workflow using the Smartsheet Salesforce Connector, you must adhere to the following permissions guidelines:

  • You must be  a Licensed User
  • You must have Editor permissions or higher on any mapped sheet
  • You must be  able to log in to Salesforce and have access to the records they’d like to build a workflow to
  • If your system admin activates the Restrict Users setting in the Salesforce Connector, you must also hold the Salesforce User role in Smartsheet. 
  • Smartsheet Salesforce Connector is a premium application available on the plan and initial connection to the Salesforce environment has already been established

If you have the Smartsheet Salesforce Connector purchased on your plan, use the following URL to log in and create workflows between Smartsheet and Salesforce: https://connectors.smartsheet.com/c/salesforce 

Log in to the Smartsheet Salesforce Connector now

Terminology and Permissions levels

Before you begin, these are some helpful terms: 

  • Connection: This links the Salesforce Connector (e.g., Smartsheet) and a specific Salesforce environment.
  • Workflow: This is the link established in the Salesforce Connector between specific elements within Salesforce and a sheet in Smartsheet. 

Three types of users can interact with the Smartsheet Salesforce Connector:

  • Smartsheet System Admin — Manages and restricts Salesforce Connector Admins and Salesforce Connector Users.
  • Salesforce Connector Admin — Establishes the connection between a Salesforce instance and the Smartsheet Salesforce Connector.
  • Salesforce Connector User — Creates workflows that sync information between Smartsheet and Salesforce.

Use this chart as a reference for features based on the types of users that can access the connector.

 

Features by User type

Feature

Smartsheet System Admin

Salesforce Connector Admin

Salesforce Connector User

Create workflows

✔️*

✔️*

✔️

Edit own workflows

✔️*

✔️*

✔️

Disable own workflows

✖️

✖️

✔️

See all workflows in the organization

✔️

✔️

✖️

Disable any workflow in the organization

✔️

✔️

✖️

Enable or run any workflow in the organization

✖️

✖️

✖️

Assign Salesforce Connector User role

✔️

✔️

✖️

Assign Salesforce Connector Admin role

✔️

✖️

✖️

Enable Restrict Access setting

✔️

✔️

✖️

Add individuals to Restrict Access list (after restrictions have been enabled)

✔️

✔️

✖️

 

Smartsheet System Admins and Connector Admins can create and edit workflows freely if the Restrict Access feature is turned off. However, when this feature is on, these admins must hold a Connector User role to maintain this privilege. See Restricting Access for more information on this setting.

Connection setup

To begin using the Smartsheet Salesforce Connector, you must first set up the connection between your Smartsheet and Salesforce environments so users can then build workflows to connect between specific elements in Smartsheet and Salesforce. 

Requirements

To connect Smartsheet and Salesforce, you must have ALL of the following permissions. 

In Salesforce:

  • Salesforce System Admin role
  • API Enabled
  • View Setup and Configuration
  • View All Data

In Smartsheet:

  • Smartsheet License
  • Smartsheet System Admin role (See the User Types article for more information) - OR -  Smartsheet Salesforce Connector Admin role (an account-level role unique to the connectors; see Terminology for more information)

While only the Smartsheet System Admin role or the Smartsheet Salesforce Connector Admin role is required, it’s recommended that you have both roles to set up the connector..

Connection setup instructions

  1. Log in to the Smartsheet Salesforce Connector at https://connectors.smartsheet.com/c/salesforce. If prompted to allow access to your Smartsheet account, select Allow.
     
  2. Select the Menu icon in the upper-left corner of the page and select Account Admin.


 

  1. Select Register new Salesforce organization, then indicate if you’re connecting a Salesforce organization or a Salesforce sandbox organization. This example will assume that you’re connecting to a Salesforce organization.
     
  2. The Salesforce Login page will appear. Log in to your Salesforce account (if you're not already logged in) and select Allow when prompted.

Salesforce Login

Congratulations! That’s it. You should now be on the Smartsheet Salesforce Connector Account Admin page, where you’ll have access to all the tools you need to create and manage workflows between Smartsheet and the Salesforce instance to which you’ve just connected.

The name of your Salesforce Organization is displayed on the Account Admin page.

Salesforce Org

See the Smartsheet help article on Create workflows with the Smartsheet Salesforce Connector for details on making workflows synchronizing sheets in Smartsheet and Salesforce data.

Restricting access

Your abilities within the Salesforce Connector depend on the active restrictions and your granted permissions in Smartsheet (such as sheet sharing permissions) and Salesforce (like object read/write permissions).

To establish a workflow between a Salesforce object and a Smartsheet sheet, you need at least Editor permissions on the Smartsheet and permissions to read, write, update, and delete the Salesforce object.

Restrict access

You can limit the individuals who can create workflows with the Salesforce Connector by having the Smartsheet System/Salesforce Admin activate the Restrict Access setting.

Follow these steps to activate the Restrict Access setting:

  1. Use your Smartsheet credentials to log in to the Salesforce Connector at https://connectors.smartsheet.com/c/salesforce.
  2. Select the menu icon at the page's upper left corner and choose User Management.
  3. Mark the Restrict which users can access the Smartsheet for Salesforce Integration. checkbox.restrict access Salesforce
    The email address of anyone who has previously created workflows will be automatically added to the list of users allowed to access the connector. You can restrict their access to the Connector by removing their email address from this list if needed.
     
  4. Add the email address of anyone you want to access the Connector.

Once you activate this setting, only users holding the Salesforce User or Salesforce Admin Smartsheet permissions can access the Salesforce Connector. Manage these permission levels through the Salesforce Connector interface and the Smartsheet application.  

Refer to the Admin Center article for more information on managing users from the Smartsheet application.

Remove access

Smartsheet System/Salesforce Admins can also remove Salesforce Connector Users by selecting the delete icon delete-user-icon to the right of the username.

You can no longer create or edit your workflows if you’re removed from the list.

 

salesforce-connector-user

If you were removed from the access list and had previously created workflows, your workflows will still be active for up to 10 minutes. After this time, your workflows will be automatically disabled.

Polling frequency

You may adjust the polling frequency for requests made between Smartsheet and Salesforce. Salesforce has a limit to the number of times information can be automatically updated per minute. If these limits are exceeded, enabled workflows return errors and won’t synchronize information until the Salesforce limit is removed or the polling frequency is set to a longer interval.

To better manage the connection between Smartsheet and Salesforce, you may create custom API Usage notifications within Salesforce (see the Salesforce Help documentation). Be aware that Salesforce may use field types related to other objects (such as Lookup Relationship Fields or Polymorphic Relationship Fields), increasing the number of requests sent to Salesforce by the Smartsheet Salesforce Connector. 

Set the polling frequency

To change the polling frequency within the Connectors:

  1. Select  Menu in the upper-left corner, then select Account Admin
  2. Select Preferences on the right side to open the Polling Frequency panel next to your organization.
    salesforce-preferences

You can then set a specific rate in seconds for all workflows within your organization to help prevent your workflows from exceeding the request limitations.

 

Was this article helpful?
YesNo