Google form doubt

Help Activities
, ,
1

I am having one standard Google form when ever I type the input to the Google form and submit means - take the input values (name, address details) from the submitted form. and do the operations in UiPath bot anyone help please how to do that

2

@BHUVAN

  1. Read CSV file from Google Form:
  • Use the “Read CSV File” activity from the “Files” category.
  • Pass the CSV file path as an input.
  • Store the output as a DataTable variable.
  1. Process the rows in DataTable:
  • Add a “For Each Row” activity to iterate over each row in the DataTable.
  • Use the “Row” property to extract cell values as required.
  1. Open the Google Form URL:
  • Use the “Open Browser” activity to open the Google Form URL.
  • Pass the form URL to the activity.
  1. Type input values in the Google Form:
  • Add the “Type Into” activity from the “UI Automation” category.
  • Use the “Selector” property to select the input fields based on their attributes (e.g., “name”, “id”, “class”).
  • Use the “Row” property to extract cell values as input for the “Type Into” activity.
  1. Submit the Google Form:
  • Use the “Click” activity to click the “Submit” or “Next” button on the form.
  • Use the “Selector” property to select the button based on its attributes (e.g., “name”, “id”, “class”).
3

the thing is like first step I have to take input values from Google form. Once form input values are submitted take the input from Google form And do my operations of the Bot could you help this logic thanks

4

@BHUVAN
input values are stored in spread sheet only you can intergrate with that sheet on studio and do the process

5

Any way to connect with Google forms like API - once form filledup with values take input from the Google form inputs. and bot do the operations like in our normal UiPath form doing

6

@BHUVAN,

Use Google Workspace activities

Inside GSuite Scope use activity Activities - Read Range (uipath.com)

This will give you DataTable and you can use that DataTable further as you need.

Thanks,
Ashok :slight_smile: