Excel Export Parameters - Data Shuttle

Hello Dear Smartsheet Community

I would like to use my Smartsheet Data, to dynamically populate Email content… This being not "nicely" supported out of the box, I want to use a 3rd party app (Ablebits - Merge Email) which easily do this from Excel files pulled from "OneDrive".

For this to work, I plan on upgrading to "Data Shuttle" add-on, as I would like "full automation" (that's what Cloud-based workflow is for !!)

The 3rd Party app needs my XLS to be formatted as "TABLE Mode" for it to function

However "Data Shuttle" seems to completely lack in Excel export parameters. we cannot even select a different "worksheet" to populate, as it totally wipe & Replace everything in the file….

And so, I need to "manually" format the XLS to "Table Mode", which completely defeats the goal of "full automation" and the promises offered by "Data Shuttle"

Do you guys, "Workflow Professionnal" can think of some workarounds for this ?

Does Smartsheet have plans on upgrading these kinf possibilities within "Data Shuttle" ?

Many thanks !

Find more posts tagged with

Importing and Exporting

Data Shuttle

Accepted answers

All comments

prime_nathaniel

@Jerome.m there is no support for table in data shuttle and I personally wouldn't think this is coming under this feature set. That said, you can just add a macro to your tables, reference your shuttle target between workbooks, or use power automate to convert it. So lots of options to achieve the same result.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.