Create a practice integration scenario in 蜜豆视频 Workfront Fusion
This article describes how to create an integration scenario with 蜜豆视频 Workfront Fusion. Integration scenarios connect separate apps together, allowing your data to flow through different applications.
To create an integration scenario, your organization must have a Workfront Fusion for Work Automation and Integration license.
For instructions on building a Workfront-only automation scenario, see Create a practice automation scenario in 蜜豆视频 Workfront Fusion
For more information on Workfront Fusion licenses, see 蜜豆视频 Workfront Fusion licenses.
Access requirements
You must have the following access to use the functionality in this article:
To find out what plan, license type, or access you have, contact your Workfront administrator.
For information on 蜜豆视频 Workfront Fusion licenses, see 蜜豆视频 Workfront Fusion licenses.
Create a practice scenario
The role of 蜜豆视频 Workfront Fusion is to automate your processes so that you can concentrate on new tasks rather than repeating the same tasks again and again. It works by linking actions within and between apps and services to create a scenario that transfers and transforms your data automatically. The scenario you create watches for data in an app or service and processes that data to provide the result you want.
A scenario is comprised of a series of modules that indicate how data should be transformed within an app or transferred between apps and web services.
To explain how to create a scenario and reinforce best practices as you learn to use Workfront Fusion, this article takes you through the process step-by-step. We will create a scenario that creates a new record in Workfront for every row in a Google Sheets spreadsheet.
Creating a scenario consists of several main tasks:
Choose the apps and name the scenario
-
Download this , then upload it to your Google Drive for use throughout this exercise.
Or
Create or find your own simple Google Sheets spreadsheet similar to this one:
-
Sign into your Workfront Fusion account.
-
Click Scenarios
note note NOTE If you do not see the left navigation panel or its icons, click the Menu 
In the gray Folders panel that displays, you can organize your scenarios into folders.
At the top of the main area to the right, you can view All scenarios you have built, your Active Scenarios and Inactive Scenarios, and Concepts, which are scenarios that need some more work before Workfront Fusion can classify them as active or inactive.
-
In the Folders panel, click the Add folder icon
-
Open the folder, then click Create a new scenario in the upper-right corner of the page.
The landing page that displays lets you pre-load any apps you want to use in the scenario you are going to build.
-
For this exercise, search for and select the Google Sheets app.
-
Click Continue in the upper-right corner.
The scenario editor displays, containing an empty module in the center, the Google Sheets app you pre-loaded, and some options in the toolbar at the bottom.
When you begin creating a new scenario, it鈥檚 a good idea to start by creating a name for it.
-
Select the New scenario placeholder name in the upper-left corner, then type a name such as 鈥淧ractice scenario 1.鈥
-
Continue with Add and configure the first module below.
Add and configure the first module
The empty module with a question mark represents the trigger module you need to add. This module will start the scenario each time it runs. The clock icon on the empty module indicates that is a scheduled module.
This module will contain the data that you want the scenario to watch for.
-
Click the empty module to choose the app from which you will select a module.
The app you pre-loaded earlier displays next to the empty module. You can add any other apps that have modules using the Search box.
-
Click Google Sheets.
The list changes to display all Google Sheets modules that you can use as a trigger module.
-
Click the trigger module Watch for Records.
Now you need to establish an authenticated connection to your Google account. Every module you add to a scenario must have a connection to its app.
-
In the Google Sheets box, under Connection, click Add, then type a name for the connection, such as 鈥淥livia鈥檚 Google account,鈥 then click Continue.
-
Authenticate the connection in the window that displays.
The process for authenticating a connection can vary a bit between apps. You may need to log in to the app. You will usually need to click an Allow button. If you need help, see Connections overview.
Configure the first module
After you connect Workfront Fusion to your Google Sheets account, you can specify a Google Sheets spreadsheet that you have access to and the data there that you want the first module to process.
-
Click the Spreadsheet box, then select the Workfront Fusion practice scenario #1 spreadsheet in the list that appears.
This spreadsheet contains 2 sheets (tabs), so we need to specify which sheet contains the data we want:
-
In the Sheet drop-down list, select Projects.
Our spreadsheet contains headers and we want the module to use them to identify the data we want to process:
-
Leave Yes selected for Table contains headers.
-
In the Row with headers box, you could specify a range of rows that you want to include, but let鈥檚 leave the default A1:Z1 there for this exercise.
-
In the Limit box, type 1.
This way, every time you run the scenario, the module will process only 1 row in the spreadsheet. This is useful for simplifying your test runs while you are building the scenario.
-
Click OK.
The Choose where to start box prompts you to specify where in the spreadsheet you want the module to start processing.
-
Click Choose manually, select the top option in the list that appears, then click OK.
-
Right-click the module, click Rename, then type a name the describes what you want the module to do (such as 鈥淲atch the project list),鈥 then click OK.
The name appears just below the module. Below that, Workfront Fusion includes a brief description of the type of action performed by the module.
-
Continue with Add and configure the second module.
Add and configure the second module
-
Click the partial circle to the right of the of the module to Add another module.
This second module needs to be a Workfront module, but we didn鈥檛 pre-load the Workfront app.
-
To find the Workfront app, start typing 鈥淲orkfront鈥 and click the app when it appears.
-
In the list of Workfront modules that appears, click Create Record.
-
As you did before with the Google Sheets app, click Add in the Workfront box to add a connection between Workfront Fusion and Workfront.
Now we will start specifying what we want to do with the data from the spreadsheet.
-
Click Record type, then select Project because we want to create a project in Workfront using a row from the spreadsheet.
note tip TIP You can find Project in the list if you start typing the word 鈥減roject.鈥 The box expands to display all of the available Workfront project fields where you can put the information found by the first module.
We鈥檙e going to use the Name field: we want this module to name each project in Workfront using the text in the corresponding Google Sheets row.
-
Find and click the Name field.
note tip TIP You can use Cmd+F (Mac OS) or Ctrl-F(Windows OS) to find a field quickly. This opens the list of variables that you can use in the Name field to define the name for each project created in Workfront.
Notice that the variables near the top of the list correspond to the column headers in the spreadsheet.
-
Click the variable My Project Name (A) to add it to the Name field.
You have just mapped your first piece of data for this scenario.
Let鈥檚 map one more piece of data from the spreadsheet to Workfront: the start date for each project.
-
Find and click the Planned Start Date field, then click the Planned Begin Date (E) variable, to pull data from that column in the spreadsheet.
-
Click OK.
Now you have a working scenario.
-
Give the second module a name such as 鈥淐reate Workfront project,鈥 then continue with Test the scenario.
Test the scenario
Before you activate your scenario, it鈥檚 important to test it by running it at least once and viewing the results. This helps you understand how data flows through the scenario and find any errors.
We chose to have 1 row from the spreadsheet processed to create a project in Workfront. If you run the scenario, that is what should happen.
-
Click Run once in the lower-left corner of the scenario editor.
-
After the scenario finishes running, click the bubble above the Google Sheets module.
In the box that appears, you can view information about the bundle of data that the module processed, including the actual data that was pulled from the spreadsheet for the row you started with.
-
Click the execution inspector bubble above the Workfront module to see the input of information and the output, which is the ID of the project now created in Workfront
You can learn more about how to read scenario execution information in the following articles:
- For general information, see Scenario execution flow in 蜜豆视频 Workfront Fusion.
- For information about processed bundles, see Scenario execution, cycles, and phases in 蜜豆视频 Workfront Fusion.
-
Go to Workfront and search for 鈥渟oho downtown loft鈥 to see the project that the scenario created. This was the last row in the spreadsheet.
-
In Workfront Fusion, click Save
note important IMPORTANT Save often as you hone and test a scenario.
Finalize the scenario and test it again
We still need to configure the scenario to create projects for all the other rows in the spreadsheet.
-
Click the Watch Rows module you created for Google Sheets.
-
Change the Limit to 100.
Specifying a number higher than the number of rows you know are are in the spreadsheet assures that the scenario will capture all of them.
-
Right-click the Watch Rows module, click Choose where to start, click All, then click OK.
-
Click Run once and watch what happens in the execution inspector bubbles.
The Google Sheets Watch Rows module runs once to read all of the rows. Then the Workfront Create Record module runs 20 times to create a project for each of the remaining 20 rows in the spreadsheet.
-
Click the execution inspector bubble for the Workfront module to view all 20 operations, then click one of the operations to view the information about the project created.
-
Click Save
-
Go to Workfront to see the projects that the scenario created.
-
Right-click the Workfront module, then click Add a note.
-
In the note that displays, type an overview for the module.
This is helpful because you won鈥檛 have to continually open the module to see what it does. You could type something like 鈥淐reates a project with Name, Planned Start Date, and Priority mapped from spreadsheet.鈥
For the Google Sheets module, you could type something like 鈥淲atch Project List for new rows/projects added.鈥
You can add multiple notes for a module.
-
Close the Notes area.
After you add a note to a scenario, an orange dot displays on the Notes icon
-
Click the Notes icon
Activate the scenario
If this were a scenario you would be using for real data, the last thing you would do is activate it. After you activate a scenario, by default, it runs every 15 minutes. You can change this by defining when and how often you want it to run.
For more information about activating scenarios, see Activate or deactivate a scenario in 蜜豆视频 Workfront Fusion.
For information about schedules, see Schedule a scenario in 蜜豆视频 Workfront Fusion.