How to integrate Google Sheets with HRBrain to update HRBrain whenever employee information is updated in Google Sheets

HRBrain, a service that allows for employee information management, is convenient, but it can feel cumbersome because you need to manually input information when updating it.
Especially when there are many employees, the amount of information to manage increases, which can become a significant burden.
To solve this issue, we have created a flow where when information is updated in Google Sheets, the same information is automatically updated in HRBrain.
This is recommended for the following people.

Feeling the hassle of managing information using both Google Sheets and HRBrain
Wanting to consolidate information in HRBrain but preferring to complete updates in Google Sheets due to familiarity with spreadsheet tools

If you are interested, please refer to the following steps and try automatic integration with Yoom!

Benefits of Integrating Google Sheets with HRBrain

Benefit 1: Prevention of Human Error

When updating information, manually entering data into both Google Sheets and HRBrain increases the risk of input errors or forgetting to update.
For example, "The name was entered correctly in Google Sheets but was incorrect in HRBrain," or "Forgot to update information only in HRBrain."
As a result, data inconsistencies occur, leading to unnecessary effort in correction and verification of accurate information.
By using the integration described in this article, manual work is reduced, contributing to the prevention of human error.

Benefit 2: Enable Centralized Information Management

By utilizing this integration, centralized information management is achieved, offering various benefits.
For instance, since updates can be completed solely through familiar Google Sheets operations, those not accustomed to HRBrain operations may find themselves less confused about the procedure than before the integration, potentially leading to reduced working time.
Additionally, with data consolidated in one place, you can quickly grasp the information you need, which can also lead to faster decision-making.

[What is Yoom]

Integration Flow of Google Sheets and HRBrain

Now, let's introduce the steps to actually integrate Google Sheets with HRBrain.
The specific setup steps are as follows.

Set up the app trigger
Obtain the item ID that constitutes member information
Update member information

Yoom offers the above three steps as a template.
It's easier to create a flowbot than starting from scratch, so first click the "Try it" button on the banner below to copy the template!

Integration of Google Sheets and HRBrain with My Apps

After copying the template, as a preliminary step, register Google Sheets and HRBrain from Yoom's "My Apps".
※ If you have already registered, please proceed to "Step 1. Set App Trigger".

1. After logging into Yoom, click "+ New Connection" from the "My Apps" menu on the left side.

2. Search for the app name, enter the required information, and register the app.

Once Google Sheets and HRBrain appear in the My Apps list, you're all set!
Let's proceed to the detailed settings!

Step 1. Set App Trigger

First, click on the app trigger "When a row is updated".

On the first page, verify the account information that was linked in advance.
If there are no issues, click "Next".

On the next page, set the Google Sheets ID and range.
<span class="mark-yellow">Make sure to set a column with unique values as "Column with Unique Values".</span>
If there are duplicate values within the column, it may not function correctly.‍

Once all fields are filled, click "Test" to check for any errors.
※ The trigger activation interval varies depending on your subscription plan. For details,click here.

If the test is successful, the specified Google Sheets items will be reflected in the output.

※ Note‍

To identify the employee to be updated in Step 3, "Member ID" is required, so make sure to store the Member ID in Google Sheets in advance.

If there are no issues up to this point, click "Save" to complete the trigger settings.

Step 2. Obtain Item IDs that Compose Member Information

Next, click "Obtain Item IDs that Compose Member Information".

On the first page, just like in Step 1, verify only the account information, and if there are no issues, click "Next".

On the second page, obtain the items needed to update member information in Step 3.

If there are no issues after testing, click "Save".

Step 3. Update Member Information

Finally, click "Update Member Information".

As in Step 1 and Step 2, verify the account information on the first page, and if there are no issues, click "Next".

On the next page, set the employee information to be updated.
Use the outputted information to fill in the details.

Click "Test", and if there are no errors, click "Save".

If a popup like the image below appears, all settings are complete.

‍

Other Examples of Automation Using Google Sheets and HRBrain

Yoom offers many automation examples using Google Sheets and HRBrain.
Here are some representative examples.

1. Register in HRBrain when employee information is added in Google Sheets

The integration introduced this time was a flow to automate the update of employee information, but we also provide a template to automate registration.

2. Add a user to Google Workspace when a row is added in Google Sheets

Many people are responsible for issuing Google accounts when new employees join the company.
By using this integration, a Google account is automatically issued when a row is added in Google Sheets, reducing the workload.

3. Retrieve records from Google Sheets that correspond to today's date and send a daily batch notification to Slack

For those using Slack as a communication tool, integration with Google Sheets is recommended.
This integration serves as a reminder notification to prevent overlooking tasks.

Summary

In this article, we automated the process of updating information by integrating Google Sheets with HRBrain.
Since the tasks that were previously done manually are now automated, the risk of human error is expected to be reduced.
Additionally, as the information is centralized, you can quickly access the necessary information, leading to faster decision-making.
As we set up this time, Yoom allows you to configure automatic integration without the need for programming.

If you are interested, please start by registering for free here!