Skip to content
Related Articles

Related Articles

Robotic Process Automation(RPA) – Google Form Automation using UIPath

View Discussion
Improve Article
Save Article
  • Last Updated : 14 Oct, 2020

In this article, we are going to learn how we can automate filling the Google Forms using Uipath Studio. This project is a basic application of Robotic Process Automation (RPA). The user just needs to provide the Excel file that holds the data to be entered in the form and that’s it, rest of the work will be done by the bot that we are going to create using the steps mentioned below:

Note: The Excel file should store data as per the requirement of the Google Form.

Step 1: Create a new process in Uipath Studio by clicking on the Process Tab.

Create New Process

Step 2: Set the name of the process, give a brief description and click on Create. The Uipath studio will automatically load and add all the dependencies of the project.

Name the Process

The following screen will be opened.

Add dependencies to the project

Step 3: Now in the activities panel search for Sequence activity. Drag and drop it in the designer window.

Step 4: Now in the activities panel search for Select File activity. Add it to the sequence. This activity will open a select file dialog box for the user to select the file.

Step 5: Now click on the Variables tab to create a variable of string type that will store the path of the Excel file selected by the user. In the properties panel of Select File activity add the variable in the Output area to the Selected File field.

Add variable in the Output Area

Step 6: In the activities panel search for Excel Application Scope activity. Add it to the sequence. This activity helps you access and manipulate Excel files.

Now pass the variable that stores the file path to this activity.

Step 7: Now in the activities panel search for Read Range activity. You will notice that there are two Read Range activities. Select the one under App Integration. Add it to the Do area of Excel application scope. Specify the SheetName and Range for reading the data.

Now in the Properties Panel of the Read Range activity, in the Output area, select the DataTable tab and press Ctrl+K. This will create a variable of the required type, in this case, DataTable type. Specify the name and press Enter.  

Select DataTable

Step 8: Now in the activities panel search for Open Browser activity and drag and drop it below Excel Application Scope. Now in the URL field pass the URL of the Google Form that you want to automate.

Enter URL of Google Form

Step 9: Now search for For Each Row activity in the activities panel and add it to the Do of Open Browser activity. 

Now in the Properties Panel of the For Each Row activity specify the DataTable variable created earlier in Read Range activity.

Specify the DataTable

Step 10: Open the Google form in the Internet Explorer in the background. Now search for Type Into activity in the activity panel and add it to the Body of For Each Row activity. Now click on Indicate Screen and select the text field of the form where you want to enter the text. Provide the text in the given format. 


Replace the column name with the column name in your Excel sheet.

Click on Indicate Screen

Step 11: Repeat Step-10 for all the column headers in your Excel sheet.

Step 12: Now in the activities panel search Click activity and drop it below the last Type Into activity. Click on Indicate Screen and indicate the Submit button of the form. 

Type Into Activity

Step 13: Fill the Google Form with random values once so that you are redirected to submit another response page. Now add another Click activity and indicate the submit another response button.  

Fill The Google Form

 Step 14: Save the process using the Save button in the design panel and then click on Run. Your bot is ready for automating the Google Forms. The below video displays the working of Bot.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!