How to integrate Google Sheets with Deel to create a contract in Deel when a row is added in Google Sheets
How to Integrate Applications
・
2025/01/09
How to integrate Google Sheets with Deel to create a contract in Deel when a row is added in Google Sheets
k.ueno
Creating and managing contracts, which are part of daily operations, can be time-consuming and labor-intensive when done manually, often leading to errors. By using Yoom to integrate Google Sheets with Deel, you can automatically generate contracts in Deel based on the information added in Google Sheets, ensuring accurate information processing. Additionally, since the work can be completed solely through Google Sheets, it reduces the burden on the person in charge and enables centralized information management. This article explains how to set up an automated flow that creates a contract in Deel when a row is added in Google Sheets, and the benefits of implementing it. By incorporating this into your operations, you can achieve time savings in contract creation and prevent human errors, so please take a look.
Recommended for
Those using Google Sheets and Deel
Managers looking to streamline contract management tasks
Those who want to simplify employment management for freelancers and remote workers
Legal personnel who want to prevent human errors in contract creation
Those aiming to speed up the hiring process
Benefits and Examples of Integrating Google Sheets and Deel
1. Improved Operational Efficiency and Enhanced Information Sharing
By adopting this flow, it becomes easier to check and understand the contract creation status on Deel from the Google Sheets side. For example, when the HR department enters new contractor information into Google Sheets, a contract is automatically generated in Deel, and then the contract ID and other details are added to the same Google Sheets. Legal and administrative department personnel who have access to Google Sheets can quickly verify the contract details, making it easier to grasp the contract creation status.
2. Increased Speed of the Contract Process
By implementing this automated flow, contracts are automatically created just by adding information to Google Sheets, reducing the response time in the hiring process. For example, when hiring overseas personnel, if the new employee's information is managed in Google Sheets, contracts can be automatically created in Deel just by entering the information, allowing both the hiring manager and the new employee to proceed with the contract process while minimizing waiting time.
3. Prevention of Human Errors
When manually transferring data, human errors such as omissions are likely to occur. By automatically reflecting the information entered in Google Sheets in Deel, these errors can be prevented in advance. For example, if important information such as contract duration is pre-set in the Google Sheets fields, it will be accurately reflected in Deel's contract upon data entry. Managing highly accurate information may help prevent issues with employees or clients.
Now, let's create a flow bot using the template "Create a contract in Deel when a row is added in Google Sheets".
[About Yoom]
How to Create a Contract in Deel When a Row is Added in Google Sheets
This can be achieved by receiving the addition of a row in Google Sheets using the Google Sheets API, creating a contract in Deel using Deel's API, and then adding the created contract information back into Google Sheets. Generally, programming knowledge is required to achieve this, but with the no-code tool Yoom, it can be easily accomplished without programming knowledge. The process to complete the flow is as follows:
Integrate Google Sheets and Deel with My Apps
Copy the template
Set triggers in Google Sheets and configure Deel
Turn the trigger ON
If you are not using Yoom, please register for free from here. If you are already using Yoom, please log in.
・Connect Google Sheets and Deel to My Apps
(1) First, connect Google Sheets to My Apps. After logging into your Yoom account, click on "My Apps" in the left panel and search for Google Sheets from "New Connection".
Search for the Google Sheets app icon and click on it.
(2) Click "Sign in with Google" to proceed to the account selection screen, and choose the account you want to connect 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, connect the Deel app. Select Deel in the same way as registering Google Sheets to My Apps.
(4) Proceed to the Deel login screen, enter your "Email Address" and "Password", and click [Log in].
(5) After clicking, an authentication code will be issued. Enter the received code to complete the authentication.
Once authenticated successfully, you will be redirected to the My Apps screen of your Yoom account with the two apps added. Now, the two apps are connected to your Yoom account.
・Copy the Template
After confirming that the new connection of the target app to your Yoom account is complete, click the icon for "Try this template" below.
The template will be copied, so click the "OK" button.
Please move to the "My Projects" screen of your Yoom account and check the template content.
There are three setup flows.
In this article, we assume that you have created the following Google Spreadsheet in advance and will eventually update the record information (Contract ID) of the specified item. (As a test, dummy information is inserted and configured. Information is added to the [Contract ID] item.)
・Google Spreadsheet Trigger Settings
(1) First, set the app trigger for Google Spreadsheet.
From the "My Projects" on the left side of your Yoom account screen, click "【Copy】Create a contract in Deel 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 on the trigger "When a row is added". (3) Enter the account information to be linked and click [Next].
(4) On the next screen, enter information such as "Trigger Interval" and "Spreadsheet ID". Select any of the options from 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.
(5) 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 make use of this information.
(6) After entering the information, click [Test] and if there are no issues, click [Save]. At this step, you can obtain the following information as output. As noted, "This value can be used in other operations," you can reference and utilize this output information in the subsequent steps.
Regarding the behavior during testing when setting Google Spreadsheet as an app trigger, please check this page in advance.
・Deel Settings
(1) Next, click on the second action "Create Contract".
(2) Enter the account information to be linked and click [Next].
(3) On the next screen, enter information in fields such as "Contract Title". Click the input bar to reference the output obtained in the previous step.
(4) "Contract Type" and "Scale" can be selected from the dropdown according to your operation.
(5) After entering information in the necessary fields, click [Test] and if there are no issues, click [Save].
(6) Finally, click the third action "Update Record".
(7) On the next screen, confirm that the Google Spreadsheet account information is entered. Scroll down to find the "Database Integration" section and enter the relevant information. You can expand the information obtained from the linked account as "candidates", so let's make use of this as well.
(8) After entering the information, click [Next].
(9) On the next screen, set up to retrieve records that match the conditions from the specified table in Google Spreadsheet and update the value of the top record in the response results. As an example, for "① Condition of the record you want to update", specify 'No.' for the record you want to update, set the condition to 'equal', and set the information that matches the condition to 'No.' (using output).
(10) Next, set the "② Value of the record after update". The value set in "① Condition of the record you want to update" will be updated to the value set here. Click the input bar and set the relevant information. As shown in the screen below, you can also use the output. This time, we assume that record information will be added to the Contract ID field, so we set the [Contract ID] obtained in the second action in the "Contract ID" section.
(11) After entering the information, click [Test] and if there are no issues, click [Save]. This completes the setup.
By running this flow bot, information will be added to the red-framed part of the Google Spreadsheet.
・Turn on the Trigger
By clicking the red-framed "Turn on Trigger" on the screen below, the flow bot will start automatically.
Here is the template used this time
Other Automation Examples Using Google Sheets and Deel
There are other examples of automation using Google Sheets and Deel on Yoom, so let me introduce a few.
Register Employees in Deel When a Row is Added in Google Sheets
This flow is recommended for those managing information of overseas personnel with Deel. When new employee information is registered in Google Sheets, the same information is automatically reflected in Deel, eliminating the need for double entry and reducing working time.
Create an EOR Contract in Deel When a Row is Added in Google Sheets
You can automatically create an EOR contract in Deel simply by updating a row in Google Sheets. By automating the process, there's no need to re-enter information related to EOR contracts in Deel, which reduces work time and allows for smoother operations. Additionally, it helps prevent human errors such as missing registrations or incorrect entries.
Update Employee Personal Information in Deel When a Row is Updated in Google Sheets
This flow automatically updates personal information in Deel after employee personal information is updated in Google Sheets. By preventing manual update omissions and input errors, it enables centralized management of highly accurate information.
Summary
By incorporating the integration of Google Sheets and Deel introduced this time into your work, you can automatically create contracts on the Deel side with just operations in Google Sheets, achieving efficiency in contract work. Additionally, it reduces the time spent on manual contract creation and data entry, minimizing human errors, allowing the person in charge to focus on more important tasks. Furthermore, it contributes to speeding up the processing time of regularly occurring recruitment tasks and facilitates smooth information sharing between teams.
Please take advantage of Yoom to experience automation through app integration.
The person who wrote this article
k.ueno
Until now, as customer support, we have made efforts to resolve users' questions and concerns.
I was moved to learn that by using Yoom, tasks that are becoming increasingly complicated on a daily basis will progress quickly!
From now on, we will continue to distribute content with easy-to-understand content so that people who aim to improve work efficiency can use the service smoothly.
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated. With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.
Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
.avif)
.avif)
