Create a practice integration scenario in Adobe Workfront Fusion

Download this spreadsheet, 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 in the left panel.

note note
NOTE
If you do not see the left navigation panel or its icons, click the Menu icon.

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 , then type a name like “Practice scenarios” for your first folder.

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’s 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 “Practice scenario 1.”

Continue with Add and configure the first module below.

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 “Olivia’s 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 About connecting Adobe Workfront Fusion to an app or service.

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’s 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 “Watch 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.

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’t pre-load the Workfront app.

To find the Workfront app, start typing “Workfront” 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.

The box expands to display all of the available Workfront project fields where you can put the information found by the first module.

We’re 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.

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’s 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 “Create Workfront project,” then continue with Test the scenario.

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 Adobe Workfront Fusion.
• For information about processed bundles, see Scenario execution, cycles, and phases in Adobe Workfront Fusion.

Go to Workfront and search for “soho downtown loft” to see the project that the scenario created. This was the last row in the spreadsheet.

In Workfront Fusion, click Save near the lower-left corner to save your progress on the scenario.

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 near the lower-left corner.

Go to Workfront to see the projects that the scenario created.