{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":21613,"path":"integrate-applications/integration-hub/smartsheet-spoke.md","title":"Smartsheet Spoke","bundle":null,"doc_type":null,"release":"australia","body":"\n# Smartsheet Spoke\n\nThe 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.\n\n## Request apps on the Store\n\nVisit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) 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](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).\n\n## Integration Hub subscription\n\nThis spoke requires an Integration Hub subscription. For more information, see [Legal schedules - IntegrationHub overview](https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/snc-addendum-integrationhub.pdf).\n\n## Spoke version\n\nSmartsheet spoke v2.8.0 is the latest version. For version history of the spoke, see [Smartsheet spoke release notes](https://www.servicenow.com/docs/r/store-release-notes/store-integrationhub-rn-smartsheet.html).\n\n## Supported versions\n\nThis spoke was built for Smartsheet v1.0.1, but may be compatible with later versions.\n\n## Spoke requirements\n\nYou must have a Smartsheet admin account.\n\n## Spoke dependencies\n\nIf you’re having trouble installing the app, ensure that these dependent plugins are installed:\n\n- ServiceNow Integration Hub Runtime \\(com.glide.hub.integration.runtime\\)\n- ServiceNow Integration Hub Action Step - REST \\(com.glide.hub.action\\_step.rest\\)\n- ServiceNow Integration Hub Action Template - Data Stream \\(com.glide.hub.action\\_type.datastream\\)\n- The latest Smartsheet spoke plugin\n\n**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.\n\n## Spoke subflows\n\nThe 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:\n\n\n
\n\nSubflow\n\n\n\nDescription\n\n
\n\nSmartsheet Download Subscriptions\n\n\n\nDownloads user subscriptions from the Smartsheet portal. To use this subflow, perform the steps outlined in [Integrating with Smartsheet](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/it-asset-management/integrate-with-smartsheet.md).\n\n
\n\nSmartsheet Update User Activity\n\n\n\nRetrieves Smartsheet user activity.To use this subflow, perform the steps outlined in [Integrating with Smartsheet](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/it-asset-management/integrate-with-smartsheet.md).\n\n
\n\nSmartsheet Reclaim Subscription\n\n\n\nDeactivates user accounts in Smartsheet.To use this subflow, perform the steps outlined in [Integrating with Smartsheet](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/it-asset-management/integrate-with-smartsheet.md).\n\n
## Spoke actions\n\nThe Smartsheet spoke provides actions to automate Smartsheet tasks when events occur in your ServiceNow instance. The available actions are described in the following table:\n\n\n
\n\nCategory\n\n\n\nAction\n\n\n\nDescription\n\n
\n\nAttachment Management\n\n\n\nAttach File to Sheet\n\n\n\nAttaches a file to a sheet.\n\n
\n\nAttach URL to Sheet\n\n\n\nAttaches a URL to a sheet.\n\n
\n\nLook up Attachment by ID\n\n\n\nRetrieves the information about the attachments on a sheet.\n\n
\n\nLook up Attachments Stream\n\n\n\nRetrieves the information of all the attachments on a sheet.\n\n
\n\nCell History\n\n\n\nLook up Cell History Stream\n\n\n\nRetrieves the information on the cell modification history.\n\n
\n\nColumn Management\n\n\n\nCreate Column\n\n\n\nCreates the columns in a sheet.\n\n
\n\nLook up Column by ID\n\n\n\nRetrieves the information about a column in a sheet.\n\n
\n\nLook up Columns Stream\n\n\n\nRetrieves the information of all the columns from the sheet.\n\n
\n\nUpdate Column\n\n\n\nUpdates a column in a sheet.\n\n
\n\nComment Management\n\n\n\nCreate Comment\n\n\n\nCreates a comment in a sheet.\n\n
\n\nCreate Comment with Attachment\n\n\n\nCreates a comment on a discussion with the attachment to a sheet. The comment provides context and useful information.\n\n
\n\nLook up Comment by ID\n\n\n\nRetrieves the information on a comment.\n\n
\n\nUpdate Comment\n\n\n\nUpdates a comment on a sheet.\n\n
\n\nCross Sheet Reference Management\n\n\n\nCreate Cross Sheet Reference\n\n\n\nCreates the cross sheet reference between two sheets.\n\n
\n\nLook up Cross Sheet Reference by ID\n\n\n\nRetrieves the information about a cross sheet reference on a particular sheet.\n\n
\n\nLook up Cross Sheet References Stream\n\n\n\nRetrieves the information about all cross sheet references on a particular sheet.\n\n
\n\nEvent Management\n\n\n\nCheck Event Reporting\n\n\n\nChecks 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.\n\n
\n\nFolder Management\n\n\n\nCreate Folder in Folder\n\n\n\nCreates a folder in the specified Smartsheet Folder.\n\n
\n\nCreate Folder in Workspace\n\n\n\nCreates a folder in the specified Smartsheet workspace.\n\n
\n\nList Folder Children Stream\n\n\n\nRetrieves a paginated list of immediate child resources within a specified Smartsheet folder.\n\n
\n\nList Workspace Children Stream\n\n\n\nRetrieves a paginated list of immediate child resources within a specified Smartsheet workspace.\n\n
\n\nUpdate Folder\n\n\n\nUpdates the name and the permalink of a folder.\n\n
\n\nGroup Management\n\n\n\nCreate Group\n\n\n\nCreates a group.\n\n
\n\nLook up Org Groups Stream\n\n\n\nRetrieves information on all the groups in the organization.\n\n
\n\nUpdate Group\n\n\n\nUpdates the details of a group.\n\n
\n\nRow Management\n\n\n\nCreate Row\n\n\n\nCreates a row in a sheet.\n\n
\n\nLook up Row by ID\n\n\n\nRetrieves information on a row in a specific sheet.\n\n
\n\nUpdate Row\n\n\n\nUpdates a row in a sheet.\n\n
\n\nSend via Email Management\n\n\n\nEmail Report\n\n\n\nSends a report as an attachment to an email.\n\n
\n\nEmail Sheet\n\n\n\nSends a sheet as an attachment to an email.\n\n
\n\nSend Rows via Email\n\n\n\nSends rows via email.\n\n
\n\nSharing Management\n\n\n\nCreate Share Sheet\n\n\n\nShares a sheet with users and groups.\n\n
\n\nLook up Sheet Shares Stream\n\n\n\nRetrieves a list of all users and groups that share a sheet.\n\n
\n\nUpdate Share Sheet\n\n\n\nUpdates the access level of a user or a group for a sheet.\n\n
\n\nSheet Management\n\n\n\nCreate Sheet\n\n\n\nCreates a sheet in the folder if the folder ID is provided. Else, it creates a sheet in the user's sheet folder.\n\n
\n\nLook up Sheet by ID\n\n\n\nRetrieves information on a sheet.\n\n
\n\nLook up Sheets Stream\n\n\n\nRetrieves a list of all the sheets that the user can access.\n\n
\n\nUpdate Sheet\n\n\n\nUpdates a sheet.\n\n
\n\nUser Management\n\n\n\nCreate User\n\n\n\nCreates a user.\n\n
\n\nDeactivate User\n\n\n\nDeactivates the specified user account in Smartsheet.\n\n
\n\nDowngrade User\n\n\n\nDowngrades the user associated with the specified Smartsheet plan.\n\n
\n\nLook up Admin User\n\n\n\nRetrieves the details of the admin user that generated the access token.\n\n
\n\nLook up User Activity Stream\n\n\n\nGets the details of user activities.\n\n
\n\nLook up User by ID\n\n\n\nRetrieves the details of a user.\n\n
\n\nLook up User Subscription Stream\n\n\n\nRetrieves information about all the users in Smartsheet.\n\n
\n\nLook up Users Stream\n\n\n\nRetrieves the information of all the users.\n\n
\n\nRemove User\n\n\n\nDeactivates a user account.\n\n
\n\nUpdate User\n\n\n\nUpdates the details of a user.\n\n
\n\nWebhooks Management\n\n\n\nCreate Webhook\n\n\n\nCreates a webhook.\n\n
\n\nDelete Webhook\n\n\n\nDeletes a webhook.\n\n
\n\nLook up Webhook by ID\n\n\n\nRetrieves the details of a webhook.\n\n
\n\nLook up Webhooks Stream\n\n\n\nRetrieves the details of all the webhooks.\n\n
\n\nReset Webhook Shared Secret\n\n\n\nResets the shared secret for a webhook.\n\n
\n\nUpdate Webhook\n\n\n\nUpdates the details of a webhook.\n\n
**Note:** This spoke has a Look up User action and Software Asset Management related actions only.\n\n## Available AI agents\n\nInstall Now Assist for Integration Hub and start using the available AI agents. For more information, see [ServiceNow Otto for Integration Hub](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/now-assist-spokes.md).\n\nThis spoke provides standalone AI agents that mimic human-like intelligence to perform tasks in your ServiceNow instance.\n\n- 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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/configure-use-case-ai-agents.md) for information about adding AI agents to create agentic workflows as per your requirement and provide the required trigger.\n\n You can also search for other available AI agents and add them to your agentic workflow. See [Find AI agents](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/find-ai-agents.md) for more information.\n\n- You can create a clone of the required spoke AI agent and customize it as per your requirement. See [Duplicate an AI agent](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/clone-ai-agent.md) for more information about creating a clone.\n- See [AI Agent Studio \\(legacy\\)](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/na-ai-agents.md) for information about AI agents.\n\nAvailable AI agents include:\n\n|AI Agent|Description|\n|--------|-----------|\n|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.|\n|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.|\n|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.|\n|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.|\n|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.|\n|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.|\n|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.|\n|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.|\n|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.|\n|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,|\n|Smartsheet folder management AI agent|Automates folder-related tasks such as fetch list of available folders, create a new folder, and update a folder.|\n\nThere might be AI agents installed on your instance that are not used in agentic workflows. To learn how to see all agents that are available to you, see [Find AI agents](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/find-ai-agents.md).\n\n**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.\n\n## Connection and credential alias requirements\n\nIntegration 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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-security/r-credentials.md).\n\n"}}