Integrate Google Chat with ChatGPT so that when a message is sent to the Google Chat bot, ChatGPT responds.

[What is Yoom]

How ChatGPT Responds When a Message is Sent to a Google Chat Bot

When a message is sent to a bot in Google Chat, information is received from the Google Chat API, a response is created via the ChatGPT API, and an automatic reply is made in Google Chat based on that content.
By utilizing a no-code tool called Yoom, you can easily automate the integration of Google Chat and ChatGPT without any programming knowledge.

The steps for this integration flow are broadly as follows:

• Integrate Google Chat and ChatGPT with My Apps
• Copy the template
• Set up triggers and actions
• Finally, activate and verify the trigger

Preparation

1) First, access the official Yoom website and create an account.
Yoom Account Issuance Page
If you already have an account, please log in.

2) You need to obtain an API key for ChatGPT in advance.
Open the OpenAI page and create an account from "SIGN UP".
If you already have an OpenAI account, access the OpenAI login page and obtain the API key.
* Please note that using ChatGPT or OpenAI's API may incur additional costs with OpenAI. For details, please check OpenAI's official website.

Once sign-up is complete, click "API keys" from the icon in the upper left corner.

 Generate a new API key and copy the created key.

For more details, please refer to this.
How to Register My App for ChatGPT | Yoom Help Center

‍

Step 1: Integrate Google Chat and ChatGPT with My Apps

1) Once logged into your Yoom account, register the apps you will use next.
Click "My Apps" and select "New Connection".

2) A list of apps that can be connected with Yoom will be displayed, and search for the two apps "Google Chat" and "ChatGPT" one by one from the search window at the top.

Once you can select Google Chat, log in with your Google account.

Similarly, when you select ChatGPT, enter the information obtained during preparation.
Set a management name of your choice in the "Account Name" section, set the obtained API key in the "Access Token", and click add.

3) Once registration is complete, an icon will be displayed in My Apps.
Check if the icon of the registered app is displayed.

Step 2: Copy the Template

Now, let's explain using the template.
First, click this banner.

1) Click on the "Try this template" icon.

2) When the following display appears, click "OK".

When the following display appears, the template has been copied.
The title and details can be edited by clicking on them.

Additionally, the copied template is saved in My Projects, so you can also open it from there.

Step 3: Set Triggers

Click on the icons with "!" displayed on the right in order from top to bottom to set operations.
First, click on "App Trigger: When a message with a mention to the bot is sent"!

Step 4: Set Google Chat Actions

1) Select the action "When a message with a mention to the bot is sent" and click "Next".

2)  Copy the Webhook URL and configure it in the target app's management screen.
Send a webhook event or execute the trigger event, then click "Test" and after a successful test, click "Save".

Step 5: Set ChatGPT Actions

1) Return to the flow and click on the "Integrate with App: Converse" icon.

2) Select the action "Converse" and enter the required fields.

3)  Enter the required fields.

You can select the message content from the options.
Select from the options, and once input is complete, click "Next".
After a successful test, click "Save".

Step 6: Set Google Chat Actions

1) Return to the flow and click on the "Integrate with App: Send Message" icon.

2) Select the action "Send Message" and click "Next".

3)  Enter the required fields.

You can select the message content from the options.
Select from the options, and once input is complete, click "Next".
After a successful test, click "Save".

This completes the flow where a message sent to the Google Chat bot is responded to by ChatGPT.

Step 7: Test and Verify

Once the setup is complete, the following display will appear, so click "Turn on Trigger".
Start the flow bot and verify that it operates correctly.

‍

Here is the template used this time

‍

Other Automation Examples Using Google Chat

In addition to the integration mentioned above, various automations are possible by combining Google Chat. Yoom has many examples of automation using Google Chat, and we will introduce a few of them.

1. Create a folder in OneDrive based on the message content when a message is posted in Google Chat
This template automatically creates a folder in OneDrive based on the content when a message is posted in Google Chat. For example, if you post "Sales_20240207_Contract," a dated contract folder will be automatically generated within the "Sales" folder. This streamlines file organization by department and reduces the manual effort of folder creation, thereby improving information management efficiency.

2. Register an issue in Backlog when a specific message is posted on Google Chat
This template automatically registers an issue in Backlog when a specific message is posted on Google Chat.
For example, when the sales department sends a progress report, a related task is added to Backlog and assigned to the person in charge.
This eliminates the need for manual task registration and allows for smooth tracking of work progress.
It prevents issues from being overlooked and centralizes task management for the entire team, leading to improved work efficiency.

3. When a message is sent in Google Chat, extract text using AI and add it to Microsoft Excel
This template automatically analyzes the content of a message sent in Google Chat using AI, extracts the necessary text, and adds it to Microsoft Excel.
As the information from the message is automatically entered into the sales management sheet in Excel, it reduces the effort of manual entry, improves data management accuracy, and enhances operational efficiency.

Benefits and Examples of Integrating Google Chat with ChatGPT

Benefit 1: Streamlining Operations and Reducing Time

By utilizing Google Chat bots to enable ChatGPT to respond automatically, it is expected to reduce the response time of employees.
For example, internal help desks receive daily inquiries about IT issues and how to process expense reports.
While these responses are essential for employees to smoothly carry out their tasks, addressing each one individually can often take more time than expected.
However, with this integration, Google Chat bots can quickly answer basic questions, reducing the burden on help desk staff and allowing them to focus on other issues.
This can lead to improved overall operational efficiency and increased employee productivity.

Benefit 2: Smooth Sharing and Visualization of Internal Information

In a company, it is crucial to quickly share important information such as schedule changes, project progress, and emergency notifications.
By leveraging this integration, employees can input specific commands, and ChatGPT will automatically retrieve the latest information, providing smooth responses.
When a message is sent, it can fetch data from a dashboard and return a summary, allowing for quick and easy access to information and facilitating smooth internal communication.
Additionally, the automatic organization and summarization of information make it easy to grasp necessary data at a glance.
For example, displaying information in a list format makes it easy to understand progress and key metrics, facilitating smooth decision-making for the entire team.

Benefit 3: Reduction of Errors and Improvement in Accuracy

Google Chat bots operate automatically based on pre-set rules, reducing human input errors and oversight.
For instance, by handling routine tasks such as task progress and schedule adjustments, bots can reduce staff workload and ensure smooth operations.
Moreover, since they consistently provide accurate responses, users can obtain consistent information without the worry of conveying incorrect information.
This leads to fewer mistakes and ensures accurate business operations.

Conclusion

This time, we introduced a method where ChatGPT responds when a message is sent to a Google Chat bot.
The integration of Google Chat and ChatGPT is expected to enhance operational efficiency and information sharing within the company.
Additionally, automation allows employees to focus on more important tasks, potentially increasing productivity.
Furthermore, by utilizing Yoom, it is possible to set up without any coding, making it easy to implement even without specialized knowledge.
Take this opportunity to try integrating Google Chat with ChatGPT!