Master ChatGPT and JIRA Integration: Create and Respond to Issues in Any Language!

Table of Contents

1. Introduction
2. Detecting the Language of an Incoming Email
3. Converting the Email to English Language
4. Creating a Jira Issue
5. Sending a Response in the Original Language
6. Setting up the Automation in UiPath Studio
7. Validating the Connection
8. Generating Text Completion from Open AI
9. Checking if the Language is English
10. Converting Non-English Emails to English
11. Logging the Message to Jira
12. Adding Records to a Data Table
13. Reply to Email and Sending the Response
14. Conclusion

Introduction

In this article, we will explore how to detect the language of an incoming email using UiPath Open AI. We will then automatically convert the email to the English language before creating a Jira issue. Finally, we will send a response in the original language of the email using the same connector. Let's dive in and get started with the process!

Detecting the Language of an Incoming Email

To begin, we need to set up the automation in UiPath Studio. Create a new project and select the automation as event-Based. Add the "Email Received" trigger and specify the folder as the inbox. Save the received email into a variable for further processing.

Converting the Email to English Language

Next, we will use the "Generate Text Completion from Open AI" activity to determine the language of the email. Using the "Expression Builder," we will pass the email body to the Open AI connector and ask it to provide the language in one word. This output will be saved in a variable.

Creating a Jira Issue

Once we have detected the language of the email, we will check if it is not in English. If it is not, we will convert the email to English using the same Open AI connector. Then, we will log a message to Jira and create a new issue. We will specify the Jira project, issue Type, summary, reporter, and description. The output will be saved as an issue ID and issue key.

Sending a Response in the Original Language

To send a response in the original language of the email, we will utilize the "Reply to Email" activity. We will pass the received email and the variable containing the converted response in the body part of the activity. The response will be sent accordingly.

Setting up the Automation in UiPath Studio

1. Create a new project in UiPath Studio.
2. Select the automation as event-based.
3. Add the "Email Received" trigger and specify the folder as the inbox.
4. Save the received email into a variable for further processing.

Validating the Connection

1. Validate the connection to ensure it is valid.
2. Select the folder where the emails are received, such as the inbox.
3. Click on save to store the received email in a variable.

Generating Text Completion from Open AI

1. Add the "Generate Text Completion from Open AI" activity.
2. Validate the connection to ensure it is valid.
3. Use the "Expression Builder" to pass the email body to the Open AI connector.
4. Ask the connector to provide the language in one word.
5. Save the output in a variable.

Checking if the Language is English

1. Add an "If" activity to check if the generated language is not English.
2. Use the "Contains" function to check if the language contains the word "English".
3. If the language is not English, proceed to the next activity.

Converting Non-English Emails to English

1. Add the "Generate Text Completion from Open AI" activity.
2. Use the "Expression Builder" to ask the connector to convert the email body to English.
3. Save the output in a variable.

Logging the Message to Jira

1. Add the "Log Message to Jira" activity.
2. Validate the connection to ensure it is valid.
3. Specify the Jira project and issue type.
4. Use dynamic values for the summary and reporter.
5. Use the variable containing the converted email body as the description.
6. Save the issue ID and issue key as the output.

Adding Records to a Data Table

1. Add the "Create Entity Record" activity to create a data table.
2. Specify the column names for email, email language, Jira ID, and Jira key.
3. Retrieve the values from the email received and the generated text completion activities.
4. Add a new record to the data table for each email.

Reply to Email and Sending the Response

1. Add the "Reply to Email" activity.
2. Pass the received email and the variable containing the converted response.
3. Set the priority as high.
4. Save the response to a variable.

Conclusion

In this article, we have learned how to detect the language of an incoming email, convert the email to English, create a Jira issue, and send a response in the original language. By utilizing UiPath Open AI and the appropriate activities, we can automate this process efficiently. This automation can improve the response time and overall customer satisfaction.