Resources

Knowledge Base

Trigger User Events.Google Form Scrapping

trigger
  • To be able to run this example you need to install UiPath.Excel.Activities. See more details on how to install packages here.

Task

This sample creates a WorkFlow that collects all the information from the following Google Form  and puts all these information in a Excel sheet.

Steps to automate

  1. Open the form.
  2. Build a data table.
  3. Copy all the information from the form into a Excel when the user click "Submit" button.

Solution

  1. Create a data table using "Build a Data Table" activity that has as columns names all the fields from the form.
  2. Use "Monitor Events" activity that listens to a trigger and executes a handler everytime one of the actions is triggered, in our case "Click" activity.
  3. For a field like "Name" use "Get Value" activity to extract the content, for radio button use "Get Attribute" activity with "Checked" as attribute and for birthday use "Get Attribute" also but now use "SelectedItem" as attribute.
  4. After every submit write a new line in Excel using "Write Cell Range".
  5. Go to "Click Trigger" properties and be sure that EventType is setup as "Event_Synchronous".
dt
dt1