Google スプレッドシートとGitLabの連携イメージ
How to Integrate Applications

2025-04-16

How to integrate Google Sheets with GitLab to create a new project in GitLab after adding a row in Google Sheets

k.ueno

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

  • Those who want to automatically upload files attached to Gmail to Dropbox
  • Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
  • Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

When tasks that need to be addressed arise, GitLab is suitable for sharing content with other teams and departments, but many people manage basic information input separately with Google Sheets. The automation flow introduced this time can shorten the time for manual input tasks and reduce human errors, making it a powerful means to make project management more efficient. By incorporating Yoom's app integration to smooth project progress, we will explain how to easily introduce task automation without programming knowledge.

・Those who feel challenged by sharing project information across multiple departments
・Those who want to reduce the risk of data entry errors and transcription errors and proceed with work accurately
・Those who want to improve the task management efficiency of the entire team
・Programming beginners considering business automation
・Those who want to link Google Sheets and GitLab to improve work efficiency

Benefits and Examples of Integrating Google Sheets and GitLab

1. Strengthening Interdepartmental Collaboration

By reflecting Google Sheets information in GitLab, smooth information sharing between different departments becomes possible. For example, when the marketing team enters a new campaign plan into Google Sheets, it is registered as a project in GitLab, allowing the development team and design team to quickly start responding. By quickly recognizing tasks and strengthening collaboration, it will also help prevent work delays.

2. Reducing Manual Work

Automating project creation in GitLab is expected to reduce the time spent on information input. In environments with many remote teams, simply entering new project information into Google Sheets allows projects to be automatically created in GitLab, reducing the time spent on manual input by the person in charge and creating an environment where they can focus on other important tasks. It may also contribute to improving the productivity of the entire company.

3. Maintaining Data Accuracy

By linking Google Sheets and GitLab, information is accurately reflected in GitLab, reducing the need for correction work in case of data entry errors. For example, manual information registration work carries the risk of input errors and transcription errors, and it may have been necessary to reconfirm the content between teams. With the introduction of this automation, when a new project is added to Google Sheets, accurate data is directly reflected in GitLab, enabling correct data management and verification, and staff may spend less time on content confirmation.

What is Yoom?

Yoom is a next-generation automation tool designed for those who want to streamline their daily administrative tasks and improve work efficiency! API integrations can be challenging for non-engineers, but Yoom eliminates the need for technical expertise or complex coding, allowing you to manage apps intuitively in one place with ease.

Sign Up for Yoom Here – Quick and Easy in Just 30 Seconds!

Now, let's actually create a flowbot using the template "Create a new project in GitLab when a row is added in Google Sheets".

How to Create a Google Sheets and GitLab Integration Flow

The tasks to complete the flow will proceed as follows.

・Integrate Google Sheets and GitLab with My Apps
・Copy the template
・Set triggers in Google Sheets and configure each application in GitLab and the subsequent Google Sheets
・Turn on the trigger

Now, let's proceed with the new connection of the apps to be integrated.

・Integrate Google Sheets and GitLab with My Apps

(1) First, connect Google Sheets to My Apps.
After logging into your Yoom account, click "My Apps" on the left panel and search for Google Sheets from "New Connection".

Search for and click on the Google Sheets app icon.

(2) Click "Sign in with Google" to proceed to the account selection screen, and select the account you want to integrate from the management accounts on the right.
After selection, proceed to the sign-in screen and complete the authentication.
The first Google Sheets connection is now complete.

(3) Next, integrate the GitLab app.
Select GitLab in the same way as registering Google Sheets with My Apps.

(4) Enter the "Username or Main Email Address" and "Password" for the GitLab you want to integrate.
After entering the information, click [Sign In].

(5) Authenticate on the screen after transition.
If the settings are done correctly, you will be taken 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 the Yoom account is complete, click the icon for "Try this template" below.

The template will be copied, so click the "OK" button.

Move to the "My Projects" screen of your Yoom account and check the template content.

There are three setup flows.

・Google Spreadsheet Trigger Setup

(1) First, set up the Google Spreadsheet app trigger.

From "My Projects" on the left side of your Yoom account screen, click "【Copy】Create a new project in GitLab 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].
On the next screen, enter information such as "Trigger Interval" and "Spreadsheet ID".

Select any of the following for "Trigger Interval": 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
*Note that the trigger interval varies depending on the plan.

(4) 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 utilize this information.

(5) After entering the information, click [Test] and if there are no issues, click [Save].
At this step, you can obtain information as output as shown below.
As noted, "This value can be used in other operations," this output information can be referenced and utilized in subsequent steps.

・GitLab Setup

(1) Next, click on the second action "Create a new project".

(2) Enter the GitLab account information to be linked and click [Next].

(3) On the screen after migration, click the input bar in the "Project Name" field to reference the information obtained in the previous step as output, as shown in the screen below.



(4) Scroll down and enter information such as "Group ID (can be selected from candidates)" and "Project Repository Path".
Click the input bar to select the output.
The image below shows the "Project Repository Path" and "Project Description" referenced from the output.



(5) For the "Project Visibility" and "Initialize Repository with README" fields, select any option from the dropdown.

(6) After entering the information, click [Test] and if there are no issues, click [Save].

(7) Finally, click on the third action "Update Record".

(8) On the next screen, make sure 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 make use of this as well.

(9) After entering the information, click [Next].

(10) 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 result.
As an example, for "① Condition of the record to be updated", specify 'Unique Key' for the record you want to update, set the condition to 'Equal', and set the information that matches the condition to 'Unique Key' (using output).

(11) Next, set "② Value of the record after update".
The value set in "① Condition of the record to be updated" 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 utilize the output.

(12) After entering the information, click [Test] and if there are no issues, click [Save].
This completes the setup.

・Turn on the Trigger

By clicking the red frame part "Turn on the 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 GitLab

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

Update GitLab Issues When a Row is Updated in Google Sheets

By using this flow, you can automatically reflect updated information from Google Sheets in GitLab, ensuring data consistency.
By quickly reflecting information without waiting for manual work, you can lead to smooth business operations.

Create a GitLab Issue When a Row is Added in Google Sheets

When information is added to Google Sheets, you can automatically create an issue in GitLab by referencing that information, reducing the effort required for data entry.
Automating the registration of information also helps shorten the time spent on manual tasks, allowing you to allocate more time to solving tasks.

Create a Notion Page When a Row is Added in Google Sheets

When information is entered into Google Sheets, a page can be automatically created in Notion, which is expected to reduce working time.
Since the page is created with the quoted content, it also prevents errors from manual input.

Summary

The automation flow between Google Sheets and GitLab greatly contributes to improving project management efficiency by enhancing team collaboration.
Additionally, by reducing manual work time and maintaining data accuracy, team productivity is improved, and smooth business operations can be expected.

Since it can be easily implemented without programming knowledge, 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.
Tags
Google Sheets
GitLab
Automation
Integration
Automatic
What is Yoom hyperautomation?
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.
Don't Just Connect Apps—Automate Everything
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.
Learn more about Yoom
Helpful Materials
I understand Yoom! 3-piece set of materials
Download materials
Understand in 3 minutes! Yoom service introduction materials
Download materials
Find out by Before After! Yoom Case Study Collection
Download materials
See a list of useful materials