How to create a new project in GitLab after adding a row in Google Sheets by integrating Google Sheets with GitLab
How to Integrate Applications
・
2024/12/01
How to create a new project in GitLab after adding a row in Google Sheets by integrating Google Sheets with GitLab
k.ueno
When a task that needs to be addressed arises, GitLab is suitable for sharing the content with other teams and departments. However, many people manage basic information input separately using Google Sheets. The automation flow introduced this time can reduce manual input time and decrease human errors, making it a powerful means to enhance project management efficiency. By incorporating Yoom's app integration to streamline project progress, you can easily implement task automation without programming knowledge.
Recommended for:
- Those who feel challenged by sharing project information across multiple departments.
- Those who want to reduce the risk of data entry errors and transcription mistakes to proceed with work accurately.
- Those who wish to improve the task management efficiency of the entire team.
- Beginners in programming who are considering business automation.
- Those who want to integrate Google Sheets and GitLab to improve work efficiency.
Benefits and Examples of Integrating Google Sheets and GitLab:
1. Strengthening Interdepartmental Collaboration
Reflecting Google Sheets information in GitLab enables smooth information sharing between different departments. For example, when the marketing team inputs a new campaign plan into Google Sheets, it gets registered as a project in GitLab, allowing the development and design teams to quickly start responding. By enabling each department to swiftly recognize tasks and strengthen collaboration, it can also prevent work delays.
2. Reducing Manual Work
Automating project creation in GitLab can reduce the time spent on information input. In environments with many remote teams, simply entering new project information into Google Sheets can automatically create a project in GitLab, reducing the time staff spend on manual input and allowing them to focus on other important tasks. This may also contribute to improving overall company productivity.
3. Maintaining Data Accuracy
By integrating 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 and transcription errors, which may have required content re-confirmation between teams. With this automation, when a new project is added to Google Sheets, accurate data is directly reflected in GitLab, enabling correct data management and verification, potentially reducing the time staff spend on content verification.
[About Yoom]
Now, let's create a flowbot using the template "Create a new project in GitLab when a row is added in Google Sheets."
How to Create a Workflow for Integrating Google Sheets and GitLab
The process to complete the workflow 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
Let's start by making a new connection for the apps you want to integrate.
・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 next screen. If the settings are correct, you will be moved 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 for the target app is complete in your Yoom account, click the icon "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 the Yoom account screen, click "Create a new project in GitLab when a row is added in Google Spreadsheet [Copy]".
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 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.
(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]. In this step, you can obtain information like the one below as output. The output information can be referenced and utilized in subsequent steps, as noted by "This value can be used in other operations."
・GitLab Setup
(1) Next, click on the second action "Create a new project".
(2) Enter the account information for the GitLab to be linked and click [Next].
(3) On the screen displayed after the transition, 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 menu.
(6) After entering the information, click [Test], and if there are no issues, click [Save].
(7) Finally, click the third action "Update Record".
(8) On the next screen, confirm that the Google Spreadsheet account information is entered. Scroll down to the "Database Integration" section and enter the relevant information. You can expand the information obtained from the linked account as "candidates", so let's also utilize this.
(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 results. As an example, in "① Conditions for the record to be updated", specify 'Unique Key' for the record to be updated, set the condition to 'Equal', and set the information that matches the condition to 'Unique Key' (utilizing output).
(11) Next, set "② Values of the record after update". The value set in "① Conditions for 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 available on Yoom, so here are a few introductions.
Update GitLab Issues When a Row is Updated in Google Sheets
By using this flow, information updated in Google Sheets can be automatically reflected in GitLab, ensuring data consistency. By reflecting information quickly 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 in 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 shortens the time spent on manual tasks, allowing more time to be dedicated 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 significantly 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.
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)
