I’m new… I need help to create the following scenario:
Read a specific cell in MS Excel to extract a value (“value”).
Site Page #1: Login to a web portal w/ username & password (“URL-1”).
Site Page #2: Select (Post?) a “Continue” button (“URL-2”).
Site Page #3: Answer the cookies popup w/ “Reject All” button (“Cookie Popup”).
Same Page: Select (Post?) a “Submit” button (“URL-3”).
Site Page #4: Enter “value” (Step 1 above) into search box and select “Search”. (“URL-4”).
Site Page #5: Select the best match to “value” (“URL-5”).
Site Page #6: From here, you are taken to a summary page. What we want to do here is select the “Full Profile” button to go to the full description page (“URL-6”).
Site Page #7: We want to select all of the data from this page and paste it into MS Word.
I made a short 2-minute video, but the file is too large to post. Happy to email the vid if it helps.
The key tasks here are extracting a value from MS Excel, then logging into a website, making some nuisance button selections, dealing with a possible cookie popup, then entering the value and navigating to the data we want to copy/paste into MS Word.
For web scraping with user input, you can use ScrapeNinja.
ScrapeNinja’s “Scrape (Real Browser)” module runs the page in a web-browser so it closely emulates what users see, as opposed to just the raw page HTML fetched from the HTTP module.
ScrapeNinja can “interact with page” – fill in forms, and click links and buttons
However, this is a tad advanced to set up.
I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
An alternative option would be UiPath StudioX Community Edition as it excels at this scenario.
Perhaps a weekend to watch some online guide on that (yes, YouTube) will help you achieve this requirement as you follow along.
Make and UiPath are not substitutes but complementary tools so it will be well worth your time.
Based on personal experience with UiPath, I am confident you will be able to address this requirement using its built-in tools. However, don’t underestimate the power of Make!
In fact, you can then have UiPath relay info to your Make scenarios and you will have some robust reporting tools for internal and external use.
This Make YouTube video might help as well as it covers AI Web Scraping although clicking the box requirement for cookie policy is possible in UiPath but not sure about Make
at this scenario.