How to save amazon product price to excel in loop

Help Studio
, , ,
1

I want to write Amazon product prices to Excel sheet.
Suppose every time I have to log in to amazon search for a product and save its price to excel

2

@Mozammil

Use data extraction/Table extraction it would directly extract it into excel

cheers

3

Hi @Mozammil,

Try following steps:

– Open Browser or Use Browser/ Application (Amazon URL)
– Type into (To search the required product)
– Table Extraction or Data extraction ( Will extract all required data and save it in datatable)

image

– Write range (To write it into a excel).

Hope it works.

Regards,
Harshith

1 Like
4

Hello @Mozammil
Refer to this video you May get some idea

5

Hello @Anil_G @Harshith_Adyanthaya

Thanks for quick reply. But my task is to click on product read price and write to excel.

6

@Mozammil

Then use for each ui element to click on each product…then you can use get text inside to get the price field…make sure the selector for price is dynamic so that it supports any product…use ui explorer to get better selector and edit it

Hope this helps

cheers

7

any other option instead of using data scraping

8

That is the easiest and most efficient solution.

9

@Mozammil ,
Data Scraping is the easiest way to do this . Other than that you can use "Find children "Activity and can scrape the data.

Regards,