How to integrate Google Sheets with eden LMS to update employee information in eden LMS when a row is updated in Google Sheets

When managing employee information with Google Sheets and eden LMS, there may be challenges in keeping the information updated and knowing the latest details. However, by integrating the two tools, you can centrally manage employee information, which can lead to improved management efficiency and reduced workload. This can be a significant advantage for those looking to streamline HR management. In this article, we will introduce a method to integrate Google Sheets and eden LMS without programming, allowing for automatic reflection of employee information.

Recommended for

Company representatives managing employee information with Google Sheets and eden LMS
Company representatives looking to streamline update tasks for Google Sheets and eden LMS
HR managers aiming to reduce management errors with Google Sheets and eden LMS

Benefits and Examples of Integrating Google Sheets and eden LMS

Benefit 1: Centralized Management of Employee Information

By integrating Google Sheets and eden LMS, you can centrally manage employee information, which can lead to improved operational efficiency. For example, during periods of transfers or relocations, the frequency of employee information updates increases, and HR personnel may wish to reduce manual input tasks as much as possible. By integrating the two tools, updating employee information in Google Sheets will automatically reflect in eden LMS, reducing repetitive manual input tasks. This centralized management can lead to improved management efficiency.

Benefit 2: Maintaining Consistency of Employee Information

By integrating Google Sheets and eden LMS, you can verify the same employee information in both tools. For example, if different tools are used by different personnel to reference employee information, there is a risk of not knowing which information is the latest if there are omissions in updates. However, by integrating the two tools and preventing update omissions in each tool, the consistency of employee information is maintained. Maintaining such consistency can be a significant advantage when managing with a multi-person team.

Benefit 3: Accurate Data Management by Reducing Input Errors

Manual input carries the risk of human error. However, through automation, once information is accurately entered, subsequent input errors can be prevented. For example, when updating information for multiple employees, even if accurate information is entered into Google Sheets, there is a risk of errors occurring when copying and pasting into eden LMS. Management tasks like employee information, where mistakes are not permissible, can minimize human error through automation, leading to improved accuracy of information. As a result, necessary training can be smoothly provided to all employees.

[About Yoom]

Next, we will introduce how to create a flowbot with Yoom, which allows app integration without programming, to "update employee information in eden LMS when a row is updated in Google Sheets." You can implement it by simply setting it according to the template, so please give it a try.

How to Create a Flow for Integrating Google Sheets and eden LMS

The flow to integrate Google Sheets and eden LMS using Yoom proceeds through the following four processes.

・Register Google Sheets and eden LMS as My Apps
・Copy the template
・Set the trigger for the Google Sheets that serves as the starting point of the flow, followed by the update settings for eden LMS
・Turn on the trigger button and verify the integration operation between Google Sheets and eden LMS

Step 1: Integrate Google Sheets and eden LMS into My Apps

First, register Google Sheets and eden LMS into My Apps to integrate them with Yoom.

1. Select "My Apps" on the left side of the Yoom management screen and click "+New Connection".

2. On the following screen, search for "Google Sheets" and "eden LMS" respectively to proceed to the next screen.

＜For Google Sheets＞

・Click "Sign in with Google" on the above screen and select the account to integrate.

・Confirm the account to log in and click "Next".

・Click "Continue" to complete the registration in My Apps.

＜For eden LMS＞

・Enter the account name and access token, then click "Add" to complete the registration in My Apps.
※ For instructions on obtaining the API key required for entering the access token, please check here.

Step 2: Copy the Template

Next, copy the template to integrate Google Sheets and eden LMS.

1. Open the template page below.

2. Click "Try this template".

Step 3: Setting up the Google Spreadsheet as a Trigger Action

Next, set up the Google Spreadsheet that will serve as the starting point for automation.
This flow is triggered when employee information is updated in the Google Spreadsheet.

1. Select "My Projects" in the Yoom management screen and click "Update employee information in eden LMS when a row is updated in Google Spreadsheet".
*The template title can be changed freely on the next screen.

2. Click "App Trigger When Row is Updated".

3. Verify the account linked with Google Spreadsheet and click "Next".
*Other items are set by default.

4. Set the trigger activation interval and the items in the Google Spreadsheet that manage employee information.
*Trigger activation intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes are available, and the selectable time varies depending on the plan.
*For each selected interval, check the trigger action in the app, and if the action is executed, the flow bot will be activated. If you want to update employee information immediately, a shorter interval setting is recommended.
*Spreadsheet ID and Sheet ID can also be selected from "Suggestions" displayed when clicking the frame.

‍

5. If the test is successful, the information retrieved from the Google Spreadsheet will be displayed in the output.
If there are no issues, save it.

Step 4: Setting to Update Information in eden LMS

Finally, set up to update employee information in eden LMS based on the information retrieved from the Google Spreadsheet.

1. Click "Update User to Integrate with App".

2. Verify the account information linked with eden LMS and click "Next".
*Other items are set by default.

3. Set each item in eden LMS and test it.
*Clicking "When Row is Updated" in the output displayed by clicking the frame will display the items retrieved from the Google Spreadsheet. By setting the corresponding items, different information for each employee is dynamically reflected.

4. If the test is successful, save it and turn on the trigger.

From now on, when employee information is updated in the Google Spreadsheet, it will be automatically reflected in eden LMS.
If you have any questions about the flow introduced, please refer to the help page.

Other Automation Examples Using Google Sheets and eden LMS

There are many other examples of automation using Google Sheets and eden LMS at Yoom, so here are a few introductions.

1. A flow to add employee information to eden LMS when a row is added in Google Sheets.

This can reduce the task of registering new employee information in eden LMS.
For companies that hire a large number of new employees, this automation can significantly reduce the time and effort of repetitive data entry, leading to substantial improvements in operational efficiency.

2. This is a flow to delete employee information from eden LMS when a row is updated in Google Sheets.

If you are subscribed to eden LMS with a user ID-based billing plan, leaving the information of employees who have left the company can incur unnecessary charges.
However, by utilizing this automation, you can prevent unnecessary charges caused by forgetting to delete such information.

3. This is a flow to update employee information in BambooHR when a row is updated in Google Sheets.

If you manage employee information in BambooHR as well, this automation allows for centralized management. As a result, updating information in BambooHR becomes more efficient, reducing human errors and alleviating the burden of information management.

Summary

By integrating Google Sheets with eden LMS, centralized management of employee information becomes possible.
As a result, you can expect improved efficiency in administrative tasks, reduced workload, and a decrease in human errors.
This integration can be particularly beneficial for companies where HR information is frequently updated.
With Yoom, you can connect these tools without any coding, lowering the barrier to implementation.

Use this article as a reference to enhance the efficiency of your company's operations.