・
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.
(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 GitLab issue 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 "When a row is added", which is the trigger.
(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].
In this step, you can obtain the following information as output.
The output information can be quoted and utilized in subsequent steps, as noted in "This value can be used in other operations."
(1) Next, click the second action "Create Issue".
(2) Enter the GitLab account information to be linked and click [Next].
(3) On the screen displayed after migration, click the input bar in the "Project ID" field to expand the information obtained from the account as "candidates" as shown in the screen below.
Select the relevant information.
(4) Scroll down and enter information such as "Issue Title" and "Issue Description".
Click the input bar to select the output.
As an example, the following is a quote of the output [Title] information obtained from the previous step.
After entering the information, click [Test] and if there are no issues, click [Save].
(5) Finally, click the third action "Update Record".
(6) On the next screen, make sure the Google Spreadsheet account information is entered.
Scroll down to the "Database Integration" section and enter the relevant information.
The information obtained from the linked account will be expanded as "candidates", so let's also utilize this.
(7) After entering the information, click [Next].
(8) 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, in "① Condition of the record to be updated", specify the '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).
(9) 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 enter the information.
As shown in the screen below, you can also utilize the output.
(10) After entering the information, click [Test] and if there are no issues, click [Save].
This completes the setup.
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
There are other examples of automation using Google Sheets available on Yoom, so here are a few introductions.
You can automatically quote information added to Google Sheets in GitLab to create a new project, eliminating the need for manual input.
Using the quoted information for registration also leads to highly accurate information sharing.
By using this flow, you can automatically reflect updated information from Google Sheets in GitLab, ensuring data consistency.
By quickly reflecting updates without waiting for manual work, you can avoid information updates becoming an obstacle to business operations.
This flow is recommended for companies that use HRMOS for human resource management.
It streamlines the process by completing the registration in HRMOS based on employee information entered in Google Sheets, reducing manual work time.
Additionally, using referenced content helps prevent human errors.
By integrating Google Sheets and GitLab as introduced in this article, task creation can be automated.
This prevents manual input errors and improves work speed, thereby reducing the burden on the person in charge and further enhancing overall operational efficiency.
Please take advantage of Yoom to experience automation through app integration.
.avif)
