How to Register Google Form Responses in Microsoft Excel

(2) Select a project from the workspace list
※ The copied template will be stored in "My Projects" within the project selected in (2).
(3) Click "Edit" at the top right of the flow list screen

Step 2: Set the Trigger

(1) Click "App Trigger" from the flow list screen
(2) Set the title of the app trigger
※ You can use the originally set title as is!
(3) Check if the account information linked with Google Forms is correct
※ If the account information is not displayed, click +Add Linked Account to register.
(4) Select "When a response is submitted to the form" as the trigger action
(5) Click Next

■ API Connection Settings for App Trigger
(6) Set the trigger activation interval to 5 minutes
※ The activation interval that can be set varies depending on the plan.
(7) Enter the Form ID from the "●●●●●●" part of "https://docs.google.com/forms/d/●●●●●●/edit"
(8) If there are no errors in the test, click Save
※ For how to obtain the response content when using Google Forms as a trigger, please refer to here.

Step 3: Operate the Database

(1) Click "Operate the Database"
(2) Set the title
※ You can use the originally set title as is!
(3) Check if the account information linked with Microsoft Excel is correct
※ If the account information is not displayed, click +Add Linked Account to register.
(4) Select "Add Record" as the execution action
(5) Set each item of the database linkage

• File Save Location: Select from the dropdown menu
• Drive ID: Select from the options
• Item ID: Select from the options
• Sheet Name: Select from the options
• Table Range: Specify in text

(6) Click Next
※ For details on setting up the database operation, please check here.

■ Detailed Settings for Database Operation
(7) Set each item of the values for the record to be added
※ The item names will change depending on the information of the sheet specified in the database linkage.
Set it to link the information of "When a response is submitted to the form" to the items in Microsoft Excel.

(8) Click Test and check Microsoft Excel!

(9) If there are no errors, click Save
(10) Return to the flow list screen and change the app trigger to ON to complete the flow setup!

Other Automation Examples Using Google Forms and Microsoft Excel

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

If you find something interesting, please give it a try!

Automation Examples Integrating Google Forms and Microsoft Excel

It is possible to integrate by adding information from Google Forms to Microsoft Excel and then automatically notifying Microsoft Teams, or by creating documents in Microsoft Excel based on responses submitted to Google Forms.
Additionally, you can automatically add data to Microsoft Excel by using OCR to read business card images submitted through Google Forms.

Example of Automation Using Google Forms

Notify Chat Tools When a Response is Submitted in Google Forms

Automatically notify Slack, Discord, etc., when a response is submitted in Google Forms.

Generate documents from Google Form responses and save them to cloud storage

Automatically generate documents in Google Docs or Google Sheets from Google Form responses and save them to OneDrive or other cloud storage services.

Register the content submitted via Google Forms to a task tool

Automatically register the content submitted via Google Forms as a task in tools like Trello or Asana.

Automation Example Using Microsoft Excel

Extract text with AI from content sent via chat tools and add it to Microsoft Excel

Automatically extract specific content from messages posted on Google Chat or Microsoft Teams and add it to Microsoft Excel.

Add Information Registered in Customer Management Tool to Microsoft Excel

Automatically add customer information registered in tools like Salesforce or HubSpot to Microsoft Excel.

Add information to Microsoft Excel when an order is placed on the e-commerce site

When an order is placed on platforms like Shopify or BASE, the information is automatically added to Microsoft Excel.

Benefits of Integrating Microsoft Excel with Google Forms

Typically, Google Forms can directly integrate with Google Sheets, but it cannot integrate with Microsoft Excel using standard features.
However, as introduced here, by utilizing Yoom, you can automatically transfer Google Forms responses to Excel. This can be very convenient when Google Sheets is not an option.

Additionally, Excel allows for advanced analysis using pivot tables and functions, enabling more effective use of accumulated data.
By combining Google Forms and Excel, you can streamline everything from data collection to management and analysis.

Conclusion

We have seen that integrating Microsoft Excel with Google Forms can enhance work efficiency.
With Google Forms data automatically recorded in Excel, the effort of data entry is reduced, allowing for smooth information updates and analysis.

Please take this opportunity to try integrating Microsoft Excel with Google Forms.