When using automation to fill Google Form with data from Excel file, inputs in form are blank

Hey guys so I am trying to fill a google form from the data stored in a .csv file automatically. I have followed the steps for Excel automation in this link: https://www.edureka.co/blog/uipath-automation-examples but during the automation all the inputs are blank. I have also seen this video: https://www.youtube.com/watch?v=tjg4rFQejf8&t=59s but I still could not figure out the issue. Also I cannot attach anything as I am a new user.

Hi, are you getting any error ?
If no error , still the values are blank
Use read csv file activity
And the output will be datatable variable
Now use for each row activity for that DT
And perform your steps

Welcome to uipath community
I would like to suggest you with Level -1 course from our uipath academy https://academy.uipath.com

Here we will be Having all the courses for beginners

And for your scenario these sequence of activities would help you
—use READ CSV FILE activity and pass the file path csv file as input and get the output with a variable of type datatable named dt
—now use a FOR EACH ROW activity and pass the above variable dt as input
—inside the loop we can use OPEN BROWSER ACTIVITY and mention the url of the page we want to go
—now use a TYPE INTO activity and mention the input as row(“yourcolumnname”).ToString and enable simulate type property in the property panel of type into activity

Cheers @Aisha_Ali

1 Like

This is the error I am getting. Go Back: Error HRESULT E_FAIL has been returned from a call to a COM component.

That means the error is while reading the CSV file itself
Pls make sure you close the CSV file before you runs the process

This is the error I am getting. Go Back: Error HRESULT E_FAIL has been returned from a call to a COM component. I have attached the flowchart also. Flowchart.xaml (16.7 KB)

I do close the csv file before running flowchart. Also I have attached my flowchart

May I at which activity this error comes in exact
Cheers @Aisha_Ali

Go Back Activity. I did run it without Go Back no error is being shown but still inputs are not being filled. The file which I have made is a CSV file with column headers and 2 rows do not know why it is not working

suppose error in type into ‘input’ check this video https://www.youtube.com/watch?v=QrL-RZAnE8M

Welcome to uipath community
If possible can I have the screenshot of the error that comes along type into activity
Sorry buddy I couldn’t play the video

Cheers @Kurinji_Malar_K

sorry, i didn’t workout this activity that only i send this video clip

Kindly try once and let know pls

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.