Take your data collection and analysis a notch higher by using Google Forms, a comprehensive suite of integrations. From structured management on Google Sheets to the safety and storage offered on Google Drive, you do all this on a seamless ecosystem. Go deeper into the performance of the form with Google Analytics and even send automatic notifications using emailing services. Unleash the real power of Google Forms to automate your processes at work and enjoy insightful analytics, or even build up complex systems for the collection of needed data.

Maximize Google Forms with integrations for data analysis, automation, and event registration, connecting with Sheets, Drive, and more.

Google Forms integrations

Product Manager

### Ingredients:

*   **Google Forms**: data input from as many users as necessary, with flexible control on access permission and enterprise grade security
*   **Google Cloud Functions**: to act as a serverless bridge between Google Forms and UiPath Cloud Orchestrator (GCP account with billing enabled required)
*   **UiPath Cloud Platform**: we will leverage the community offering of Orchestrator as a Service for the sake of this demo
*   **UiPath Studio and Robot**: because you probably want to do stuff with your data

### Data flow:

Users logged in with their Google account will access a form via a shared URL.  
In this form, they will enter some information.  
The Forms will be configured with a script in order to forward the data to the Cloud Functions instance (you may think of this setup as a form of webhook.)

The Cloud Functions instance will optionally transform the data, before forwarding it to the Cloud Orchestrator as a QueueItem.

Once the data reaches Orchestrator, we have several options to handle it from there, but we will assume that we want to process the data right away, so the incoming QueueItem will trigger an unattended process.

### Concrete example:

This is a fairly generic use case, that may be leveraged in a variety of scenarios, but in order to better illustrate the topic, we will implement a simple and specific application of a hypothetical user:

You are an internet service provider, and with so many people relying on their mobile phone for online access, things have been a bit slow during the recent years.  
But all of a sudden, everyone is now working from home, and the sales staff that you have posted in electronics stores are submitting thousands of applications in just a few days.  
This is a lot to process; much more than your current setup can handle, especially because the information is filled in paper forms and reaching you in the form of image data that needs to be input by hand.

From now, your customer facing staff will use tablets to input customer information directly into a Google Form, and a Robot will process it by sending a Confirmation email to the customer, and recording the data into your company's ERP system.

  

This _solutio_n uses the following Google services, subject to their specific license terms:

*   Google Forms: 
*   Google Apps Script:  plus 
*   Google App Engine: 

Sample solution based on Google Forms, Google Cloud Platform Functions, and UiPath Automation Cloud to create an unattended automation scenario starting with a form accessible from anywhere.

詳細についてプロジェクトの[githubレポジトリ](https://github.com/qbrandon/FormToQueueItem)をご覧ください。

グーグルフォームズ、グーグルクラウドファンクションズ、UiPathオートメーションクラウドを利用するコネクターのサンプルとなります。どこでもアクセス可能なフォームをトリガーとしたアンアテンデッドオートメーション。

Maximize Efficiency and Insights with Google Forms Integrations

Explore Studio Desktop listings

Similar apps

Sales

Sales