Bringing in GoogleSheet content to a custom form | Community
Skip to main content
R
RT_Ops
New Participant
January 31, 2024
Question

Bringing in GoogleSheet content to a custom form

  • January 31, 2024
  • 1 reply
  • 419 views

Hi folks, I have a scenario (a literal scenario, not a Fusion scenario) whereby a user completes content into a table in a GoogleSheet. I then want to take that content and populate it into like-for-like fields in a custom form attached to an issue/request in Workfront. I've done this quite happily using an Excel output to a CSV, Parse CSV, Create Record, Misc Action to attach the template to add the Custom Form and then Update Record to populate the csv data into the form.

Is there an equivalent obtaining/preparing the data from an array in a GoogleSheet? I'm playing around with Get Range Values, but not having any joy so far at getting a set of map-able fields I can use to populate a form.

 

Any guidance appreciated and if I figure it out, I'll post a reply to myself in case helpful!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

lgaertner
lgaertner
New Participant
February 1, 2024

Hello RT_Ops,

 

I have done some similar operations using Google Apps Script talking to the Workfront API before we got our Fusion instance.

 

But you should also be able to create such a scenario using the Google Sheets connector and the corresponding modules in Fusion.

 

Regards

Lars

Terms & ConditionsAccessibility statement

Loading footer...