smartsheet connector

[RogerS]

Here is a macro that allows you to pull down from the smartsheet API.  Download and import the macro and save it to your desktop.  Next you will need to go the options and click on User settings-Edit user settings and then choose the Macros tab at the top.  Using the + symbol to the right you can navigate to folder that contains the smartsheet Macro.  The Macro will now show up in your connector category.  To use the Macro you will need to enter your API key and answer yes to refresh smartsheet Names.  After you have a list of smartsheet names you can set refresh to No and choose the sheet from the second drop down to retrieve the data.  Hope this helps!

[ThomasT]

In the macro it's important that you update the 'Bearer' in each download tool, otherwise you won't get anything in return. Alternatively you can use the ODBC connector as metioned above. 

If you can't get it to work at all, please send me an IM and we can arrange a catch up and I'll guide you through it. 

More instructions around ODBC can be found here: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-Alteryx-to-Smartsheet/td-p/...

[ddavis07]

I attempted this but get an error downstream with the select tool. Is there something I am doing wrong or missing?

[ksabha99]

Hello Alteryx Community Members,

I would like to pull all the data from Smartsheet A and overwrite the data in Smartsheet B. Can someone suggest how I can do so using Alteryx. I am able to read the entire data from Smartsheet A using ODBC connector. Any help in this regards is highly appreciated

[ThomasT]

@ksabha99 unfortunately the Smartsheet ODBC connector is limited to download only (which is a major pain and I hope they will fix that in the future). 

As my business is mainly focused on Smartsheet/Alteryx interaction I've spent a lot of time to build macros that combine row/column/sheet id's. There are some basic macros you can find here in the forum that explain how to 'update rows. See link below:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/smartsheet-connector/td-p/3452...

You can turn the 'update rows' workflow into a macro, but it gets quite difficult once you have a sheet with 50 columns. 

[GlenRoarke]

Hi everyone,

Thank you for all the posts on this thread they have been a great help working with Smartsheet data and Alteryx. 

I have a question, has anybody been successful in connecting a smartsheet report to this input macro? For me only the sheet ids successfully generate data within the workflow. I can see the reports have a report ID and not a sheet ID.

I have the option to re do all the filters from the core sheets, however this is quite a big piece of work with over 30-40 reports active in use.

All the best

Glen