How to integrate Google Chat with HRMOS Attendance to register a timestamp in HRMOS Attendance when a message is posted in Google Chat
How to Integrate Applications
・
2024/12/16
How to integrate Google Chat with HRMOS Attendance to register a timestamp in HRMOS Attendance when a message is posted in Google Chat
k.ueno
Attendance reporting is the foundation of daily operations, and attendance managers need to regularly check whether employees can engage in their regular duties without issues based on the report content. The app integration of Google Chat and HRMOS Attendance using Yoom allows for more efficient attendance management by enabling clock-in with just a message post in the chat tool used daily. This article explains how to set up the flow for automatically registering clock-in status in HRMOS Attendance when a message is posted in Google Chat, and the benefits of implementing it. Let's aim for more efficient daily operations and accurate attendance management.
Recommended for:
- Those using Google Chat and HRMOS Attendance
- HR and general affairs personnel who want to simplify employee attendance management
- Business owners who want to improve the accuracy of working hours management
- IT personnel who want to automate their company's business processes using API integration
Benefits and examples of integrating Google Chat and HRMOS Attendance:
1. Consolidating attendance applications into chat tools
By implementing this automated flow, you can consolidate operations related to attendance into the chat tool used daily. For example, teams that have been communicating via chat tools had to perform greetings and clock-in operations using different apps. By posting a message about clock-in to Google Chat, clock-in registration can be automatically done on the HRMOS Attendance side, eliminating the need for extra operations.
2. Preventing missed clock-ins
With traditional manual clock-ins, logging into the attendance app was also necessary, and when other tasks were busy, clock-in processing could be forgotten, causing attendance managers to struggle with not being able to grasp accurate clock-in times. For example, if sending messages to Google Chat becomes a habit, appropriate clock-ins can be performed just by posting specific messages, allowing attendance status to be clocked without logging into the attendance app each time. Attendance managers can save the effort of checking whether clock-ins are done correctly, potentially allocating the saved time to other tasks.
3. Reducing confirmation tasks
For example, if clock-ins are not completed correctly, labor personnel had to send separate confirmation messages to employees, and the time spent investigating the days when the target employees forgot to clock in could cause work to stagnate. By automating clock-in registration, you can clock in attendance status by posting messages to the chat tool, and when cross-referencing clock-in information, you can confirm the correct information by referring to the chat history.
Now, let's create a flow bot using the "Register clock-in in HRMOS Attendance when a message is posted in Google Chat" template.
[About Yoom]
How to register clock-in in HRMOS Attendance when a message is posted in Google Chat:
By utilizing the Google Chat API, it is possible to automatically perform clock-in processing via the HRMOS Attendance API based on the content after posting a message to a specific space in Google Chat. Generally, programming knowledge is required to achieve this, but it can be easily realized without programming knowledge by using the no-code tool Yoom.
The work until the flow is completed proceeds as follows:
- My app integration of Google Chat and HRMOS Attendance
- Copy the template
- Check the trigger settings and branching actions of Google Chat, and set each operation of HRMOS Attendance
- Turn on the trigger
If you are not using Yoom, please register for free from here. If you are already using Yoom, please log in.
・Integrate Google Chat and HRMOS Attendance with My Apps
(1) First, connect Google Chat to My Apps. After logging into your Yoom account, click "My Apps" on the left panel and search for Google Chat (OAuth) from "New Connection".
(2) When the Google Chat (OAuth) app icon appears, click on it.
(3) Click "Sign in with Google" to proceed to the following screen.
(4) Refer to this article to obtain the "Client ID" and "Client Secret" information. After obtaining them, enter the "Client ID" and "Client Secret" information and click [Register]. This completes the connection of Google Chat (OAuth).
・Integration with Google Chat is only possible if you are using Google Workspace. For more details, please refer to this page.
(5) Next, let's connect HRMOS Attendance. Search for the HRMOS Attendance app in the same way as the new connection for Google Chat (OAuth).
(3) Enter the "Account Name", "API Key", and "Company Name" for the HRMOS Attendance you want to integrate, and click [Add]. If the setup is successful, you will be taken to the My Apps screen of your Yoom account with the two apps added. Now, the two apps are connected to your Yoom account.
・Copy the Template
After confirming that the new connection of the target app to your Yoom account is complete, click the icon for "Try this template" in the template below.
The template will be copied, so click the "OK" button.
Move to the "My Projects" screen of your Yoom account and check the template content.
The setup flow includes four branching actions.
・Google Chat Trigger Setup
(1) First, set up the Google Chat that will act as the trigger.
From "My Projects" on the left side of your Yoom account screen, click "【Copy】Register a time stamp in HRMOS Attendance when a message is posted on Google Chat".
After clicking, the template content will be displayed as shown in the screen below.
※This flow includes an action to link with Yoom's database, so before using the template, you need to register and set the 【Resource Name of Google Chat Sender】, 【Chat Tool ID】, and 【HRMOS Attendance User ID】 in each database.
(2) First, click "When a message is sent to the space", which acts as the trigger.
(3) Enter the account information of the Google Chat to be linked and click [Next].
(4) On the next screen, set the "Trigger Activation Interval" and "Space Resource Name". Select any of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes for the "Trigger Activation Interval". ※The trigger activation interval varies depending on the plan, so be careful.
(5) After entering the information, click [Test] and if there are no issues, click [Save]. In this step, you can obtain the following output. (The content is an example.)
・Confirm Branching Actions
(1) The second branching action is already set. Click "Command Operation" and check the settings.
(2) As shown in the screen below, this template specifies "Operation: When a message is sent to the space" → "Output: Message Content" as the branching target output.
Set "Output" and "Branching Conditions" as needed according to the situation. (In this case, it is set to process if the message content includes "Attendance".This information needs to be communicated to users in advance.)
・Branching is a feature (operation) available with a Mini Plan or higher. If you are on a Free Plan, the operation of the flow bot you have set will result in an error, so please be careful. ・Paid plans such as the Mini Plan offer a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations). ・For more information on branching, please check this page.
・Link with Yoom Database
(1) Next, click the third action "Retrieve Record".
(2) In this flow, it is necessary to link with Yoom's database to retrieve information that matches the conditions from the table in Yoom's database. It is assumed that the pre-settings have been made in Yoom's database as shown in the screen below.
For information on how to create a database, please check this page.
In this case, the Google Chat account ID is registered in "Chat Tool_ID" as shown in the image. Similarly, register the name of the target employee and the HRMOS Attendance User ID. In 'Database Linking', select the target "Project", "Database", and "Table" from the dropdown menu. (The following is an example.)
(3) After setting the target database, click [Next].
(4) On the next screen, set to retrieve records that match the conditions from Yoom's database. In this case, it is assumed that if the Chat Tool ID is judged to be equal, the resource name information of the sender will be retrieved, and the setting is made. As shown in the red frame part of the image below, you can quote the output obtained in the previous step by clicking the input bar.
(5) After setting, click [Test] and if there are no issues, click [Save]. For information on how to set "Operate Database", please check this page.
・HRMOS Attendance Settings
(1) Finally, click the fourth action "Register Time Stamp".
(2) Enter the account of the HRMOS Attendance to be linked and click [Next].
(3) On the next screen, enter information in fields such as "Company Name" and "User ID". The "User ID" can utilize the output obtained from the previous step. (In this case, the value of 'HRMOS Attendance_User ID' set in Yoom's database in advance is set.)
(4) The "Time Stamp Category" can be selected from the dropdown menu. Since we are registering an attendance time stamp this time, select "Attendance". (Customize according to your operation.)
(5) After entering the information, click [Test] and if there are no issues, click [Save]. This completes the setup.
・Turn ON the Trigger
By clicking the red frame part "Turn ON Trigger" on the screen below, the flow bot will start automatically.
Here is the template used this time
Other Automation Examples Using HRMOS Attendance
There are other examples of automation using HRMOS Attendance on Yoom, so here are a few introductions.
Detect Missed Punches from the Previous Day with HRMOS Attendance and Notify on Google Chat
By implementing this flow, you can quickly detect missed attendance from the previous day and automatically notify Google Chat. With notifications, you can notice missed attendance early and respond promptly.
Register a Clock-in on HRMOS Attendance When a Message is Posted on Chatwork
This flow is recommended for those who use Chatwork for business communication. When a message is posted in a specific Chatwork room, it can automatically register a clock-in on HRMOS Attendance, eliminating the need to log in to HRMOS Attendance each time. If you check Chatwork when you start work, you can register a clock-in on HRMOS Attendance while checking messages.
Register a Clock-in on HRMOS Attendance When a Message is Posted on Microsoft Teams
After a message is posted in a specific channel on Microsoft Teams, you can automatically register a clock-in on HRMOS Attendance, reducing the chances of employees missing their clock-ins. Since clock-ins can be performed directly from Microsoft Teams, it allows for timely clock-ins upon starting work.
Summary
By integrating Google Chat and HRMOS Attendance as introduced this time, you can register attendance status to the attendance management tool just by posting a message in the chat tool you usually use, simplifying the clock-in registration process for employees. By adopting this flow, it will likely lead to a reduction in the workload of attendance managers and prevention of any missed clock-ins. It can be easily set up with no code, making it possible to implement without any special IT skills.
Please take advantage of Yoom to experience automation through app integration.
The person who wrote this article
k.ueno
Until now, as customer support, we have made efforts to resolve users' questions and concerns.
I was moved to learn that by using Yoom, tasks that are becoming increasingly complicated on a daily basis will progress quickly!
From now on, we will continue to distribute content with easy-to-understand content so that people who aim to improve work efficiency can use the service smoothly.
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated. With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.
Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
.avif)
.avif)
.avif)
.avif)
