Import current price from website to my google spreadsheet

by Khanh Nguyen   Last Updated October 18, 2018 09:03 AM

i try to update price from this link to my google sheet

Link http://camerashop.vn/collections/sony-mirrorless/products/may-anh-mirrorless-sony-alpha-a6000-body-den-graphite-bac-trang

code element

9,490,000₫10,990,000₫

i want to see price 9490 and 10990 in my google sheet

and i input in my google sheet is

=CONCATENATE(IMPORTXML("http://camerashop.vn/collections/sony-mirrorless/products/may-anh-mirrorless-sony-alpha-a6000-body-den-graphite-bac-trang","//*[@class='product-price',id='price-preview'][1]"))

however, my command is wrong, any one please fix for me

many thanks



Related Questions




Copying values between google sheets

Updated July 26, 2018 21:03 PM