Add Ons and Integrations

Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

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

✭✭✭✭✭
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

  • Community Champion

    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."

Trending Posts