Adobe Workfront Fusion scenario example: Connect email, Text Parser, and Google Sheets

Search for Email and choose Watch emails as the Trigger.

Connect either a Google account or any other IMAP based email client (such as Outlook).

Once connected, select a Folder whose incoming emails you want to watch, such as Inbox.

Under Criteria, choose All email (or narrow it down to read or unread emails).

You can also choose to mark fetched emails as read or unread.

Set the Maximum number of results to 1.

You can change this based on the volume of messages you receive. However, it’s recommended to set a low value and run the scenario more often.

Click Show advanced settings at the bottom.

Filter emails by the Sender address, Subject and Phrase.

This gives you the ability to watch only relevant emails. In this example, we have added only a Subject filter and left the other 2 blank.

Once the configuration is done, and you are prompted to specify where to start watching your emails, click From now on.

Continue to Search for Flow Control and add a Router

Add a router after any module to split or duplicate the data before sending it to the next module.

Here, we have used a Router to send the Email body text to 2 separate tables in a Google Sheet.

Add a Match Pattern transformer to search for a phrase in an email.

We will search for the phrase “text parser module” in all incoming emails to capture the body text and sender’s name of the ones that match that phrase.

1. Write the Pattern as a Regular Expression:

   text\sparser\smodule

2. (Optional) Use any of the other Pattern options.

   

   Multiline is useful if your text contains several lines and you need to search for the pattern in each line. For this tutorial we need to search for the pattern in the entire email body text, hence we will leave it unchecked.

3. In the Text field, click the attribute Text content in the list.

   

   This is the attribute that stores the text from the email body in which we will search for the pattern.

Add another Match Pattern that searches for the same phrase and an email address.

This is particularly useful if you have customer accounts with multiple users. To save time, you can clone the Text Parser module you just created and link it to the Router.

Edit the pattern as follows:

text\sparser\smodule.+\s([\w.-]+@[\w.-]+)

This pattern searches for the phrase “text parser module” and an email address like john.doe@gmail.com and returns only the email address.

• If you’d like to search only for email address, you can use the regex below:

  ([\w.-]+@[\w.-]+)

• You may also search only for phone numbers using the regex below:

  ^[1]?(?(\d{1,3}))?[\s-]?(?(\d{3}))?[\s-]?\d{3}[\s-]?\d{3,4}
  The above pattern covers most common formats in which a phone number is written.

To test your patterns, we recommend using https://regex101.com with javascript as the Flavor.

The rest of the configuration remains the same as the one before.

Create a spreadsheet with the columns under which you’d like to capture the user data. (Feel free to use an existing file too).

For example, create one called “Email Data: Support Ticket” with Sender Name, Sender Email and Email Content as columns. Name the worksheet “contains: text parser module.”

Add the Google Sheets module with Add a row as the action.

Connect your Google account (if you haven’t already). Choose the File you created earlier, followed by choosing the Worksheet in which you’re capturing the data.

Your setup should look like this:

Map the attributes in the relevant fields (columns) to finish the module setup.

Clone the module you just created and link it to the second Text Parser module.

1. Go to your Spreadsheet, duplicate the worksheet you created earlier and give it a name.

   For example, name it “contains: text parser module and email.”

2. Add another column to store the email address that the email body contains.

   For example, name it “Email Address Shared.”

3. Click the cloned Google Sheets module to configure the setup.

4. Change the worksheet to the new one you just created.

5. Map the output from the Match Pattern module ($1) to the column where you want to store the email address (Email Address Shared).

   

   

6. Click OK, save the scenario, and take it for a test run.

   You will need to send two separate emails to the connected email address as follows:

   • Containing the phrase “text parser module” (and no email address)

     

   • Containing the above phrase and an email address

     

     If there are no errors in your setup, you will see that the first worksheet captures all emails containing the phrase “text parser module” while the second worksheet captures only those that contain the phrase “text parser module” and an email address. You may refer to the screenshots below.

     Worksheet 1:

     

     Worksheet 2: