How to Register Information Submitted via Google Forms to GitHub

[What is Yoom]

How to Create a Workflow for Integrating Google Forms and GitHub

The workflow for integrating Google Forms and GitHub using Yoom consists of the following four processes.

Step 1: Connect Google Forms and GitHub to My Apps
Step 2: Copy the Template
Step 3: Set Up the Google Forms App Trigger
Step 4: Configure GitHub

Step 1: Connect Google Forms and GitHub to My Apps

First, to connect Google Forms and GitHub to Yoom, you need to register them as My Apps.

1. Select "My Apps" on the left side of the Yoom management screen and click "+ Add".

2. Enter "Google Forms" in the search box and click on the Google Forms that appear in the search results.

3. Click "Sign in with Google" to proceed with the login, and the My Apps connection with Yoom will be completed.

4. Connect GitHub in the same way as Google Forms by clicking "+ Add" from "My Apps".

Step 2: Copy the Template

Next, copy the template for integrating Google Forms and GitHub with Yoom.

1. Click "Try it" on the template below.

‍

2. Click "My Projects" on the Yoom management screen and click the copied "【Copy】Register information registered in Google Form to GitHub".

Step 3: Setting up Google Form for App Trigger

Next, set up the trigger, which is the first step in the integration flow. The trigger for this flow will be the submission of a response to the Google Form.

1. Click "App Trigger When a response is submitted to the form".
※ The title can be changed to any content.

2. After setting up your Google account, confirm that the trigger action is "When a response is submitted to the form" and click "Next".

3. After setting the trigger activation interval, enter the Google Form ID in the form ID and click "Test".
※ The trigger activation interval can be selected from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes, but the selectable time varies depending on the plan.

4. If there is additional information you want to obtain in the output, click "Add value to obtain".
※ You can register the information obtained in the output to GitHub.

5. Click the plus mark of the value you want to add as shown in the image below, and it will be displayed in "Selected Values to Add", where you can change it to any title by hovering over it.
After selecting the items, click "Add".
※ When displayed in "Selected Values to Add", it is initially labeled as "value".

6. Once you have decided on the values to add to the output, click "Save".

By utilizing the Google Form for app triggers, you can activate the flow bot based on the content of the responses to the Google Form.
For more details, please check the help page and set it up in advance.

‍

If you want to increase the output you want to obtain, it is recommended to obtain it with 'JsonPath'.
For how to obtain output with JsonPath, please check this page.
For how to write JsonPath, let's check here.

Step 4: Setting up GitHub

Finally, set up to register the content obtained from the Google Form as an Issue in GitHub.

1. Click "Create Issue to integrate with app".

2. After setting up your GitHub account, confirm that the action is "Create Issue" and click "Next".

3. Enter the "Owner Name" and "Repository Name" of the GitHub account where you want to create the Issue, referring to the description below the frame.

4. Click the title field, and when "When a response is displayed on the form" is displayed, select it and click "Title" from the list.
※ This setting allows you to dynamically set the Issue name to the title entered in the Google Form.

5. For the "Comment field" and "Assign person in charge", click the content you want to register in the same way as "Comment", arrange the text, and test it.
Once the test is successful, click "Save".

6. Finally, click "Turn on Trigger" to complete the setup.
From now on, an Issue will be automatically created in GitHub every time a response is submitted to the Google Form.

This concludes the flow of integrating Google Form with GitHub using Yoom.

Other Automation Examples Using Google Forms and GitHub

In addition to the flow introduced this time, you can achieve various business automations by using Google Forms and the GitHub API.
All of them can be used with simple settings, so if you find something interesting, please give it a try!

Other Automation Examples with Google Forms and GitHub

You can OCR attachments from Google Forms to create issues on GitHub or add new employee information to a GitHub repository.
By utilizing OCR functionality, you may be able to reduce the workload associated with manual tasks.

Example of Automation Using Google Forms

Uploading Files Submitted via Google Forms

Files are uploaded automatically, reducing the effort required for file management and potentially increasing the time available to focus on other tasks.

Invite users to multiple channels based on information provided in Google Forms

When inviting users to multiple channels due to onboarding or transfers, manual work for each entry is eliminated, reducing work time and easing the burden on the person in charge.

Register Google Form Responses

When a response is submitted through Google Forms, it should be possible to reduce the effort of data entry by automatically registering the response content in a database tool.

Example of Automation Using GitHub

Create an Issue on GitHub When a Message is Posted

Since the issue is created in a timely manner, task sharing within the team should be speedy.

Add content when an issue is created on GitHub

By eliminating the time previously spent on manual work, it leads to quicker task resolution.

Benefits of Integrating Google Forms with GitHub

Benefit 1: Streamlining Work Efficiency by Reducing Manual Issue Entry

By automatically registering information submitted to Google Forms as GitHub Issues, you can potentially eliminate the hassle of data entry and copy & paste. This can help prevent human errors and reduce work time. For example, collecting issues related to GitHub code via Google Forms and directly creating Issues in the repository allows for quick and accurate information registration. This automation enables team members to focus on other important tasks, potentially boosting overall team productivity.

Benefit 2: Smoothing Task Verification by Standardizing Issue Format

Integrating Google Forms with GitHub allows Issues to be automatically created according to the form's response format and question content, creating an environment where tasks can be smoothly verified. For instance, if multiple team members create Issues from Google Form content, the Issue format may vary by person. When the format changes, workers might be confused when verifying tasks. However, with this integration, responses from the form can be automatically created in the same format, allowing workers to efficiently verify tasks.

Benefit 3: Efficiently Managing User Requests in Software Development

By automatically registering user requests and bug reports collected via Google Forms as GitHub Issues, the development team can more easily manage tasks efficiently. For example, if user requests and bugs are automatically generated as GitHub Issues, tasks can be organized, making it easier to determine priorities. Additionally, when users submit new feature requests via the form and they are registered as GitHub Issues, they should be quickly reflected in the project. This not only efficiently connects user requests to the development process but may also lead to improved user satisfaction.

Conclusion

By integrating Google Forms with GitHub, you can streamline the process from data collection of bugs to task management. Specifically, you can reduce the time spent creating Issues manually and unify the content to make it more readable, which can be expected to boost overall team productivity. By smoothly verifying bugs and development requests, you can quickly advance measures that lead to product improvement and enhanced customer experience.

Use this article as a reference to integrate Google Forms with GitHub and streamline your operations.