Applies to

Smartsheet
  • Business
  • Enterprise
Smartsheet Advance Package

Capabilities

Who can use this capability

To create or edit a workflow using the Smartsheet Salesforce Connector:

  • 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 you’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 must be a premium application available on your plan and the initial connection to the Salesforce environment must have already been established.

Administration and setup of the Smartsheet Salesforce Connector

PLANS

  • Business
  • Enterprise
  • Smartsheet Advance Package

Permissions

To create or edit a workflow using the Smartsheet Salesforce Connector:

  • 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 you’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 must be a premium application available on your plan and the initial connection to the Salesforce environment must have already been established.

The Smartsheet Salesforce Connector is available as a premium offering. For information about pricing, contact our sales team.

If you have the Smartsheet Salesforce Connector purchased on your plan, log in to start creating workflows between Smartsheet and Salesforce

Log in to the Smartsheet Salesforce Connector


Terminology and permissions levels 

  • Connection: This links the Salesforce Connector (for example, 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.

Features by user type

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

FeatureSmartsheet System AdminSalesforce Connector AdminSalesforce Connector User
Create connectionYesYesNo
Create workflowsYes*Yes*Yes
Edit own workflowsYes*Yes*Yes
Disable own workflowsNoNoYes
See all workflows in the organizationYesYesYes
Disable any workflow in the organizationYesYesNo
Enable or run any workflow in the organizationNoNoNo
Assign Salesforce Connector User roleYesYesNo
Assign Salesforce Connector Admin roleYesNoNo
Enable Restrict Access settingYesYesNo
Add individuals to Restrict Access list (after restrictions have been enabled)YesYesNo

*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. Learn more about restricting access.


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. 

Prerequisites

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

In Salesforce:

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

In Smartsheet:

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. 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.

    Brandfolder Image
    Salesforce Account Admin
  3. 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.
     
  4. The Salesforce Login page displays. Log in to your Salesforce account (if you're not already logged in) and select Allow when prompted.

    Brandfolder Image
    Salesforce login

You're now on the Smartsheet Salesforce Connector Account Admin page. This page gives you access to tools that create and manage workflows between Smartsheet and the Salesforce instance.

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

Brandfolder Image
Your Salesforce organization

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.


Restrict access to the Smartsheet Salesforce Connector

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.

To 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.

To activate the Restrict Access setting:

  1. Use your Smartsheet credentials to log in to the Salesforce Connector.
  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.

    Brandfolder Image
    Restrict access to 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.

To 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.

Brandfolder Image
Salesforce connector user

If you no longer have access, your workflows are active for up to 10 minutes. After this time, your workflows will automatically deactivate.


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 automatically updates per minute. If you exceed these limits, active workflows return errors and don’t synchronize information. To fix this issue, remove the Salesforce limit or you set the polling frequency to a longer interval.

You can better manage the connection between Smartsheet and Salesforce by creating custom API Usage notifications within Salesforce. 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.
     

    Brandfolder Image
    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