Applies to
- Business
- Enterprise
Capabilities
Who can use this capability
- Owner
- Admin
- Editor
Data Shuttle Integrations: ServiceNow
Who can use this?
Plans:
- Smartsheet Advance Package
- Business
- Enterprise
Permissions:
- Owner
- Admin
- Editor
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
To use Data Shuttle, you must have Data Shuttle Premium Application permissions enabled in Admin Center by your Smartsheet System Admin.
To contact your sales representative and learn more, visit the Data Shuttle Marketplace.
Overview
ServiceNow helps you set up systems that define, manage and automate IT service requests. It’s used across modern enterprises in human resources, facilities, and finance to optimize productivity, reduce costs, and increase resilience.
Use cases
| Use case | Details |
|---|---|
| Resource planning | Regularly upload new ticket information into Smartsheet and use Resource Management to assign projects, balance workloads, and allocate tasks based on individual skill sets. |
| Performance and process improvement tracking | Upload completed ServiceNow tickets to Smartsheet to report on efficiency, optimize processes, and analyze performance. |
| Audit and analysis | Upload completed tickets to a DataTable on a weekly basis to create a historic log of closed work that can be used to analyze opportunities for improvement. |
Export your data from ServiceNow
- Navigate to the desired record in ServiceNow; it could be an incident, problem, or change request.
- Select the Export button on the toolbar or menu.
- When prompted, select CSV or XLSX as your format and complete the export.
Import your data into Smartsheet
Once you've got your report, save it in your Google Drive (shared or personal), OneDrive, SharePoint, or Box (shared or personal). You can then head to DataShuttle and begin building your upload workflow.
Select your preferred storage drive in the Source Location dropdown. You'll need to authenticate to the system the first time you ask Data Shuttle to connect with it. Use the filters and mapping steps to select the exact data you want to upload, and schedule your workflow to run as often as you require your data to be updated.