Smartsheet Spoke

Request apps on the Store

Visit the ServiceNow Store 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.7.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 in Folder	Creates a folder in the specified Smartsheet Folder.
	Create Folder in Workspace	Creates a folder in the specified Smartsheet workspace.
	List Folder Children Stream	Retrieves a paginated list of immediate child resources within a specified Smartsheet folder.
	List Workspace Children Stream	Retrieves a paginated list of immediate child resources within a specified Smartsheet workspace.
	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 Integration Hub and start using the available AI agents. For more information, see Now Assist for Integration Hub.

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 Agent	Description
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 might 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.

Note:

Ensure that the user running an AI agent has the required roles and permissions to access data or perform operations on data in the table that is associated with the AI agent.

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.