Perform operations on Smartsheet users, groups, sheets, rows and discussions and, manage Smartsheet usage in Freshservice
The Smartsheet app lets you automate repeatable actions within Freshservice and also helps you track accurate usage information for SaaS Management.
Orchestration apps give you the ability to automate several repeatable actions that span across a diverse set of systems by performing specific actions with Freshservice Workflows. With the Smartsheet app you can perform actions for:
- Lookup User by Email
- Get User
- Update User
- Add User
- Remove User
- Get Group
- Create Group
- Update Group
- Delete Group
- Add Group Members
- Remove Group Members
- Create Sheet from Template
- Create Sheet in Folder from Template
- Create Sheet in Workspace from Template
- Get Sheet
- Update Sheet
- Delete Sheet
- Add Row
- Update Row
- Get Row
- Delete Rows
- Create Discussion On Row With A Ticket Attachment
- Create Discussion on Row
- Create Discussion on Sheet with A Ticket Attachment
- Create Discussion on Sheet
- Create Comment with A Ticket Attachment
- Create Comment
This integration requires the SaaS Management Add-on. More details can be found here.
Freshservice’s integration with Smartsheet for SaaS Management enables you to track and manage users using Smartsheet directly within Freshservice. Integrating with Smartsheet enables you to:
Track the number of sheets created and owned by smart Smartsheet users.
To use this integration for SaaS Management,
- Enable the SaaS Discovery toggle and provide the Freshservice Domain Name & the Agent API Key.
Note: To know more about what SaaS Discovery is, click here.
- Click Verify.
- Once the verification is successful, Click Add and complete the installation by clicking on Install.
Note: The first sync might take a couple of hours depending on your data load.
Create an API access token from your Smartsheet account:
In the bottom-left corner, select Account.
From the menu Select Apps & Integration
In the popup menu, select API Access.
Select Generate new access token.
Enter a name and click OK.
Save the new access token somewhere safe. After you leave the page, you no longer have access to the token.
App Installation Parameter
To install and authenticate the app in Orchestration Center, the following inputs are to be provided:
Config Name - Using Config Name, give a unique name for this account’s integration with Freshservice. This name is only for your reference to manage your integrations with multiple Smartsheet instances.
API Access Token - The Personal access token of a Smartsheet account. Refer to the prerequisite steps in this document.
Freshservice Domain - The domain of your Freshservice tenant. Example: yourorganization.freshservice.com
Freshservice API Key - Log in to your Freshservice tenant. Click on your profile icon then "Profile Settings" on the right side pane, under "Your API Key" complete the captcha and copy your API key.