How to integrate Google Sheets with eden LMS to add employee information to eden LMS when a row is added in Google Sheets

Integrate Google Sheets with eden LMS to automate the cumbersome employee registration process. This automation can prevent manual data entry errors and is expected to enable efficient HR operations. In this article, we will explain in detail how to use the no-code tool Yoom to automatically add employee information to eden LMS when a row is added in Google Sheets, along with its benefits. For rapidly growing companies, smooth management of employee information can be a significant advantage.

Recommended for

・HR department personnel looking to streamline employee information management
・HR teams in companies aiming to optimize the onboarding process for new employees
・Individuals in rapidly growing companies who want to reduce the burden of employee data management
・IT personnel in companies looking to reduce manual data entry errors
・HR department leaders considering the integration of Google Sheets and eden LMS

Benefits and Examples of Integrating Google Sheets and eden LMS

Benefit 1: Reduction of Human Errors

Manual entry of employee information carries the risk of errors due to manual work. For example, mistakes in entering names, department names, or email addresses. Errors can affect subsequent operations, requiring correction work, which ultimately consumes time and resources. However, by integrating Google Sheets with eden LMS, every time new information is added to Google Sheets, it is automatically registered in eden LMS. This eliminates input errors, ensuring accurate data is registered in eden LMS, leading to smoother management of employee information.

Benefit 2: Streamlining the Onboarding Process

When a new employee joins, you want to start training and onboarding programs immediately. By utilizing this automation, new employees can access training materials and learning resources right away. This process will smoothly support new hires in acquiring the necessary skills and knowledge before starting their initial tasks. For example, when new employee information is registered in Google Sheets, it is registered in eden LMS, allowing training to start from the first day of joining. As a result, it can prevent training delays and support employees in becoming productive early on.

Benefit 3: Improving the Burden of Employee Registration

As a company grows, the number of employees increases, making employee information management increasingly complex. Especially in rapidly growing companies, frequent additions and transfers of new employees increase the burden on the HR department. By using this flow, employee information is automatically registered in eden LMS, allowing for handling even when many employees join at once. For instance, even if hundreds of new employees are added, registering employee information in Google Sheets will automatically register them in eden LMS, reducing the time spent on account registration. As a result, even with rapid company expansion, stable operations can be expected without increasing the workload.

[About Yoom]

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

So far, we have introduced the benefits of integrating Google Sheets and eden LMS. Let's quickly use Yoom to integrate the apps used this time! After completing the registration of My Apps, we will create a flowbot to "Add employee information to eden LMS when a row is added in Google Sheets."

This time, we will follow the process below.
Let's set it up together!

Integrate Google Sheets with eden LMS as My Apps.
Copy the template.
Set up the trigger in the Google Sheets that initiates the flow, and then configure the operations in eden LMS.
Turn on the trigger button and verify the operation of the integration flow between Google Sheets and eden LMS.

Step 1: My Apps Integration

Integrating My Apps first will make the subsequent settings proceed smoothly.
First, we will integrate your Google Sheets with Yoom.
Select My Apps → New Connection from the left side of the Yoom page.

Search for Google Sheets and log in.
Then, you will see this screen, so if there are no issues, click Continue.

Next, integrate with eden LMS.
Please refer to this link to set up the access token.

If Google Sheets and eden LMS are integrated into My Apps, you're all set.

Step 2: Set Triggers and Actions

We will proceed using this template.

Open the template page and click on "Try this template".
If you are using Yoom, please log in. If you are new, please register.
Proceed, and the template will be automatically copied to your workspace.
Change the template name as needed.
Click on "My Projects" on the left to see the copied template.
Click the ellipsis (...) on the right and select "Edit".
Items to prepare:
・A Google Spreadsheet where you can register employee information.
Refer to the image for the header.
(Information will be entered during testing.)
Let's set up the app trigger.
Select "When a row is added".
Change the title as desired.
After confirming the account information to be linked, proceed to the next step.
Enter the required fields.

Trigger interval: You can choose from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
※ The selection of intervals varies depending on the plan.

Set the table range to include all, including the header.

Column with unique values
※ Be sure to select a column where values do not duplicate!

Now, move to the Google Spreadsheet for employee information.
Leave the registration status in column G blank.
Enter the other fields.
Return to Flowbot and test.
If the record information from the Google Spreadsheet is reflected in the output, save it.
Next, click on "Add User".
Confirm the account information to be linked.
Proceed to the next step and configure the fields.
Select from the output as follows.
Configure the remaining fields.
This time, set a deadline.
Configure other fields as needed.
Once selection is complete, test and save if successful.
Next, click on "Update Record".
Link the database.
Set the conditions for the record you want to update as follows.
Since you will enter the registration status, set it to "Registered".
Test this as well, and save if successful.
Check the Google Spreadsheet.
The registration status has been successfully reflected.
Thank you for your hard work.
Even someone like me, who is not familiar with programming, was able to proceed easily.
Here is the Flowbot used this time:↓

Other Automation Examples Using Google Sheets and eden LMS

1.Update employee information in eden LMS when a row is updated in Google Sheets flow.

This is an updated version of the current flowbot.
It helps prevent any omissions in updates, such as user IDs and names.

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

This is the deletion version.
It's a hassle to manually delete various accounts after an employee leaves the company, isn't it?
By using this automation, it seems possible to prevent any omissions in deletions.

3.This is the flow to add user information to cybozu.com common management when it is added to Google Sheets.

When joining the company, accounts are created in multiple applications, right?
By using this automation to create accounts and set up user services, it becomes convenient as you can use kintone, Garoon, and others.

Summary

This time, we introduced the flowbot "Add a task to eden LMS when a row is added in Google Sheets".
By integrating Google Sheets with eden LMS, you can expect a reduction in human errors and an improvement in the onboarding process.
For rapidly growing companies, this automation will help reduce workload and support stable operations.
In particular, by utilizing the no-code tool Yoom, you can easily set up the integration without any specialized knowledge.

Please try integrating Google Sheets with eden LMS using Yoom.