Connecting Smartsheet to Revit Dynamo

Bstrydom

Hi,

I'm currently using Dynamo in Revit to pull data into Excel templates, which gives me static excel files. I'd prefer to develop a Dynamo node to push to a specific Smartsheet.

I need the ability to read the Smartsheet to define which columns and rows to write to:

Once the origins are located I need to write to the Smartsheet:

I've also started a discussion on the Dynamo Forum to see if anyone has explored doing this.

https://forum.dynamobim.com/t/exporting-to-smartsheet/72759

hollyconradsmith

Hi @Bstrydom,

Fellow dynamo user here!

The only direct way I can think of would be to develop a custom node that pulls from the Smartsheet API.

A workaround might be the excel connector for Smartsheet.

If you found a solution, I'd be interested to hear it!

Bstrydom

Thanks, @hollyconradsmith . That's exactly what I would need help with. I'm not a coder myself so I need to figure out a pathway to access the information I need. I see there's a python sample on the developer's page https://github.com/smartsheet-platform/smartsheet-python-sdk I'll look into that.