Troubleshooting Data Shuttle

Behavior: Numbers from my uploads import as a string (with leading 0s or an apostrophe) 

Check that the column type is set to Number in the Mapping section of the workflow

You can try using the VALUE function instead, like =VALUE([Current Budget]@row)

This function should translate values with a leading apostrophe into being recognized as numerical.

Behavior: I’m having trouble mapping to a Google Sheet with tab connected to BigQuery

You need to set First Row = 2 to pull in the column names. 

If you set First Row = 1, it pulls in the name of the tab.

Behavior: I’m having trouble using OneDrive/Sharepoint as the source location. 

When you receive the message “need a permission to access resources in your organization that only an admin can grant. Please ask an Admin to grant permission to this app before you can use it”.

The cause of this is the MS Admin locked down the ability to use your MS account for third party authentication. Valid Admin (usually is the IT department) can give permissions to certain apps. Before using OneDrive/Sharepoint as a source location, a Microsoft Admin must grant Data Shuttle permission.

Tips

• With Data Shuttle, Smartsheet limitations still 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 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 a DataTable.