How to integrate Google Chat, GitHub, and data extraction features to create an Issue on GitHub when a message is posted in Google Chat

The integration of Google Chat and GitHub is expected to improve the operational efficiency of development teams.
By automatically registering messages from Google Chat as issues in GitHub, task management and communication transparency will be further enhanced. This will help prevent manual data entry errors and misunderstandings.
This article provides a detailed introduction to the benefits and integration methods of Google Chat and GitHub.

Recommended for

・Technical support staff who want to quickly respond to user feedback
・People who want to constantly monitor the progress of software development
・Team leaders who prioritize information sharing among teams

Benefits and Examples of Google Chat and GitHub Integration

Benefit 1: Efficient Task Management

By integrating Google Chat and GitHub, team communication and task management are centralized, which is expected to improve operational efficiency.
For example, when a message like "A bug has occurred" is received in Google Chat, an issue is automatically created in GitHub. This integration allows the development team to immediately track the bug on GitHub and take action towards resolving the issue. Furthermore, since ongoing tasks can be timely monitored in Google Chat, information sharing within the team becomes smoother, making it easier to adjust and avoid duplication of ongoing work.

Benefit 2: Prevention of Misunderstandings and Omissions

Since messages sent in Google Chat are directly transferred to GitHub as issues, information is recorded as is, reducing the likelihood of misunderstandings and omissions.
For instance, if a team member sends a message saying "A database connection error occurred," the content is automatically reflected as an issue in GitHub. This clearly records what problem occurred, making it easier to review the content later. There is no need to check messages and take notes or manually transfer information, as it is accurately reflected, facilitating smooth follow-up actions. Additionally, discrepancies in information recognition within the team are less likely to occur, reducing the risk of overlooking issues.

Benefit 3: Reduction of Workload through Automation

With the integration of Google Chat and GitHub, the content of messages is automatically created as issues in GitHub, reducing the manual workload. This automation is particularly useful for managing recurring tasks and feedback.
For example, if a team member reports "The UI design is broken" in Google Chat, it is generated as an issue in GitHub. This eliminates the need for developers to manually create issues, allowing them to start responding quickly. Furthermore, even if feedback or changes related to the project increase, the absence of manual task registration work allows more time to focus on other important tasks, potentially improving overall work efficiency.

[About Yoom]

How to Create a Flow Using Google Chat, GitHub, and Data Extraction Features

Let's create a flow together using a template to "create an issue in GitHub when a message is posted in Google Chat!"

The template used this time can be copied by clicking "Try it" on the banner below.

Before Getting Started

The integration flow is broadly divided into the following processes.

・Register Google Chat and GitHub as My Apps
・Copy the template
・Set up when a message is posted on Google Chat and use AI features to extract data from text
・Integrate with GitHub to create an Issue

If you do not have a Yoom account, please create one from the "Yoom Account Issuance Page" below.
For basic operations of Yoom, please check "First Time with Yoom".

Yoom Account Issuance Page

First Time with Yoom

Let's get started together!

※Important Notes※

・Integration with Google Chat is only possible with Google Workspace. Please refer to the details below.

How to Send a Message to a Space in Google Chat‍

・AI operations are only available with the Team Plan and Success Plan. For Free Plan and Mini Plan, the operations set in the flow bot will result in an error, so please be careful.

・Paid plans such as Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations).

Step 1: Integrate Google Chat and GitHub as My Apps

(1) After logging into Yoom, select "My Apps" from the left column and click "+ New Connection".

(2) From the list of new connections in My Apps, click on Google Chat.
(3) Click "Sign in with Google".
(4) The following content will appear, enter the Client ID and Client Secret, and click "Register".
※It is recommended to use "Google Chat (OAuth)". Please check the following site for the integration method.‍

How to Register Google Chat (OAuth) as My App

(5) Next, integrate with GitHub. Similarly, click on GitHub from the list of new connections in Yoom.
(6) Sign in with your account from the GitHub sign-in screen.

Once the integration is complete, Google Chat and GitHub will be registered in Yoom's My Apps.

This completes the My App registration.
Next, let's set up the trigger using the template!

Step 2: Setting Up When a Message is Posted on Google Chat

(1) We will use the template introduced earlier. Click "Try it" on the banner below to copy it.

Click on "When a new message is posted in the room" in the app trigger.

(2) From the "Select Integration Account and Action" screen in Google Chat, verify that there are no errors in the account information to integrate with Google Chat (OAuth), keep the trigger action as "When a message is sent to space," and click "Next."

(3) From the "App Trigger API Connection Settings" screen, select the trigger activation interval.
Select the trigger activation interval from the dropdown menu with options of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
※ Please note that the shortest trigger activation interval may vary depending on the plan.

Scroll down and select the resource name of the space from the suggestions.

Once the selection is complete, click "Test" at the bottom, and if no errors occur, click "Save."

Step 3: Extract Data from Text Using AI Features

(1) Next, extract data from text using Yoom's AI.
Click "Extract Data from Text."

(2) Click "Change" from the "Select Action" screen.

Select the conversion type according to the number of characters in the text.

Once the selection is complete, click "Next."
(3) From the "Set Details" screen, enter the target text. By selecting from the output as shown in the image, you can reference Google Chat information.

Scroll down and directly enter the items you want to extract, confirming with the red line.
Once the input is complete, click "Test," and if no errors occur, click "Save" at the bottom.

Step 4: Create an Issue by Integrating with GitHub

(1) Next, create an issue by integrating with GitHub.
Click "Create Issue."

(2) From the "Select Integration Account and Action" screen in GitHub, verify that there are no errors in the account information to integrate with GitHub, keep the action as "Create Issue," and click "Next."

(3) From the "API Connection Settings" screen, confirm with the red line, and enter the owner name, repository name, and assignee.
Select the title from the output.
The content entered in the comment will be reflected in GitHub.

Once the input is complete, click "Test" at the bottom, and if no errors occur, click "Save."
(4) Finally, click "Turn ON Trigger."

This completes the flowbot for "Creating an Issue in GitHub when a message is posted in Google Chat."

Other Automation Examples Using Google Chat and GitHub

At Yoom, we have other examples of automation using Google Chat and GitHub, so let us introduce a few.

1. Notify Google Chat When an Issue is Created on GitHub

By utilizing this flow, you can expect to improve the speed of information sharing. Additionally, automatic notifications to LINE WORKS can prevent missed notifications. This flow is recommended for those who want to facilitate smooth information sharing.

2. Register an Issue in GitHub and Notify Google Chat When a Task is Created in Jira Software

By creating a task in Jira Software, you can automatically register an Issue in GitHub and notify Google Chat. This not only saves the effort of manually registering in GitHub but also saves time by notifying you in Google Chat that it has been registered in GitHub.

3. Register information submitted via Google Forms to GitHub

Automatically registering tasks to GitHub will enable a prompt response to customers. Additionally, automatic registration is expected to prevent input errors and omissions. This flow is suitable for technical support personnel who frequently interact directly with customers.

Additionally, if you want to check templates using Google Chat or GitHub, please visit the following site.

List of Flowbot Templates Using Google Chat

List of Flowbot Templates Using GitHub

Summary

The integration of Google Chat and GitHub will streamline team communication and task management, enhancing transparency in operations. Automated issue creation reduces information leaks and misunderstandings, allowing everyone to timely grasp the progress of work. By leveraging this integration, the burden on developers and project managers is reduced, enabling smooth workflow. It will be a very effective tool for those who want to strengthen information sharing among teams.