Google Sheets, Web scrape Best Buy Price

Question

im trying to figure out how to web scrape the price of a product into google sheets. Before i would use =importrange(A1,B1)

And have A1 = https://www.bestbuy.com/site/asus-17-3-chromebook-intel-celeron-n4500-4gb-memory-32gb-emmc-transparent-silver/6471189.p?skuId=6471189

And have B1 = /html/body/div[3]/main/div[2]/div/div[1]/div[3]/div[2]/div/div[1]/div[1]/div/div/div/div/div/div[2]/div[1]/div[1]/div/span[1]

This was done by coping the full Xpath. So far this has been working but unfortunately it seems like that is no longer a way to do it.

Im trying to do this for both Best Buy and Walmart

if i could have an example for these two links that would be awesome! Thank you in advanced!

Link 1: https://www.bestbuy.com/site/asus-17-3-chromebook-intel-celeron-n4500-4gb-memory-32gb-emmc-transparent-silver/6471189.p?skuId=6471189

Link 2:https://www.walmart.com/ip/Samsung-Chromebook-4-11-6-Intel-Celeron-N4020-4GB-RAM-32GB-SSD-Chrome-OS-Platinum-Titan-XE310XBA/153097702?athbdg=L1300

Answer 1

Functions in Google Sheets like IMPORTHTML, IMPORTXML, IMPORTDATA and IMPORTFEED may not retrieve data from a website if the content is added dynamically(using JavaScript). I will reference this answer:

If the content is added dynamically (by using Javascript), it can't be imported by using Google Sheets built-in functions. Also if the website webmaster have taken certain measures, this functions will not able to import the data.