Create an offload workflow in Data Shuttle

The basics of Data Shuttle offload workflows

When you use an offload workflow, it pulls data from a Smartsheet sheet, converts it into an Excel or CSV file, and then pushes it as an attachment to:

• A Smartsheet sheet 
• OneDrive 
• SharePoint 
• Google Drive 
• Box

In Smartsheet Gov plans, the drive for Microsoft's GCC High offering is also available. However, since most drives aren't accessible by default, you must contact Support to activate access.

Prerequisites

• To use Data Shuttle, you must:
  • Hold Owner, Admin, Editor, or Viewer permissions on the source sheet
  • Have Data Shuttle Premium Application permissions enabled in Admin Center by your Smartsheet System Admin
• To offload data from Smartsheet, you must be at least a Viewer on a sheet.

Step 1: Create a new offload workflow

1. Navigate to datashuttle.smartsheet.com and log in with your Smartsheet credentials.
2. In Data Shuttle, select + in the left-hand bar.
3. Select Offload Data.

Pro tip: Copy an existing workflow

Instead of creating a new one from scratch, you can save time by copying and editing an existing workflow.

1. Navigate to the existing offload workflow. 
2. Select  Brandfolder Image  on the right-hand side. 
3. Select Create a copy.

Once you've created a copy of the workflow, you can edit it. Learn how.

Step 2: Select a source sheet

1. On the Source tab, select your source sheet. Keep in mind that your source sheet can’t be a report.
2. Select Next.

Step 3: Select a target 

Your target is where your data is going. If you use Smartsheet attachments as a target, you can use the same or a different sheet than the source. If you offload to an external storage drive, you’ll be prompted to log in if you haven’t already done so.

To select a target

1. On the Target tab, select the target location:
   • Smartsheet Attachment: Select the Smartsheet item where you want to attach the file.
   • Third-party storage drive: If you choose any of these options, you may need to sign in and select the folder where you want the offloaded data to go.
     • OneDrive & Sharepoint 
     • Google Drive
     • Box
2. Fill in the following fields:
   • Exported file name: Assign a name for your offload file.
   • Exported file type: Choose CSV or EXCEL.
3. Select Next.

Step 4: Set filters 

Use filters to define which fields you want to be offloaded from Smartsheet to your external drive. For example, you can create a filter to offload rows with In Progress as the value in the Status column. You can also use filters when working with large data sets where you only need to share a subset of your data.

Filters are case-sensitive. Make sure they're the same as the information in your file.

To set filters

1. On the Filter tab, select Add another filter.
2. In the filter setup, select an input column, a comparison operator (for example, equals or contains), and the value.

3. Select Next.

   At least one row in the source sheet must meet the filter criteria. Otherwise, Data Shuttle doesn't generate a CSV file.

Define more complex filter logic

You can define more complex filter logic with parentheses and the AND or OR operator. 

For example:

(1 AND 2) OR 3 combines logic to include all data where the (Department = “Services” AND Widget Size = “Large”) OR the Department = “Marketing.”

In this example, only large widgets for the services department would be included in your offload, but all marketing widgets would be offloaded.

Step 5: Map columns between the two systems 

Smartsheet columns are pre-populated. You select the offload file columns to match your fields between source and target.

To manually map a column

1. In the Sheet Column section, choose the sheet columns you want to match with the offload file columns. 
2. (Optional) To arrange the columns, use the arrow buttons. If you don’t want to map all fields, select  Brandfolder Image delete.
3. Once you're done mapping the fields, select Next.

You can add or remove columns in this step. However, changes might affect dependent automation.

If alterations have been made to the original sheet, use Refresh to update the mapping. However, this overrides your manual changes, so verify your columns are correctly mapped.

Step 6: Schedule your workflow

Schedule your workflow to run automatically, or run the workflow manually.

Data Shuttle uses UTC. It doesn't follow your time zone preferences from the Smartsheet app.

To run the workflow on a schedule

1. On the Run options tab, turn on the Run on schedule toggle. 
2. To set up the schedule, fill in the following fields:
   • Days of the week: Days you want to run the workflow 
   • Start time: What time you want the workflow to start running
   • Execute every: The frequency of the workflow schedule (every 15 minutes, for example)
   • End time: What time you want the workflow to stop running
3. Once you're done setting up the schedule, select Next. 

Run manually

If you don't set up a schedule for the workflow, you can run your workflow at any time.

To run the workflow manually: 

• Go to where the workflow is located, and then select Run.

Step 7: Save your new workflow

Enter a name for your workflow, and then select Save. You can now access your workflow anytime you want to run, edit, or remove it via the dashboard.