Is anyone aware of a mechanism to drive task creation within a project from a GoogleSheet? | Community
Skip to main content
R
RT_Ops
Level 2
May 26, 2023
Solved

Is anyone aware of a mechanism to drive task creation within a project from a GoogleSheet?

  • May 26, 2023
  • 2 replies
  • 1053 views

Hi everyone and thanks for looking. My challenge is the tasks for projects are typically too variable to meaningfully build into a template, so currently projects are built from a template to cover core tasks then a project manager will review vs a detailed brief in GoogleSheets and manually add tasks to the project.

Clearly that's very inefficient, so I'm wondering whether anyone is aware of a means of Workfront referencing the GoogleSheet and adding tasks to the project accordingly?

Ideal is can this be done within Workfront and Fusion, but my investigations thus far suggest not. In which case also very appreciative of any suggestions as to other ways this could be achieved. Thanks for any suggestions!

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

I did some quick reading, and it looks like it should be doable in Fusion. I think you can use the default modules, but worst case there is an option to build custom calls to googlesheets, so anything possible with the Googlesheets API is possible for Fusion to use, but I think the "Get a cell" module will get what you need, or the batchGet call from the Googlesheets API, depending on what all you want and how your sheets are setup.

2 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
May 26, 2023

 

Hi @rt_ops,

 

If you think spreadsheets are the best approach for your crew, I invite you to consider our Excel Updater solution, which can do both Inserts and Updates of Tasks (etc.)

 

Regards,

Doug

R
RT_OpsAuthor
Level 2
May 30, 2023

Thanks @doug_den_hoed__atappstore - will take a look! Sounds promising

ChrisStephens
Community Advisor
ChrisStephensCommunity Advisor
Community Advisor
May 30, 2023

This should be doable. I haven't used it, but I know there is a googlesheets module in Fusion that I would assume you could use. What is causing concern that it would not be possible?

 

Other alternatives to this could be using @doug_den_hoed__atappstore 's, or writing your own custom code, but again, if you have Fusion currently, you should be able to leverage it.

R
RT_OpsAuthor
Level 2
May 30, 2023

Hi @chrisstephens , thanks for the reply. Main reason for concern re: Fusion is zero knowledge of the product beyond what I've found on Experience league and the Googlesheets elements referenced there being more related to updating a sheet based on progress through a project (ie Workfront to Googlesheet action rather than Googlesheet to Workfront). I'll keep digging as it does feel there may be a solution there!

ChrisStephens
Community Advisor
ChrisStephensCommunity AdvisorAccepted solution
Community Advisor
May 30, 2023

I did some quick reading, and it looks like it should be doable in Fusion. I think you can use the default modules, but worst case there is an option to build custom calls to googlesheets, so anything possible with the Googlesheets API is possible for Fusion to use, but I think the "Get a cell" module will get what you need, or the batchGet call from the Googlesheets API, depending on what all you want and how your sheets are setup.

Terms & ConditionsAccessibility statement

Loading footer...