How to integrate Google Sheets with BambooHR to automatically add employee information to BambooHR after adding a row in Google Sheets

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

Those who want to automatically upload files attached to Gmail to Dropbox
Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

BambooHR and Google Sheets will be essential tools for managing information.
However, when using different apps to manage information, transcription errors and incorrect entries are inevitable.
By implementing this automation flow, it is expected to prevent human errors, reduce working time, and become a useful tool for companies aiming to streamline labor tasks.
This article will detail the benefits of automating the addition of employee information.

Recommended for

‍・HR personnel at companies with a large number of employees and frequent new hires
・Department heads looking to reduce data entry errors
・HR personnel struggling with manual entry mistakes and duplicate registrations
・Those who want to link Google Sheets and BambooHR to reduce the hassle of data updates

Benefits and Examples of Integrating Google Sheets and BambooHR

1. Saving Work Time

Every time new employee information is added to Google Sheets, it can be automatically reflected in BambooHR, eliminating manual entry tasks.
For example, registering and updating employee information used to be time-consuming, but by automating this process, HR personnel may be freed from simple data entry tasks and focus on other important duties.
This brings significant benefits, especially for companies with a large number of employees or frequent new hires.

2. Reducing Errors

When entering data manually, human errors (such as typos, omissions, or duplicate registrations) are likely to occur, but integrating Google Sheets and BambooHR can minimize these errors.
For example, by registering employee information in Google Sheets and automatically reflecting the data in BambooHR, incorrect information registration and duplicate registrations can be prevented.
Managing reliable HR data is crucial, especially for companies with many employees.

3. Quick Information Reflection

Employee information changes daily, so updating it manually is time-consuming and poses a risk of missing updates.
By linking Google Sheets and BambooHR, employee information changes can be kept accurate and up-to-date.
As a specific example, whenever information such as an employee's emergency contact is updated on the Google Sheets side, the hassle of updating BambooHR each time can be eliminated, reducing the time lag in operations.
The frequency of employees inquiring about procedures with the HR and labor departments may decrease, allowing them to focus on their work with peace of mind.

[About Yoom]

Now, let's create a flowbot using the template for "Adding Employee Information to BambooHR When a Row is Added in Google Sheets".

How to Create a Workflow for Integrating Google Sheets and BambooHR

The process to complete the workflow will proceed as follows.

・Integrate Google Sheets and BambooHR with My Apps
・Copy the template
・Set up triggers in Google Sheets and configure BambooHR
・Turn on the trigger

Now, let's establish a new connection for the apps you want to integrate.

・Integrate Google Sheets and BambooHR with My Apps

(1) First, connect Google Sheets to My Apps.
After logging into your Yoom account, click "My Apps" on the left panel and search for Google Sheets from "New Connection".

‍

‍

Search for and click on the Google Sheets app icon.

‍

‍

‍

(2) Click "Sign in with Google" to proceed to the account selection screen, then choose the account you want to integrate from the right management account.
After selection, proceed to the sign-in screen and complete the authentication.
The first Google Sheets connection is now complete.

(3) Next, integrate the BambooHR app.
Select BambooHR in the same way as registering Google Sheets in My Apps.

‍

‍

(4) Enter the "Account Name", "Company Domain", and "API Key" for the BambooHR you want to integrate, then 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, both apps are connected to your Yoom account.

・Copy the Template

After confirming that the new connection of the target app is complete in your Yoom account, click the icon for "Try this 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.

‍

‍

There are two setup flows.

・Google Spreadsheet Trigger Setup

(1) First, set up the Google Spreadsheet app trigger.

‍

‍

From "My Projects" on the left side of your Yoom account screen, click "【Copy】Add employee information to BambooHR when a row is added in Google Spreadsheet".

‍

‍

After clicking, the template content will be displayed as shown in the screen below.

‍

‍

(2) First, click the trigger "When a row is added".

‍

(3) Enter the account information to be linked and click [Next].
On the next screen, enter information such as "Trigger Interval" and "Spreadsheet ID".

Select any of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes for the "Trigger Interval".
*Note that the trigger interval varies depending on the plan.

‍

‍

(4) For the "Spreadsheet ID" and "Sheet ID" fields, click the input bar to expand the information obtained from the account as "candidates" as shown in the screen below.
Let's also utilize this information for reference.

‍

‍

(5) After entering the information, click [Test] and if there are no issues, click [Save].
In this step, you can obtain information as output as shown below.
The output information can be referenced and utilized in the subsequent steps, as noted by "This value can be used in other operations."

‍

‍

・BambooHR Setup

(1) Finally, click the second action "Add New Employee".

‍

‍

(2) Enter the account information to be linked with BambooHR and click [Next].

‍

‍

(3) On the next screen, enter information such as "First Name" and "Last Name".
Click the input bar to select the output.
As an example, below is the information of 【First Name】 and 【Last Name】 obtained from the previous step, referenced and set.

‍

‍

(5) After setting, 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 the Trigger" on the screen below, the flowbot will start automatically.

‍

‍

Here is the template used this time

Other Automation Examples Using Google Sheets

There are other examples of automation using Google Sheets on Yoom, so here are a few introductions.

Update Employee Information in BambooHR When a Row is Updated in Google Sheets

When you update the registration information in Google Sheets, it is automatically reflected in BambooHR, reducing the effort required for updating tasks.
This allows for smooth business operations and is expected to help avoid human errors.

Register in HRMOS when employee information is added to Google Sheets

Based on the employee information registered in Google Sheets, the registration in HRMOS can be completed, which is expected to reduce manual work time.
Additionally, using the quoted content helps prevent human errors.

Update SmartHR Employee Information When a Row is Updated in Google Sheets

This flow is recommended for those who want to automate the process of updating employee information.
When you update row information in Google Sheets, the employee information in SmartHR is automatically updated, eliminating the need to log in to SmartHR to update the information.

Summary

This automation flow utilizing Google Sheets and BambooHR will greatly contribute to streamlining labor management.
By eliminating the need for manual input and reducing errors, HR personnel in companies can focus more confidently on more important tasks.
This automation is particularly beneficial for companies with a large number of employees or those with frequent new hires.

Please take advantage of Yoom to experience automation through app integration.