Smartsheet Spoke
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 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:
| 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:
| 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 ServiceNow Otto 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 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 for more information about creating a clone.
- See 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.