Integrating Google Forms with browser RPA to automatically register information submitted through Google Forms into the browser

Step 1: Integrate My App

First, integrate Google Forms with My App.
After logging into Yoom, click on "My App" on the left side of the screen and proceed with the settings from "+ New Connection".

Next, in the "New Connection for My App" that appears, search for Google Forms and click on it.

Click "Sign in with Google" on the next screen to display the Google login page. Log in with the Google account you want to use here.
Finally, when "Yoom is requesting access to your Google Account" is displayed, press "Continue" to complete the integration with My App.

Next, copy the Flowbot template.
Click "Try it out" on the banner below to copy it.

‍

Once the copy is made, click "OK" to proceed with the Flowbot setup.

Step 2: Set the Trigger

Next, set the trigger for Google Forms.
For information on how to retrieve responses when using Google Forms as a trigger, please refer to here.

Then click "When a response is submitted to the form" to proceed with the setup.

On the next screen, check and modify the title and account information.
Ensure that the correct account is selected under "Account information linked with Google Forms".
If you own multiple accounts, there is a possibility that a different account is selected unintentionally.
The title can be edited as desired, but please click "Next" without changing the "Trigger Action".

On the next screen, set the "Trigger Interval" and the "Form ID" for Google Forms.
You can choose to trigger at intervals of 5, 10, 15, 30, or 60 minutes. Note that the shortest trigger interval varies depending on the plan.
For "Form ID", quote the form ID from the URL of the Google Form from which you want to collect response information.
Once each item is set, respond to the relevant Google Form for testing and click "Test".

If the test is successful, check if the information is obtained in "Output".
Next, click "Add value to retrieve".

On the next screen, click "+" to select the item you want to add.

The selected item will be displayed in "Values to Add" on the right side of the screen.
Click on the item to make detailed settings, make necessary corrections, and click "Save".

This time, we renamed it to "Response" and "Email Address". Once the correction is complete, click "Add".
For more information on how to use Google Forms as a trigger and retrieve response content, please refer to here.
Finally, click "Save" to complete the Google Forms trigger setup.

Step 3: Set the Action

Next, set the action in the specified browser.

・The operation to manipulate the browser is a feature available only in the Success Plan. If you are on the Free Plan, Mini Plan, or Team Plan, the operation set in the Flowbot will result in an error, so please be careful.
・Paid plans such as the Success Plan offer a 2-week free trial. During the free trial, you can use operations that manipulate restricted apps or browsers.

For pre-preparation and detailed settings on "Manipulating the Browser", please refer to here.
Then click "Register in the company's system" to proceed with the setup.

On the next screen, you can specify what operations to automate in the browser.
Click "+" at the position where you want to add an action and press "Specify browser operation" to enter the URL to access.
This time, we entered Yoom's URL as a test. Then click "Start operation".

‍

Then the specified URL will open in a private window.
Here, you can select the "Action to Apply" within the browser.
* Once all action settings are complete, click the operation to access the 〇〇 at the beginning of the flow and change the URL to access to your company's site URL.

Once the action is set, click "Test" to check if it behaves as specified.
Once the test is confirmed successful, don't forget to click "Save" to complete the setup.

Finally, click "Turn on Trigger" to complete the preparation for flow activation.
Now, the information submitted via Google Forms will be registered in the core system.

Other Automation Examples Using Google Forms

1. Create a Contract with GMO Sign from Google Form Information and Send a Signature Request

This is a flow that automates everything from contract creation to sending a signature request using GMO Sign, triggered by a response submission in Google Forms.
Since manual operation is not required, it can help prevent mistakes in contract details and forgotten dispatches.

2. When there is a response to the Google Form, add an event to Google Calendar

This is a flow that links Google Form responses with adding events to Google Calendar.
It can streamline the process of adding and checking schedules, making it easier to plan work activities.

3. Register Information Submitted to Google Forms in Airtable

This is a flow that automatically registers response information from Google Forms into Airtable.
It is especially recommended for those who frequently use Google Forms and Airtable.
By automating the registration of information, not only is the effort of registration reduced, but the team can quickly access the same information, which can also enhance team collaboration.

Summary

The automation through the integration of Google Forms and core systems holds the potential to improve business efficiency.
Specifically, it reduces manual tasks and allows for easy management of large volumes of data.
Additionally, it can be expected to facilitate speedy information sharing, strengthening team collaboration. This, in turn, creates an environment where you can focus on important tasks.
The introduction of RPA using Yoom requires no programming knowledge, making it easy for anyone to implement.

Please experience the efficiency improvement through automation by using Yoom.