Awesome! What if we have like 20 different fields and like 5000 rows? The running time would be crazy. Is there anyhow a more efficient way of dealing this? Additionally, is it charging a lot for the pro edition?
Yes, It would take more time. There are some things that we can try to increase the automation speed, on thia video we have two tips to try ruclips.net/video/vOABUc844lE/видео.html! Could you explain more in detail you're last question? I'm not sure if I understood well😃
@@marcelocruzrpa I mean the automation can be done i community edition for free, right? Alternatively, do we have to pay for the service in pro edition? I mean, what is the difference between pro and community edition?
I don't know if I understood well, but I believe that you want to say 'Enterprise' instead of Pro. Yes you can do automations without cost on community edition. But If you want to scale, and run automations on many machines, you will need to have Enterprise edition, has it allows to add unlimited robots, has the Community has limit. Also you have access to UiPath Official support With Enterprise while Community Edition no, etc.
You can handle most of the times dropdowns in UiPath with the Select Item activity. If it doesn't work, you can always use one click activity to open the dropdown and another to choose the value from it.
Hello You method is just great. I have a question. Can you show how I can save web page as pdf on a specific folder with a sequencial name like 1, 2, 3 or a, b, c or A1, A2, A3 etc. Thank you
Hi, great video. I am pretty new to UIPath. I want to extract data from the fields of one web form (user input), submit the form and load that data in another form in another application. The url for the web forms are dynamic, so I cannot use one specific url. Is it possible and if yes, can you please share any resource or video to follow? Thanks!
how to input datetime from excel to from web divided into 3 input fields, for example from excel with format (DD-M-YYYY) to web format into DD, M, YY (into each field)
First, you need to to parse the date and get it on DateTime variable. From that, you can easily get individually the year, month and day by just calling the variable + add dot and then choose what you want to get only (Month, Day or Year).
Halo, i already try u'r tutorial. After click submit button, my data input not record on google form.even though my data in Excel already appears in the Google form. How fix this case?
Hey Srikanth, what's the name of the tow instance on the For Each Row In Data Table activity? You should mention by the name defined, currently the default one it's CurrentRow
@@marcelocruzrpa 1. **SCRAPE KEYWORDS FROM GOOGLE SHEET** 2. **ENTER THESE KEYWORDS INTO AN ANALYTICS SOFTWARE** 3. **RETRIEVE DATA FROM THE ANALYTICS SOFTWARE AND STORE IT IN GOOGLE SHEET** Hi, I have an idea for an app, specifically an automation: To automatically enter many keywords into a software, I understand I can use a no-code platform like UiPath. Could I also do that with n8n? And what's the difference compared to using a script? Is a script better, and if so, would Python, Apps Script, or something else be the best option? There’s an application called Zik Analytics that lets me get a bunch of data about eBay, to make a better decision of products I could buy and resell. However, it does not provide as many things I wish. My idea is to automatically pull Zik's data into Google Sheet. When I use Zik, I have to type my keywords (that I’ve previously scraped) to get the data associated with that keyword. So to avoid typing them one-by-one, I know I could use UiPath but maybe n8n can do this too, or other no-code software? Since I've been watching videos trying to learn development basics and since I now understand I can use LLMs (large language models) to create extensions or applications, I'm wondering if using an LLM wouldn't be better than using a no-code platform? I've tried n8n a few times, and it feels slow to configure. I haven't tried UiPath, but after finding a few tutorials, I see it is also complex to setup, compared to an LLM which feels like code you copy-paste, and it works instantly. Am I wrong? And if this advantage is valid what other advantages do LLMs provide? Finally, those advantages potentially allow me to create an app or a Chrome extension. Is there any benefit to using an extension over an app, for what I am trying to build (mainly, using Google Sheet; and perhaps other apps). What is the best thing to build considering the requirements for the goal I am chasing?"
Despite that UiPath has been updating their versions, your method continues to work! Your video has excellent examples and explanations.
Thank you so much for the feedback! :)
Easy to follow Tutorial. Thank you Marc
You're welcome Nikitta!
You're a pro thank you!
You're welcome Adrian! 😀
Very helpful and easy to follow. Thank you; this was just what I needed!
You're welcome Janus!
Thanks a lot for such detailed video. Easy to understand and easy to follow. Kindly keep posting such videos.
Thank you so much for the feedback :D
Hello from India... Thank u very much for this extremely simple and helpful video.
Do we use the same process for CSV too. i.e get data from CSV and use it on application
Yes it's almost the same, you would just need to replace the Read Range by the Read CSV activity.
Parabéns pela aula e conteúdo, você é fera !
Muito obrigado pelo feedback Andreew!
Thank you.
You're welcome!
Awesome! What if we have like 20 different fields and like 5000 rows? The running time would be crazy. Is there anyhow a more efficient way of dealing this? Additionally, is it charging a lot for the pro edition?
Yes, It would take more time. There are some things that we can try to increase the automation speed, on thia video we have two tips to try ruclips.net/video/vOABUc844lE/видео.html!
Could you explain more in detail you're last question? I'm not sure if I understood well😃
@@marcelocruzrpa I mean the automation can be done i community edition for free, right? Alternatively, do we have to pay for the service in pro edition? I mean, what is the difference between pro and community edition?
I don't know if I understood well, but I believe that you want to say 'Enterprise' instead of Pro. Yes you can do automations without cost on community edition. But If you want to scale, and run automations on many machines, you will need to have Enterprise edition, has it allows to add unlimited robots, has the Community has limit. Also you have access to UiPath Official support With Enterprise while Community Edition no, etc.
Very hepful Thank you
How to fill data form excel to dropdown or multiple choice.
You can handle most of the times dropdowns in UiPath with the Select Item activity. If it doesn't work, you can always use one click activity to open the dropdown and another to choose the value from it.
Hello
You method is just great.
I have a question. Can you show how I can save web page as pdf on a specific folder with a sequencial name like 1, 2, 3 or a, b, c or A1, A2, A3 etc. Thank you
what if the rows are generated by clicking "Add row" as in a list of products on a receipt?
Hi, great video. I am pretty new to UIPath. I want to extract data from the fields of one web form (user input), submit the form and load that data in another form in another application. The url for the web forms are dynamic, so I cannot use one specific url. Is it possible and if yes, can you please share any resource or video to follow? Thanks!
Great explanation ..... is there any way to match excel sheet columns with the form fields to avoid repetition of the "Type Into" activity
Thank you, if you really want avoid the repetition of Type Into activity, you can invoke JS script to fill all the form fields at once.
it did not work@@marcelocruzrpa
how to input datetime from excel to from web divided into 3 input fields, for example
from excel with format (DD-M-YYYY) to web format into DD, M, YY (into each field)
First, you need to to parse the date and get it on DateTime variable. From that, you can easily get individually the year, month and day by just calling the variable + add dot and then choose what you want to get only (Month, Day or Year).
thank you so much :D
You're welcome! :)
Halo, i already try u'r tutorial. After click submit button, my data input not record on google form.even though my data in Excel already appears in the Google form. How fix this case?
This is not working for me in June 2024. I get the error "Non-invocable member 'CurrentRow' cannot be used like a method".
Thanks a lot
You're welcome!
For me it is showing error ( currentrow cannot be used like a method )
Hey Srikanth, what's the name of the tow instance on the For Each Row In Data Table activity? You should mention by the name defined, currently the default one it's CurrentRow
how to enter the date in google form
Using this method of inputting data into the web form it should input the data stated in the excel sheet.
kindly provide source code
hello
hi!
@@marcelocruzrpa
1. **SCRAPE KEYWORDS FROM GOOGLE SHEET**
2. **ENTER THESE KEYWORDS INTO AN ANALYTICS SOFTWARE**
3. **RETRIEVE DATA FROM THE ANALYTICS SOFTWARE AND STORE IT IN GOOGLE SHEET**
Hi, I have an idea for an app, specifically an automation:
To automatically enter many keywords into a software, I understand I can use a no-code platform like UiPath. Could I also do that with n8n? And what's the difference compared to using a script? Is a script better, and if so, would Python, Apps Script, or something else be the best option?
There’s an application called Zik Analytics that lets me get a bunch of data about eBay, to make a better decision of products I could buy and resell. However, it does not provide as many things I wish. My idea is to automatically pull Zik's data into Google Sheet.
When I use Zik, I have to type my keywords (that I’ve previously scraped) to get the data associated with that keyword. So to avoid typing them one-by-one, I know I could use UiPath but maybe n8n can do this too, or other no-code software?
Since I've been watching videos trying to learn development basics and since I now understand I can use LLMs (large language models) to create extensions or applications, I'm wondering if using an LLM wouldn't be better than using a no-code platform?
I've tried n8n a few times, and it feels slow to configure. I haven't tried UiPath, but after finding a few tutorials, I see it is also complex to setup, compared to an LLM which feels like code you copy-paste, and it works instantly. Am I wrong? And if this advantage is valid what other advantages do LLMs provide?
Finally, those advantages potentially allow me to create an app or a Chrome extension. Is there any benefit to using an extension over an app, for what I am trying to build (mainly, using Google Sheet; and perhaps other apps). What is the best thing to build considering the requirements for the goal I am chasing?"
Thank you
Hello, could I send you an email
Very nice video, I hope you are my teacher. Could I have your Instagram ?
Thank you very much
You're welcome! :D