The Smartsheet spoke integrates the ServiceNow® platform with Smartsheet so that you can automate various actions, such as creating cells in a particular sheet when a database table is updated.

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 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.

Available AI agents

Install Now Assist for Spokes and start using the available AI agents. For more information, see Now Assist for Spokes.

This spoke provides standalone AI agents that mimic human-like intelligence to perform tasks in your ServiceNow instance.
  • In the ServiceNow agentic system, you can create an agentic workflow that comprises of a set of large language model (LLM) instructions along with one or more standalone AI agents to execute an objective. See Create an agentic workflow for information about adding AI Agents to create agentic workflows as per your requirement and provide the required trigger.

    You can also search for other available AI agents and add them to your agentic workflow. See Find AI agents for more information.

  • You can create a clone of the required spoke AI agent and customize it as per your requirement. See Duplicate an AI agent for more information about creating a clone.
  • See Now Assist AI Agents for information about AI agents.
Available AI Agents include:
AI AgentDescription
Smartsheet user management AI agent Enables Process Analysts to automate user management workflows within Smartsheet using Integration Hub. It can automate tasks such as create, update, remove users, and retrieve user information.
Smartsheet sheet management AI agent Enables Process Analysts to automate sheet management workflows within Smartsheet using Integration Hub. It can automate looking up sheets by their ID.
Smartsheet column management AI agent Assists the Process Analyst in managing and automating column-related tasks in Smartsheet which enables better design and execution of flows in Integration Hub. The agent performs tasks such as fetch list of available columns in a sheet, and a specific column in a sheet.
Smartsheet attachment management AI agent Enables the Process Analyst to improve Smartsheet workflows by automating attachment-related tasks such as attaching files or URLs, looking up attachment streams, and looking up attachments by ID.
Smartsheet group management AI agent Enables the Process Analyst to improve group management workflows by automating certain tasks. The Process Analyst can automate tasks such as getting the list of available groups, and update group name.
Smartsheet sharing management AI agent Enables the Process Analyst to improve workflows related to sharing in Smartsheet by automating certain actions such as looking up sheet share streams, and creating share sheets.
Smartsheet cross sheet reference management AI agent Improves workflows related to cross-referencing of sheets by automating certain tasks such as looking up cross-sheet references stream and by ID, and creating a cross-sheet.
Smartsheet row management AI agent Automates row management by performing certain tasks such as creating new rows, helping users manage data effectively and optimize their processes.
Smartsheet comment management AI agent Automates various tasks related to comments such as adding a comment, adding a comment with attachment, updating a comment, and look up for a comment.
Smartsheet cell history AI agent Automates various tasks related to the history of the data in the cells such as looking up cell history stream to retrieve and analyze historical data from Smartsheet cells,
Smartsheet folder management AI agent Automates folder-related tasks such as fetch list of available folders, create a new folder, and update a folder.

There may be AI agents installed with the Now Assist application that are not used in agentic workflows. To learn how to see all agents that are available to you, see Find AI agents.

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.