Hello Everyone I am trying to extract Different sizes available for all product from URL to googlesheet but it is Showing N/A everytime when I try to get it using IMPORTXML. I am copy xpath from rightclick and Paste it into formula still not able to extract information. URL is safguard.com where all the safety shoes can be ordered. Please find below Link:https://www.safgard.com/mens-shoes?min_price=0&max_price=0&records_per_page=36¤t_page=1&order_by_column=purchases_last_six_months&order_by_modifier=DESC&gender=M
3 Answers
try:
=INDEX(IFERROR(REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(A1)),
"where Col1 starts with '$'", 0), "\$\d+.\d+")))
Generate a separate product Link and then create xpath for class Labels which will pull all the sizes for all the products. Apart from that it will directly redirect to the page for convenience.
Related