Is there a package or repo to write whole Python pandas dataframes into Smartsheet?

kkumar08

I started writing some custom code using the Smartsheet python sdk to write pandas dataframes into smartsheet grids, but it gets complex pretty quickly with having to synchronize columns, efficiently running an upsert, and taking care of datatypes. So wanted to check if something like this exists already - seems like it would be a widely useful tool for setting up data workflows using Smartsheet.

Genevieve P.

Hi @kkumar08

I'm not aware of a package specific for DataFrame as it would depend on the type of DataFrame and the type of language being used.

It looks like some other users may have examples in Stack Overflow, see: Pandas DataFrame to Smartsheet sheet. It may be worth posting there if you don't receive a response from our other Community members. Additionally, Smartsheet's Python SDKs are accessible via the API Documentation, here.

Cheers,

Genevieve