How to integrate Google Sheets with Deel to update employee personal information in Deel when a row is updated in Google Sheets

In today's globalized world, companies increasingly need to efficiently manage a multinational workforce. By using Yoom to integrate Google Sheets with Deel, you can automatically update employee information in Deel whenever a row is updated in Google Sheets. This eliminates the need for manual updates, reducing the workload for those responsible. It also helps prevent human errors such as update mistakes or incorrect entries. This article explains how to set up a flow that automatically updates employee personal information in Deel when a row is updated in Google Sheets, and discusses the benefits of implementing this system.

Recommended for

Those who use both Google Sheets and Deel
Business owners who manage employee information with Deel and aim to improve operational efficiency
HR personnel who feel burdened by international talent management in global operations
Team leaders who want to share the latest information and make quick decisions

Benefits and Examples of Integrating Google Sheets with Deel

Benefit 1: Improved Operational Efficiency

By integrating Google Sheets with Deel, updating a row in Google Sheets automatically updates employee information in Deel.
For example, simply entering new employee information into Google Sheets will automatically register it in Deel.
This eliminates the need for manual entry, allowing those responsible to focus on other important tasks, thereby improving operational efficiency.

Benefit 2: Centralized Global Talent Management

Incorporating the integration of Google Sheets and Deel can simplify employee information management for companies with global operations.
For instance, when a representative from an overseas branch enters employee information into Google Sheets, it is automatically reflected in Deel, making cross-border data management easier.
This allows for centralized employee information management and is expected to reduce the burden of managing different regulations and languages in each country.

Benefit 3: Smooth Sharing of Employee Information

With the integration of Google Sheets and Deel, when employee personal information is updated in Google Sheets, it is automatically reflected in Deel.
For example, if there is a change in an employee's address, the HR personnel can simply enter it into Google Sheets, allowing the payroll manager to quickly verify the new address for sending pay slips in Deel.
This enables quick verification of the latest information, enhancing information sharing.

[About Yoom]

How to Update Employee Personal Information in Deel When a Row is Updated in Google Sheets

This can be achieved by using the Google Sheets API to receive updates from Google Sheets and the API provided by Deel to update employee personal information in Deel. Generally, programming knowledge is required to implement this, but with the no-code tool Yoom, it can be easily achieved without programming knowledge.

We will create this in the following major processes:

Register Google Sheets and Deel as My Apps
Copy the template
Set up the trigger in Google Sheets as the starting point of the flow, followed by the operation settings in Deel
Turn on the trigger button and verify the integration operation between Google Sheets and Deel

If you are not using Yoom, please register for free here.
If you are already using Yoom, please log in.

Step 1: Connect Google Sheets and Deel with My Apps

Register My Apps to connect Google Sheets and Deel to Yoom.
By registering My Apps first, you can easily set up automation.

First, register Google Sheets with My Apps.
Click "My Apps" → "New Connection" on the left side of the Yoom screen.

An app list and search bar will be displayed, so use either to select Google Sheets.
When the following screen appears, click "Sign in with Google."

After signing in, grant access.

This completes the My Apps connection for Google Sheets.

Next, proceed to register Deel with My Apps.
Similarly, find Deel from the app list or search for it in the search bar.

Enter your "Email Address" and "Password," then click "Log in."

Once both My Apps registrations are complete, Google Sheets and Deel will appear in My Apps.

Next, let's proceed with the setup using the Flowbot template.
Log in to Yoom and click "Try it" on the banner below.

The message "Template has been copied!" will be displayed, and clicking "OK" will complete the copy process.

Step 2: Set the Trigger

Next, set the trigger for Google Sheets. Please click "When a row is updated".

Please check the "Account information to integrate with Google Sheets".
You can freely change the title, but leave the trigger action as is and click "Next".

Next, set up the "App Trigger API Connection".
You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
Please note that the shortest trigger interval varies depending on the plan.

Please select the "Spreadsheet ID" and "Sheet ID" from the options.

Please make optional settings for the following items.

After setting, run the test, and information will be displayed in the output.
Confirm that the information is displayed and click "Save".

Step 3: Set the Action

Next, set the action for Deel. Click "Update Personal Information".

Next, check the "Account information to integrate with Deel".
You can freely change the title, but do not change the execution action.

Set up the "API Connection".
You can input the output information obtained from the "App Trigger API Connection" into each item's "Output".
By setting the output of Google Sheets, employee information will be automatically reflected in Deel.
Please set the output that matches the item.

After setting, click "Test", and if "Test Successful" is displayed, click "Save".

Step 4: Verify the Automation between Google Sheets and Deel

Finally, click "Turn on Trigger" to complete the automation setup.
Now, when a row is updated in Google Sheets, the employee's personal information in Deel will be automatically updated.

Here is the template used this time.

Other Examples of Automation Using Google Sheets

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

1. A Flow to Notify LINE When a Row is Updated in Google Sheets

With this integration, a notification is automatically sent to LINE when a row is updated in Google Sheets.
For example, when a person in charge updates information in Google Sheets, a notification is sent to LINE, allowing team members to quickly check the updated information.
This helps prevent any oversight in information verification and strengthens information sharing.

2. Flow to Register Employee Information in HRMOS When Added to Google Sheets

With this integration, employee information added to Google Sheets can be automatically registered in HRMOS.
For example, if an HR representative is manually entering employee information, automation can help reduce that time.
This can prevent human errors such as update mistakes or incorrect entries, and improve operational efficiency.

3. When an event is added to Google Sheets, it is also registered in Google Calendar

With this integration, when an event is added to Google Sheets, it can be automatically registered in Google Calendar.
For example, sales representatives who frequently travel can prevent missing entries in their calendar because events added to Google Sheets are automatically registered in Google Calendar.
This can eliminate the manual task of adding events to the calendar, leading to improved work efficiency.

Summary

The integration of Google Sheets and Deel supports operational efficiency, centralized management of international talent, and real-time sharing of employee information.
This is expected to simplify information management, reduce human errors, and enhance information sharing.

Additionally, Yoom's app integration can be set up without any coding, allowing anyone to get started immediately. Please consider implementing it.