Applies to
- Business
- Enterprise
Capabilities
Who can use this capability
To use Data Shuttle, you must:
- Have Owner, Admin, or Editor permissions on the target sheet.
- Have Data Shuttle Premium Application permissions enabled in User Management by your Smartsheet System Admin.
To contact your sales representative and learn more, visit the Data Shuttle Marketplace.
Data Shuttle Integrations: ServiceNow
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 Smarthseet 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.