Hi there,
I am totally new to UiPath, this is my first automation here, I got stuck and would appreciate any kind of help. My sequence is suite simple, here it is:
- Read data from Goggle Sheet.
- Iterate through a list of URL-s (Youtubetranscript.com), open them in browser, and grab the text.
- Insert the text in another column in the same Sheet.
This is the first part of my workflow:
(I will upload the second one in a comment, because UiPath does not let new users to upload more images)
I am sure I use the for each loop and the data transfer wrong but I don’t know how to fix it. I don’t know when it is required to use the Current.Item string or when to set up a database. When I try to map my variable “CustomTranscript” at the end of the workflow (“Data row to write”), I get this error message: “argument: datarow’: BC30311: value of type ‘String’ cannot be converted to ‘DataRow’” Does that mean that I can’t use strings simply put into Google Sheet cells? Do I have to first somehow manipulate them?
Is it possible to do this automation without complicated data management and coding?
Thank you for your help in advance,
Janos
