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.
USM Content
To use Data Shuttle, your Smartsheet System Admin must enable Data Shuttle Premium Application permissions in Admin Center. Visit the Data Shuttle Marketplace to contact your sales representative and learn more.
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). Then, head to DataShuttle and begin building your upload workflow.
Select your preferred storage drive in the Source Location dropdown. The first time you ask Data Shuttle to connect with it, you'll need to authenticate to the system. 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 need it updated.