Automate a task combining an Excel list and website data

Help
1

Hello guys,

Here is the deal. I started a new summer job, and was asked to do the following task:

  1. Open Excel, get a list of item numbers tied to a list of products.
  2. Copy/paste the item number into a search bar of a competitors website.
  3. Get an unique product page where the price is listed.
  4. Copy this price and paste it back into the Excel file.
  5. Repeat 1,561 times.

For obvious reasons this is poor use of human capital, and I would like to try to use UIPath to automate it as a personal for fun project. Though, I am inexperienced with UIPath and need your guidance on how to attack this problem.

Should I focus more on learning the basics as of now, or is there step-by-step examples (e.g. via YT or PDFs) of a similar task I could follow?

Thanks for your help!:grinning:

Kind regards,
PĆ„l

2

Hello and welcome!

Itā€™s always good to use the available learning portals to get the basics, so you can learn at your own pace and tackle the issues you face more efficiently.

That said the approach iā€™d probably take for this task would be the following:

  1. Read excel to datatable (Workbook - Read Range)
  2. Add new column (if not yet present) ā€˜Competitor priceā€™
  3. Open the search page (Open Browser)
  4. For Each Row in read Datatable
    {
    Type into search field row(ā€œItem Numā€).ToString
    Click Search
    Get Text - new price
    row(ā€œCompetitor priceā€) = newPrice
    }
  5. Write updated datatable to excel (Workbook - Write Range)

br,
Topi

3

Hi PĆ„l

Topiā€™s answer is spot on so follow that.

If you want to learn more about UiPath and RPA then use the academy for foundation training, it will give you a good understanding of the basics

https://academy.uipath.com/learn

1 Like
4

Exactly what I need, very much appreciated! Youā€™re a total homie!

1 Like
5

Hello, Go through this, it has every which you are looking for.
Web Automation UiPath: https://www.youtube.com/playlist?list=PL41Y-9S9wmyIl_GjHydCsfmIxm_JxYz1x