Smartsheet Spoke

Request apps on the Store

Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Integration Hub subscription

This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.

Spoke version

Smartsheet spoke v2.4.0 is the latest version.

Supported versions

This spoke was built for Smartsheet v1.0.1, but may be compatible with later versions.

Spoke requirements

You must have a Smartsheet admin account.

Spoke dependencies

If you’re having trouble installing the app, ensure that these dependent plugins are installed:

ServiceNow Integration Hub Runtime (com.glide.hub.integration.runtime)
ServiceNow Integration Hub Action Step - REST (com.glide.hub.action_step.rest)
ServiceNow Integration Hub Action Template - Data Stream (com.glide.hub.action_type.datastream)
The latest Smartsheet spoke plugin

Note:

Some of these plugins are licensable features and need appropriate licenses, if used outside the spoke implementation. For information about licenses, contact your account manager.

Spoke subflows

The Smartsheet spoke provides sample subflows to demonstrate automating Smartsheet tasks. To customize a sample subflow, copy it to a new application scope. The available sample subflows are described in the following table:

Table 1. Smartsheet spoke subflow descriptions
Subflow	Description
Smartsheet Download Subscriptions	Downloads user subscriptions from the Smartsheet portal. To use this subflow, perform the steps outlined in Integrating with Smartsheet.
Smartsheet Update User Activity	Retrieves Smartsheet user activity. To use this subflow, perform the steps outlined in Integrating with Smartsheet.
Smartsheet Reclaim Subscription	Deactivates user accounts in Smartsheet. To use this subflow, perform the steps outlined in Integrating with Smartsheet.

Spoke actions

The Smartsheet spoke provides actions to automate Smartsheet tasks when events occur in your ServiceNow instance. The available actions are described in the following table:

Table 2. Smartsheet spoke descriptions
Category	Action	Description
Attachment Management	Attach File to Sheet	Attaches a file to a sheet.
	Attach URL to Sheet	Attaches a URL to a sheet.
	Look up Attachment by ID	Retrieves the information about the attachments on a sheet.
	Look up Attachments Stream	Retrieves the information of all the attachments on a sheet.
Cell History	Look up Cell History Stream	Retrieves the information on the cell modification history.
Column Management	Create Column	Creates the columns in a sheet.
	Look up Column by ID	Retrieves the information about a column in a sheet.
	Look up Columns Stream	Retrieves the information of all the columns from the sheet.
	Update Column	Updates a column in a sheet.
Comment Management	Create Comment	Creates a comment in a sheet.
	Create Comment with Attachment	Creates a comment on a discussion with the attachment to a sheet. The comment provides context and useful information.
	Look up Comment by ID	Retrieves the information on a comment.
	Update Comment	Updates a comment on a sheet.
Cross Sheet Reference Management	Create Cross Sheet Reference	Creates the cross sheet reference between two sheets.
	Look up Cross Sheet Reference by ID	Retrieves the information about a cross sheet reference on a particular sheet.
	Look up Cross Sheet References Stream	Retrieves the information about all cross sheet references on a particular sheet.
Event Management	Check Event Reporting	Checks if the customer has the event reporting add-on enabled. If enabled, a value of 0 is returned. If not, a value of 1 is returned.
Folder Management	Create Folder	Creates a folder on the Home pane of the Smartsheet project.
	Look up Folders Stream	Retrieves the information on all top-level child folders on the Home pane of the Smartsheet project.
	Update Folder	Updates the name and the permalink of a folder.
Group Management	Create Group	Creates a group.
	Look up Org Groups Stream	Retrieves information on all the groups in the organization.
	Update Group	Updates the details of a group.
Row Management	Create Row	Creates a row in a sheet.
	Look up Row by ID	Retrieves information on a row in a specific sheet.
	Update Row	Updates a row in a sheet.
Send via Email Management	Email Report	Sends a report as an attachment to an email.
	Email Sheet	Sends a sheet as an attachment to an email.
	Send Rows via Email	Sends rows via email.
Sharing Management	Create Share Sheet	Shares a sheet with users and groups.
	Look up Sheet Shares Stream	Retrieves a list of all users and groups that share a sheet.
	Update Share Sheet	Updates the access level of a user or a group for a sheet.
Sheet Management	Create Sheet	Creates a sheet in the folder if the folder ID is provided. Else, it creates a sheet in the user's sheet folder.
	Look up Sheet by ID	Retrieves information on a sheet.
	Look up Sheets Stream	Retrieves a list of all the sheets that the user can access.
	Update Sheet	Updates a sheet.
User Management	Create User	Creates a user.
	Deactivate User	Deactivates the specified user account in Smartsheet.
	Look up Admin User	Retrieves the details of the admin user that generated the access token.
	Look up User Activity Stream	Gets the details of user activities.
	Look up User by ID	Retrieves the details of a user.
	Look up Users Stream	Retrieves the information of all the users.
	Remove User	Deactivates a user account.
	Update User	Updates the details of a user.
Webhooks Management	Create Webhook	Creates a webhook.
	Delete Webhook	Deletes a webhook.
	Look up Webhook by ID	Retrieves the details of a webhook.
	Look up Webhooks Stream	Retrieves the details of all the webhooks.
	Reset Webhook Shared Secret	Resets the shared secret for a webhook.
	Update Webhook	Updates the details of a webhook.

Note:

This spoke has a Look up User action and Software Asset Management related actions only.

Connection and credential alias requirements

Integration Hub uses aliases to manage connection and credential information. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection. For more information, see Connections and Credentials.