Data Shuttle Offload from Smartsheet to Google Sheet - Append vs Overwrite

xahndra

Hi! I am offloading data from a smartsheet with filters into a Google Sheet and I would really like to simply append any new data rather than overwrite. We are using the offload to create a task list where we wll add a notes column to the right, but since it overwrites every offload, we can not use it in that manner. Is it even possible?

Isaac A.

Hi @xahndra!

DataShuttle offload workflows automatically save a copy of a sheet that can be imported by another application, like Google Sheets, but they can't update the target.

When you have a moment, please submit your feature request to the Product team by signing in to the Smartsheet Product Feedback & Ideas category. Posting your enhancement in the Community will allow other Smartsheet users to see and vote on your idea! The top-voted posts in this category are reviewed monthly by the Product team.

Another approach you can consider is using the Smartsheet API to achieve this. You might find this discussion on syncing to Google Sheets via the API helpful, and you can refer to our API documentation for more details.

I hope this helps!

Cheers,

Isaac.