Perform operations on Smartsheet users, groups, sheets, rows, discussions and, comments via Workflow Automator
Orchestration apps let you automate repeatable tasks and actions that span across a diverse set of systems and applications using workflows. The list of actions supported for this app include:
- 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
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.