How to register an employee in Deel when a row is added in Google Sheets by integrating Google Sheets with Deel

Google Sheets is a convenient tool that enhances team work efficiency as it allows multiple people to edit simultaneously. It can be accessed online from anywhere, making it a handy tool for busy business professionals.
However, if you are managing employee information with Google Sheets, manually registering each addition to Deel can become a factor that hinders efficiency.
This article explains the benefits of integrating Google Sheets with Deel and how to set it up.

Recommended for

The content introduced this time is recommended for the following people!

Those who use Google Sheets and Deel in their work
Those who are spending time on manual data entry and cannot focus on their main tasks
Those who want to use IT tools to streamline information sharing between multiple departments

Benefits and Examples of Integrating Google Sheets and Deel

Benefit 1: Reduction of Human Errors

Manual data entry is prone to errors. Especially when entering the same information into multiple systems, input errors and omissions are likely to occur.
For example, in the HR department of a company expanding globally, if all employee information, including overseas employees, is managed with Google Sheets, during busy periods or when accepting multiple new employees, the volume of information increases, making errors more likely.
Moreover, when dealing with overseas employee information, differences in name notation and address formats can complicate manual registration, increasing the likelihood of human error.
By introducing automation, a reduction in human errors that occur during manual data entry and transcription can be expected.
As a result, the consistency of employee information is maintained, and data management can be carried out more smoothly.

Benefit 2: Reducing the Workload of Staff

Routine data entry tasks can be a significant burden for staff.
For example, when managing new employee information with Google Sheets, during periods of organizational expansion or new graduate hiring seasons, when there is a need to register a large number of employee information in a short period, a lot of time is spent on data entry, potentially delaying other important tasks.
With automation, employees can be automatically registered to Deel, allowing staff to use the time previously spent on data integration for other tasks.
Additionally, the time spent on data transcription can be used for more strategic and creative tasks, such as considering measures to improve employee engagement.
As a result, it is expected to reduce the burden on staff while also improving the performance of the entire organization.

Benefit 3: Speeding Up Information Sharing

Manual information sharing inevitably results in time lags.
For example, even if the HR department enters new employee information into Google Sheets, it may take time for that information to be communicated to the accounting department or other related departments and registered in Deel.
Delays in information sharing can have a serious impact on business progress, especially when payroll deadlines are approaching or during busy periods of concentrated employee hiring.
By utilizing app integration, information can be shared quickly.
This will facilitate smooth collaboration between departments, allowing the HR department and related departments to fulfill their respective roles.

In this article, we will proceed with integration using Yoom.
If you haven't used it yet, please take a look at Getting Started with Yoom.

Now, let's explain how to use the no-code tool Yoom to [Register employees to Deel when a row is added in Google Sheets].

[What is Yoom]

How to Create a Google Sheets and Deel Integration Flow

It is possible to achieve this by receiving the addition of a row in Google Sheets using the Google Sheets API and registering employees to Deel using the API provided by Deel.
Generally, programming knowledge is required to achieve this, but with the no-code tool Yoom, it can be easily achieved without programming knowledge.

The integration flow is broadly created through the following processes.

Register Google Sheets and Deel as My Apps
Set up a trigger to activate when a row is added in Google Sheets
Configure settings to register employees in Deel
Test and verify

Step 1: My App Integration with Google Sheets and Deel

First, log in to your Yoom account.
If you don't have an account, please create one on the Yoom account creation page.

1. Click on My Apps, then click on New Connection.

2. You can search by app name in the input field.
This time, search for Google Sheets and Deel respectively and register them.

Register Google Sheets as My App

Let's start by registering Google Sheets. Enter Google Sheets in the input field, and when the Google Sheets icon appears, click on it.

1. The following screen will appear.
Click "Sign in with Google".

2. Select the account you want to integrate.

3. Review the content and click "Next".

4. Review the content and click "Continue".
This completes the registration of Google Sheets as My App.

Register Deel as My App

Similarly, search for Deel and click on the icon.

1. The Deel login screen will appear. Log in with the account you want to integrate.

This concludes the registration of Google Sheets and Deel as My Apps.

Once the My App registration is successful, the following screen will appear.
Check if the icons for Google Sheets and Deel are displayed on the My Apps screen.

For more detailed information about Yoom, please check the Yoom Help Center.

Select a Template and Prepare Storage Location

Click "Try it" from the link below.

If the following message appears, the template copy was successful.

Step 2: Setting up a trigger to activate when a row is added in Google Sheets

This time, since we are using Google Sheets as an app trigger, please refer to the following link.

Notes on using Google Sheets as an app trigger

1. First, click on "When a row is added" at the top.

2. You can set the title freely.
Enter the account information to link with Google Sheets.
Select "When a row is added" as the trigger.
Once you have finished entering, click "Next".

3. Set each item.
You can select the trigger activation time interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
*Please check as the shortest activation interval varies depending on the plan.
Spreadsheet ID, Sheet ID will show suggestions when you click the input field, so please select from them.
Once the settings are complete, click "Test" and if there are no issues, click "Save".

Step 3: Setting up invoice creation in Deel

1. Return to the flow. Next, click the "Create Direct Employee" icon.

2. Enter the account information to link with Deel.
Select "Create Direct Employee" as the action.
Once you have finished entering, click "Next".

3. Set each item. Be sure to enter the required fields.
When you click the input field, the outputs and suggestions obtained earlier will be displayed, so please use them as needed.
For example, in the following screen, you can add an Email by referencing information from Google Sheets.
Once the settings are complete, click "Test" and if there are no issues, click "Save".

4. Finally, click the "Update Record" icon.

5. Enter the account information to link with Google Sheets.
Select "Update Record" as the action.

6. Set up the database integration.
When you click the input field for Spreadsheet ID and Spreadsheet tab name, suggestions will be displayed, so please select from them.
Once the settings are complete, click "Next".

7. Set the values for the record you want to update.
When you click the input field, the output will be displayed, so please use it as needed.
In the following case, the No. obtained from Google Sheets is inserted.

8. Set the values for the updated record.
The Employee ID obtained from Deel will be inserted into Google Sheets.
Once the settings are complete, click "Test" and if there are no issues, click "Save".

9. With this, the flow of [Register an employee in Deel when a row is added in Google Sheets] is complete.

Step 4: Testing and Confirmation

Once the setup is complete, the following screen will be displayed.
Click the "Turn on Trigger" button to activate the flow bot.

With Yoom, the setup is completed without code, so even IT beginners can start using it smoothly.
Try this convenient flow from the link below.

Other Automation Examples Using Google Sheets and Deel

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

1. This is a flow where an EOR contract is created in Deel when a row is added in Google Sheets.
By utilizing this template, when new personnel information is registered in Google Sheets, it is automatically reflected in Deel.
This eliminates the need to re-enter information related to the EOR contract, reducing work time and allowing recruitment and contract-related tasks to proceed more smoothly.

2. This is a flow for creating a contract in Deel when a row is added in Google Sheets.
‍ By utilizing this template, a contract will be automatically created in Deel whenever new employee information is registered in Google Sheets.
This eliminates the need to enter the same information multiple times and reduces the time required to create contracts.

3. This is a flow for updating employee personal information in Deel when a row is updated in Google Sheets.
In the flow introduced this time, new employees were registered, but by utilizing this template, you can update employee information.
This ensures that the latest information is automatically reflected, maintaining data accuracy and allowing for smooth management of employee information.

Summary

By integrating Google Sheets with Deel, you can now automatically register employees on Deel when a new row is added to Google Sheets.
This not only reduces the effort required for registration tasks but also speeds up the entire business process.
Yoom is a tool that allows beginners to easily start automation without the need for complex operations or specialized knowledge.
By utilizing templates, you can start using it immediately without complicated settings, making it reassuring for first-time users.
Leveraging Yoom to create an environment where you can focus on more important tasks will further accelerate business growth.