How to get Watsons Thailand

Search public Watsons Thailand health and beauty products. watsons.co.th is one page of it. A run reads that public list and saves one row per result.

One row per result

A row has id, name, price, currency. The columns are listed in the schema on this page.

New rows from that site

Each run reads watsons.co.th again. Put it on a schedule and the next file is the latest rows from that site.

Watsons Thailand in Excel, Sheets, or Power BI

The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.

Schema

Examples come from the actor sample, not a live result.

Name	Description	Example
`id`	id	`BP_300926`
`name`	name	`Watsons Sakura Strawberry Shampoo 700ml.`
`price`	price	`109.00`
`currency`	currency	`THB`
`priceText`	priceText	`฿109.00`
`url`	url	`https://www.watsons.co.th/watsons-watsons-sakura-strawberry-shampoo-700ml./p/BP_300926`
`image`	image	`https://medias.watsons.co.th/publishing/WTCTH-300926-front-prodcat.jpg?version=1733811105`
`inStock`	inStock	`true`
`rating`	rating	`4.82`
`country`	country	`TH`
`retailer`	retailer	`Watsons`

ididBP_300926
namenameWatsons Sakura Strawberry Shampoo 700ml.
priceprice109.00
currencycurrencyTHB
priceTextpriceText฿109.00
urlurlhttps://www.watsons.co.th/watsons-watsons-sakura-strawberry-shampoo-700ml./p/BP_300926
imageimagehttps://medias.watsons.co.th/publishing/WTCTH-300926-front-prodcat.jpg?version=1733811105
inStockinStocktrue
ratingrating4.82
countrycountryTH
retailerretailerWatsons