How to Add an Issue to GitHub After Adding a Row in Google Sheets

‍

‍

The template will be copied, so click the "OK" button.
You will be taken to the "My Projects" screen of your Yoom account, so please check the template content.

‍

There are three setup flows.

・Google Spreadsheet Trigger Setup

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

‍

From the "My Projects" on the left side of the Yoom account screen, click "【Copy】Add an Issue to GitHub 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 record is registered".

‍

(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 make use of this information.

‍

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

・GitHub Setup

(1) Next, click on the second action "Create Issue".

‍

(2) Enter or add the GitHub account information you want to link and click [Next].
Keep the trigger action as "Create Issue".

‍

(3) On the next screen, obtain and enter the "Owner Name" and "Repository Name" from the GitHub URL. Enter any information in the "Title".

(4) Scroll down the screen and enter information in other fields as needed.
You can reference the information obtained from the previous step as output, as shown in the screen below.

‍

Once the input is complete, click [Test] and [Save].

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

‍

(6) Make sure 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 previous step as "candidates", so let's make use of this as well.

‍

(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 'Issue' for the record to be updated, set the condition to 'Equal', and set the information that matches the condition to 'Issue'.

‍

You can also reference the information obtained from the previous step as output.

(9) 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.
(The image below is an example. The display will vary depending on the content of the spreadsheet.)

‍

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

・Turn ON the Trigger

A message indicating that all settings have been completed will appear, so click "Turn ON the Trigger".

‍

This completes the setup of the flow bot.

Here is the template used this time

Other Automation Examples Using Google Sheets and GitHub

In addition to the integrations introduced today, it is possible to achieve various automations by utilizing the APIs of Google Sheets and GitHub.

If there is something that interests you, please give it a try!

Automation Examples Integrating Google Sheets and GitHub

You can update a GitHub Issue when a row is updated in Google Sheets, or add new or updated Issues from GitHub to Google Sheets.
Additionally, it is possible to set up an integration that retrieves Issues from GitHub and adds them to Google Sheets on a specified schedule.

Automation Example Using Google Sheets

Retrieve tasks with today's deadline from Google Sheets and notify chat tools in bulk daily

Automatically retrieve tasks with today's deadline from Google Sheets and notify tools like Slack or Discord in bulk daily.

Create a folder in cloud storage when a row is added in Google Sheets

Automatically create a folder in Google Drive, OneDrive, etc., when a row is added in Google Sheets.

Register Survey Results Received by Email into Google Sheets

Automatically register survey results received via Gmail or Outlook into Google Sheets.

Example of Automation Using GitHub

Notify Chat Tools When an Issue is Created on GitHub

Automatically notify Slack, Discord, etc., when an issue is created on GitHub.

Add a task to the task management app when an issue is created on GitHub

Automatically add a task to apps like Asana or Trello when an issue is created on GitHub.

Register responses submitted through the form as GitHub Issues

Automatically register responses submitted through Google Forms, etc., as GitHub Issues.

Benefits and Examples of Integrating Google Sheets with GitHub

Benefit 1: Time Savings by Reducing Workload

By integrating Google Sheets with GitHub, you can reduce the effort of manually transferring data.
For example, if a system is set up where adding a new task to a spreadsheet automatically registers it as a GitHub Issue, routine tasks can be streamlined.
This allows staff to focus on more important tasks, which should lead to improved overall team performance.

Benefit 2: Prevention of Human Error

When entering or transferring data manually, human errors such as typos or omissions can occur.
By implementing this automation, such mistakes can be minimized.
For instance, if the content entered in Google Sheets is automatically added to GitHub Issues, accurate information will be recorded.
This smooths the progress of tasks, allowing multiple stakeholders to verify accurate data and proceed with work smoothly.

Benefit 3: Smooth Collaboration Between Teams

Organizing information using Google Sheets and automatically creating Issues in GitHub facilitates smooth collaboration between various teams.
For example, if the sales team records client requirements in Google Sheets and they are automatically reflected in GitHub, the development team can quickly respond.
Seamless collaboration between the sales and development teams can lead to faster product development and modifications.

Conclusion

Those using different apps may find themselves wasting time with unnecessary actions due to cross-app operations.
Integrating Google Sheets with GitHub using Yoom should help reduce previous work time and contribute to operational efficiency.
Additionally, by preventing human errors and facilitating smooth team collaboration, the success rate of projects can be expected to improve.

Even without programming knowledge, you can easily get started, so try using the introduced automation flow to help improve your daily operations!