About Data Shuttle

With Smartsheet Data Shuttle, you can import data from enterprise software systems into Smartsheet.

Data Shuttle requires data downloaded in .csv or .xlsx format from systems like CRM, ERP, databases, etc.

You can use Data Shuttle to offload data as an attachment to a Smartsheet sheet or an external cloud source (OneDrive/SharePoint, Google Drive, or Box).

Log in to Data Shuttle

Prerequisites

Data Shuttle is a premium application. To check your access level, log in atdatashuttle.smartsheet.com.

To use Data Shuttle you must:

• Be aLicensed User
• Have Owner, Admin, or Editor permissions on the target sheet
• Have Data Shuttle Premium Application permissions enabled inUser Managementby your Smartsheet System Admin.

To contact your sales representative and learn more, visit theData Shuttle Marketplace.

Using Data Shuttle for uploads

Create an upload workflowin Data Shuttle to do the following:

• Import actual hours worked from an external time-tracking tool
• Import actual expenses from an external accounting system
• Update delivery sales pipeline from a non-SFDC CRM tool
• Merge data from an external system into an intake sheet to drive SCC provisioning
• Continuously merge data from multiple systems into one Smartsheet Solution for a centralized executive overview
• Easily cross-reference ERP data with work execution context
• Import data into Smartsheet from custom form-building tools
• Import business intelligence analysis to take action

Using Data Shuttle for offloads

Create an offload workflowin Data Shuttle to do the following:

• Display key Smartsheet information to users who don't use Smartsheet.
• Get processed data back out of Smartsheet to be imported into other data analysis tools, CRM, or other systems of record within the company.
• Export complex data in a simple structure for database imports.
• Make sheet summaries available weekly in a cloud storage system to be sent as an email attachment.
• Send modified, filtered sheet data as an attachment to another sheet for complex solution building.
• Export key PPM tracking use cases on a schedule for remediation and time-in-point against budgets in external systems
• Export, archive, and audit data by keeping exported versions of different sheets long-term

Data compatibility

If you have a Smartsheet commercial account, all your drives are on by default.

If you have a Smartsheet Gov account, they’re off. In Smartsheet Gov accounts, you can select the drives you want to permit Data Shuttle to access, but you mustcontact supportto request this capability.

Uploading data

Data Shuttle can upload data from:

• Systems that allow export to Google Sheets, .xlsx, or .csv text files
• Files in Google Drive, Microsoft (OneDrive/SharePoint), or Box
• 共享谷歌,盒子and SharePoint drives

If you select OneDrive as your source/target location, your SharePoint sites will appear in the left pane under your OneDrive files.

When creating a workflow, make sure that:

• the .csv or .xlsx file is attached to a sheet in Smartsheet; or,
• the .csv, .xlsx, or Google Sheet file is located in the Google Drive of an account you can access.
• When importing files from Google Drive to Data Shuttle, a licensed user in Smartsheet must have at least Viewer access on the doc(s) in the Google shared drive.

Offloading data from Smartsheet

To offload files from Smartsheet or Excel to a shared drive in Google Drive, a licensed user in Smartsheet must have at least Editor access to the file in the shared drive in Google.

Data Shuttle can offload data from Smartsheet to the following locations:

• OneDrive/Sharepoint, Box, and Google Drive, or as an attachment to a Smartsheet sheet in either Excel .xlsx or .csv format.
• Shared Google, Sharepoint, or Box drives. You must have at least an Editor permission on the shared drive.

Data Shuttle does not support the legacy Excel files (.xls) extension.

For information on browser compatibility, seeSystem Requirements and Guidelines for Using Smartsheet.

Data Shuttle workflows

To upload or offload data, you have to create workflows.

Each workflow helps you do the following:

• Define where the data comes from and where it goes
• Apply filters to that data
• Map the data at its destination
• Create an optional schedule for the workflow to run automatically
  • Scheduling a workflow means you can set it and forget it, knowing the data at your target is regularly updated. You can also run your workflow manually at any time.

As you build your workflows, make sure you have a clear endpoint. Avoid circular workflows; they will run in an infinite loop and create problems with your data.

基本工作流程步骤

1. Confirm your data compatibility and permissions.
2. Sign in to Data Shuttle atdatashuttle.smartsheet.com.
3. On the leftNavigation Bar, select+to create a new workflow.
4. Select the type of workflow you want to create,上传, oroffload.
5. Follow the instructions on the workflow screens to do the following:
   • Identify your source
   • Set a target
   • Apply filters
   • Map any columns
6. Optional: Set a schedule for your workflow to run automatically.
7. Publish your workflow to save it. Return to your dashboard to review, edit or archive the workflow.

Tips and best practices

• With Data Shuttle,内容limitationsstill apply.
• If you need to upload from a source to replace more than 5,000 rows or merge data into 20,000 rows, you can apply filters or decide to only map a selection of columns. You can also create multiple workflows using a common data category to distribute the data into multiple sheets. You can offload up to 20,000 rows.
• If you typically work with large datasets that exceed the sheet limitation of 20,000 rows, consider uploading to aDataTable.
• Data Shuttle filters are case-sensitive. Check your casing if your results don't look right.
• Set up efficient workflows. If someone builds a workflow and sets it to run every time a new attachment is added, anyone who adds the attachment will cause the workflow to run.