Smartsheet for Salesforce: Admin Setup

Install the Smartsheet for Salesforce connector to have opportunities, contacts, and other Salesforce information update immediately to and from Smartsheet in real time. Once you’ve connected the two services, you can take advantage of the work management and visualization features in Smartsheet. For example, you can track due dates and milestones in Smartsheet and have those dates pushed back to fields in Salesforce, automatically.

Smartsheet for Salesforce is available as a premium offering. For more information about features and benefits, see Work Smarter with Salesforce and Smartsheet. For information about pricing, please contact our sales team.

This article provides information on the latest Smartsheet for Salesforce integration. If you're looking for details on the previous Smartsheet Integration for Salesforce application, check out the User Guide: http://smartsheet-platform.github.io/sfdc-docs/#overview

In this article:

Logging in to Smartsheet for Salesforce
Before you Begin: Admin Permission Requirements
Set Up a Connection Between Salesforce and Smartsheet
Smartsheet for Salesforce Admin Permissions
Creating and Editing Workflows
Adjusting the Polling Frequency

Logging in to Smartsheet for Salesforce

After you purchase Smartsheet for Salesforce, you’ll use the following URL to log in, configure, and create sync workflows:

https://connectors.smartsheet.com/c/salesforce

Before you Begin: Admin Permission Requirements

You must be a Smartsheet SysAdmin on your plan as well as a Salesforce Admin to be able to install this integration for your team. For details on the SysAdmin user type in Smartsheet, check out our Smartsheet SysAdmin Help Center article.

Installing the Application from the Salesforce App Exchange

To synchronize data between Smartsheet and Salesforce, install the App Exchange app to Salesforce and set up a connection between your Salesforce instance and your organization’s Smartsheet plan.

Getting the App

First, you need to get the Smartsheet for Salesforce app from the Salesforce.com AppExchange.

  1. Go to the Smartsheet listing on the Salesforce.com AppExchange.
     
  2. Log in with your Salesforce Administrator account by clicking Log In or Register at the top of the page.
     
  3. Click Get it Now.

    Smartsheet Listing

Installing the App

  1. When prompted, select the option to install the Smartsheet for Salesforce application in your production Salesforce environment.

    Install Production
     
  2. Read and accept the terms and conditions, and then click Confirm and Install.
     
  3. Select Install for All Users and click Install. (To view a list of permissions for the package, click on API Access.

    Install All Users
     
  4. Check the box for Yes, grant access to these third-party web sites, and then click Continue.

    Grant Access

    NOTE: This window does not appear if you are upgrading from an earlier version of the Smartsheet for Salesforce application.
     
  5. Once the installation has completed, click on Done on the confirmation page.

    Install Complete
     
  6. After installation, set up a connection between Salesforce and Smartsheet with the steps in the following section.

Set Up a Connection Between Salesforce and Smartsheet

  1. From a web browser, navigate to the Smartsheet for Salesforce login page and click Log In with Smartsheet.
     
  2. If you are prompted to allow access to your Smartsheet account, click Allow.
     
  3. Click the menu icon in the upper-left corner of the page and select Account Admin.

    Account Admin
     
  4. Click Register new Salesforce organization > Salesforce Organization.

    The Salesforce Login page will appear.

    Salesforce Login
     
  5. Log in to your Salesforce account and click Allow when prompted.

Congratulations! That’s it. You should now be on the 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 will be displayed on the Account Admin page.

Salesforce Org

Check out the Smartsheet Help Center article on Creating and Editing Workflows for details on making workflows that synchronize data between Smartsheet and Salesforce.

Smartsheet for Salesforce Admin Permissions

Smartsheet System Administrators (SysAdmins) can view workflows created by all users in the Smartsheet for Salesforce connector. This is handy when troubleshooting any workflow issues.

What Admins Can Do

Admins can set the polling frequency, which controls the number requests that can be made to change information in Salesforce and Smartsheet. This helps prevent workflows from erring out by changing the rate at which Salesforce and Smartsheet exchange information.

Admins can delete or disable a workflow.

NOTE: The user who created the workflow will still be able to log in and manually run a disabled workflow.

What Admins Can’t Do

The Admin cannot clone the workflow. Admins are also restricted from viewing or editing the following elements of a workflow:

  • The selected Salesforce object or Smartsheet sheet
  • Salesforce fields and Smartsheet column mappings
  • Filters.

Setting the Polling Frequency

Admins can set the polling frequency for requests made between Smartsheet and Salesforce through the integration. Both applications have a limit to the number of times information can be automatically updated per minute. If these limitations are exceeded, your workflows will be disabled.

For details on request limits in Salesforce and Smartsheet, check out the Salesforce API and Smartsheet API documentation.

To change the polling frequency within the Smartsheet for Salesforce connector:

  1. Select the menu in the upper-left corner, and then select Account Admin. 
     
  2. Next to your organization, select Preferences on the right side to open the Polling Frequency panel.

    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.

Relationship Fields

Salesforce uses field types within an object that relate to other objects, such as Lookup Relationship Fields (for example, Account Name in the Account object) and Polymorphic Relationship Fields (for example, the “What” field of an Event).



Keep the following in mind with these field types:

  • When you create workflows in Smartsheet for Salesforce that map these fields, the integration must check that object and all of its related objects. This multiplies the amount of requests made depending on the number of objects related to the mapped field. 

  • Adjusting the polling frequency to make fewer requests will help reduce API requests made to your Salesforce organization. 

Creating and Editing Workflows

Now that the Smartsheet for Salesforce connector has been set up, check out our article on Creating and Editing Workflows for details on the synchronization process between the two systems.