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
After you purchase Smartsheet for Salesforce, you’ll use the following URL to log in, configure, and create sync workflows:
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.
- Go to the Smartsheet listing on the Salesforce.com AppExchange.
- Log in with your Salesforce Administrator account by clicking Log In or Register at the top of the page.
- Click Get it Now.
Installing the App
- When prompted, select the option to install the Smartsheet for Salesforce application in your production Salesforce environment.
- Read and accept the terms and conditions, and then click Confirm and Install.
- Select Install for All Users and click Install. (To view a list of permissions for the package, click on API Access.
- Check the box for Yes, grant access to these third-party web sites, and then click Continue.
NOTE: This window does not appear if you are upgrading from an earlier version of the Smartsheet for Salesforce application.
- Once the installation has completed, click on Done on the confirmation page.
- After installation, set up a connection between Salesforce and Smartsheet with the steps in the following section.
- From a web browser, navigate to the Smartsheet for Salesforce login page and click Log In with Smartsheet.
- If you are prompted to allow access to your Smartsheet account, click Allow.
- Click the menu icon in the upper-left corner of the page and select Account Admin.
- Click Register new Salesforce organization > Salesforce Organization.
The Salesforce Login page will appear.
- 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.
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 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
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.
To change the polling frequency within the Smartsheet for Salesforce connector:
- Select the menu in the upper-left corner, and then select Account Admin.
- Next to your organization, select Preferences on the right side to open the Polling Frequency panel.
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.
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.
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.