How to integrate Google Forms with GitHub to register information submitted through Google Forms into GitHub

How to Create a Google Forms and GitHub Integration Flow

The flow to integrate Google Forms and GitHub using Yoom progresses through the following four processes.

Step 1: Connect Google Forms and GitHub to My Apps
Step 2: Copy the Template
Step 3: Set Up Google Forms for 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 "+ New Connection".

2. Enter Google Forms in the search box and click on the Google Forms that appears 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 "+ New Connection" from "My Apps".

Step 2: Copy the Template

Next, copy the template to integrate Google Forms and GitHub with Yoom.

1. Open the template below and click "Try this template".

‍

2. Click "My Projects" in the Yoom management screen, and then click the copied "【Copy】Register information submitted via 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 form response is submitted".
※ The title can be changed to any content.

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

3. After setting the trigger interval, enter the Google Form ID in the Form ID field and click "Test".
※ The trigger 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 "Value to add", allowing you to change it to any title by hovering over it.
Once you have finished selecting the items, click "Add".
※ When displayed in "Value to add", it initially appears as "value".

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

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 the 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 form response is displayed" appears, 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. Similarly, for the "Comment field" and "Assignee", click the content you want to register and set it, then format the text and test it.
Once the test is successful, click "Save".

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

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

Other Automation Examples Using Google Forms

Yoom has a wealth of automation examples using Google Forms.
Here are a few of them.

1. A flow that automatically adds events to Google Calendar based on Google Form responses.

When setting deadlines for tasks submitted via Google Forms, they can be automatically registered in Google Calendar.
This can save time spent on manual entry, leading to improved work efficiency.

2. This is the flow for notifying Slack of responses from Google Forms.

You can automatically notify Slack of the content submitted to Google Forms.
This will facilitate smooth information sharing.

3. This is the flow to create a Zoom meeting based on responses to a Google Form.

If you want to open a meeting in Zoom every time a Google Form is submitted, you can automatically set up the meeting through integration.
This will help prevent forgetting to set up meetings.

Summary

By integrating Google Forms with GitHub, you can streamline the process from data collection of bugs to task management. Specifically, it reduces the time spent manually creating issues and standardizes the content to make it more readable, which can enhance the overall productivity of the team. By smoothly handling bug checks and development requests, you can quickly advance initiatives that lead to product improvements and enhanced customer experiences. Use this article as a reference to integrate Google Forms with GitHub and improve your workflow efficiency.