Fill a Google Sheets or excel template with data in Smartsheet grid

LGraf
LGraf ✭✭✭✭✭
edited 06/01/23 in Add Ons and Integrations

I set up a Smartsheet form for users to input data that populates a Smartsheet grid. I would like to pull selected parts of that data into a separate template where the data is automatically input, like can be done with the Google Doc merge file feature. The end document would preferably be in Google Sheet or excel format.

I did consider inserting a table in a Google Doc and then using the merge file feature but given that many rows and columns of data need to be pulled over this is not an ideal format.

Suggestions on how to do this?

Thanks.

Answers

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭

    Do you have access to the premium app, Data Shuttle? That is going to be your best option if you have that.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."