How to link Google Forms with Excel to automatically register Google Forms responses in Microsoft Excel

I understand many of you utilize Notion for project management and information sharing, and Dropbox for saving files. But are you finding the manual creation of folders and the organization process cumbersome?

That's where the integration of Notion and Dropbox using the no-code tool Yoom comes highly recommended. With Yoom, you can easily set up a flow where, when a new page is created in your Notion database, a corresponding folder is automatically created in Dropbox. This eliminates the effort of manual folder creation and makes it easier to centrally manage related information and files.

In this article, we will explain in detail how to "create a folder in Dropbox when a page is created in a Notion database" using Yoom. Why not take this opportunity to improve your work efficiency?

Recommended for

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".
No complicated settings or operations are required, and even non-engineers can easily achieve this.
You can start right away with the template below, so please give it a try!

How to Automatically Register Google Form Responses in Microsoft Excel

Earlier, I talked about the benefits of integration, and this time I would like to introduce the flow of "registering Google Form responses in Microsoft Excel" while referring to the actual screen.

Even without programming knowledge, you can complete the integration with simple operations and settings. Please try creating it together while operating.

[What is Yoom]

Step 1: Integrate Google Forms and Microsoft Excel with My Apps

First, integrate Google Forms with Yoom.

1. Click "App Integration" at the top left of the screen and select Google Forms.

2. Next, on the screen to integrate Yoom and Google Forms, click "sign in with Google".

3. On the "Account Selection" screen, select the account you want to integrate.

4. On the "Login to Yoom" screen, if there is no mistake in the account you want to integrate, select "Next" → on the next screen, select "Continue".

This completes the integration of Yoom and Google Forms.

Next, integrate Microsoft Excel with Yoom.

1. Click "App Integration" on the left tab and select Microsoft Excel.

2. Select the account you want to connect to, enter the password on the next screen, and the setup is complete!

Step 2: Set a Trigger to Activate When Google Form is Answered

Let's proceed with the actual setup! We'll start with the Google Form settings.

1. Perform Pre-Flow Creation Tasks.

・Select the project where you want to create the flow.

・Next, click "Create" on the screen and start creating the flow with "Create from Scratch".

2. Enter Title and Select Trigger.

・The title is described in the flow for clarity.

・For trigger selection, choose "Trigger from an app event" and click Google Form.

3. Set Up Linked Account and Action Selection.

・Enter the title for the app trigger.

・For account information to link with Google Form, connect with the desired account.

・For trigger action, select "When a response is submitted to the form".

4. Set Up API Connection for App Trigger.

・Select "5 minutes" for the trigger activation interval.

・Enter the form ID you want to link.

・Regarding the form ID, the "●●●●●●" part in the Google Form URL https://docs.google.com/forms/d/●●●●●●/edit is the form ID.

・Once the setup is complete, click "Test".

・If "Test Successful" is displayed, the trigger setup is complete.

・For how to obtain response content other than existing items with Google Form trigger, please check how to obtain response content here.

This completes the integration between Google and Yoom!

Step 3: Set an Action to Append Responses to Microsoft Excel

Next, let's integrate Microsoft Excel with Yoom.

Click the + displayed immediately below after setting up earlier.

1. In Select an action type, Choose "Microsoft Excel".

2. Set Up Database Integration.

・Enter the title for the operation.

・For account information to link with Microsoft Excel, connect with the desired account.

・For execution action, select "Add Record".

Scroll and enter the database integration input.

・Enter each item and click Next.

3. The Set Microsoft Excel Table Information is Retrieved and Displayed.

・Embed the information obtained from Google Form as output in each item.

・Once the input is complete, conduct a test.

・Conduct a test, confirm that the information is added, and save.

This completes the flow to register Google Form responses to Microsoft Excel in integration with Yoom!

Other Examples of Automation Using Google Forms and Microsoft Excel

There are many other examples of automation using Google Forms and Microsoft Excel on Yoom, so here are a few introductions.

Examples of automation using other forms in conjunction with Microsoft Excel

In addition to Google Forms, it is possible to link with various form tools and automatically register data in Microsoft Excel.

An example of automation using Google Forms

When a response is submitted in Google Forms, notify a chat tool

When a response is submitted in Google Forms, automatically notify Slack, Discord, etc.

Notify Microsoft Teams of information submitted through Google Forms

Try it

---

■Overview

This is a flow that notifies Microsoft Teams of information submitted via Google Forms.

‍

■Recommended for

1. Those who use Microsoft Teams as their main communication tool

・Those who want to share submitted content on Microsoft Teams to promote quick responses and information sharing

‍

2. Those who are streamlining their work by integrating Google Forms and Microsoft Teams

・Those who want to improve work efficiency by eliminating the hassle of manual transcription

‍

■Benefits of using this template

Google Forms is a convenient tool for information gathering.
However, having the person in charge check each submission and share the content with team members on Microsoft Teams might feel cumbersome due to potential input errors and time consumption.

By integrating Google Forms with Microsoft Teams, you can reduce manual tasks, thereby preventing human errors such as input mistakes and omissions.

‍

■Notes

・Please integrate both Google Forms and Microsoft Teams with Yoom.

・Refer to the following for how to obtain response content when using Google Forms as a trigger.

https://intercom.help/yoom/ja/articles/6807133

・You can select the trigger activation interval from 5, 10, 15, 30, or 60 minutes.

・Please note that the shortest activation interval varies depending on the plan.

・Microsoft365 (formerly Office365) has both a home plan and a general business plan (Microsoft365 Business), and if you are not subscribed to the general business plan, authentication may fail.

See details Try it

Notify Discord of Google Form responses

Try it

---

■Overview

This is a flow that notifies Discord of responses from Google Forms.

‍

■Recommended for‍

1. Those who use Discord as their main communication tool

・Companies that use it to keep records of interactions within departments

・Team representatives who use it for information sharing

‍

2. Those who use Google Forms for information gathering

・Customer service departments that want to collect surveys from seminar participants in advance

・HR representatives who utilize Google Forms for recruitment activities

‍

■Benefits of using this template

Using Discord for information sharing within teams or departments is very effective for visualizing information and streamlining operations.
However, when responses from Google Forms are received at a specific email address, manually sharing that information on Discord can be a significant hassle.

This flow is effective for those who want to smoothly share responses obtained from Google Forms within their team.
Since it automatically notifies Discord of the content of Google Form responses, quick information sharing becomes possible.
Additionally, as the notification content is quoted from the response content, it prevents input errors in the content.

‍

■Notes

・Please integrate both Discord and Google Forms with Yoom.

・For the method of obtaining response content when using Google Forms as a trigger, please refer to the link below.

‍https://intercom.help/yoom/ja/articles/6807133

See details Try it

When a response is submitted via Google Forms, notify on Slack.

Try it

---

◼️Overview‍

When a response is submitted via Google Forms, a notification will be sent to any designated Slack channel.

The target channel and message content can be customized as desired.‍

‍

◼️Setup Instructions‍

1. Integrate Google Forms and Slack with Yoom. (My App Integration)

2. Set the form ID with the trigger "When a response is submitted to the form" and run a test.

3. Once the test is successful, you can retrieve the response information from the form. Select the information you want to obtain from the response using the [+] button and store it in the output.

4. In the "Notify Slack" operation, set the target channel and message content based on the response details obtained from Google Forms.‍

‍

◼️Notes‍

・Account integration with both Google Forms and Slack is required.

・Please adjust the question settings in Google Forms as needed.

See details Try it

Add an event to your calendar when someone answers your Google Form

When someone answers your Google Form, the event will be automatically added to your Google Calendar or Garoon Calendar.

Register the content submitted via Google Forms in a task tool

Automatically register the content submitted via Google Forms as a task in Trello, Asana, etc.

Example of automation using Microsoft Excel

Add information registered in your customer management tool to Microsoft Excel

Customer information registered in Salesforce, HubSpot, etc. is automatically added to Microsoft Excel.

When you receive an email, register a record in Microsoft Excel

The contents of the received email are automatically added to Microsoft Excel.

Benefits and Use Cases of Integrating Google Forms with Microsoft Excel

1. Reducing Data Entry Effort and Preventing Human Error

By integrating Google Forms with Microsoft Excel, data entered into the form is automatically input into Microsoft Excel.
This automation reduces the risk of errors and omissions that can occur with manual entry, and also cuts down on the time needed for verification tasks.

For example, in scenarios where survey results or customer inquiry information are recorded in Microsoft Excel, there is no need to manually transfer data, enabling accurate information recording.

2. Easily Manage and Analyze the Latest Data

Since data submitted from Google Forms is continuously accumulated in Microsoft Excel, the latest information is always available for aggregation and analysis.

In situations where survey or questionnaire aggregation is needed, analysis in Microsoft Excel can begin as soon as data entry is complete, allowing researchers to quickly access the data.
For instance, when managing customer feedback on products or employee attendance information, the accumulation of data in Microsoft Excel makes it easier for managers to efficiently grasp the situation.

3. Efficiency Through Integration of Different Data Sources

The integration of Google Forms with Microsoft Excel allows for the centralization of data collected from different applications into Microsoft Excel.

This integration facilitates easier management of dispersed data and allows quick access to necessary information through searching and filtering in Microsoft Excel. For example, by conducting customer surveys via Google Forms and integrating the results with other sales data, sales representatives can verify necessary information in a single file and quickly respond, creating an efficient working environment.

Summary

How was it? By using Yoom, you can easily set it up without utilizing GAS.
It's user-friendly, so it will undoubtedly increase the efficiency of administrative tasks and boost productivity!

The flow introduced was about adding information, but you can also arrange it to "notify Slack of the added information."
Additionally, as an advanced application, you can create a flow to "add information received in Google Forms to Microsoft Excel and Google Sheets."
With simple operations, you can integrate with various apps and create flow bots tailored to your situation with just a bit of customization.

Take this opportunity to try using Yoom to create flow bots!