Clever Geek Handbook

How do I get Amazon pricing information in Google Sheets?

In the old version of Google Spreadsheets, this can be done using the following formula:

=value(importXml("http://www.amazon.com/<your url here>", "//b[@class='priceLarge']"))

However, this doesn't work in the newer version of Google Spreadsheets.

How to do it now?

0


source to share


3 answers


This worked for me:



= ImportXML (hyperlink (concatenation ("AMAZON_URL_HERE")), "// * [@ id = 'priceblock_ourprice']")

+1


source


You must replace a; to make it work: =importxml(hyperlink(concatenate("AMAZON_URL_HERE"));"//*[@id='priceblock_ourprice']")

You can also specify an element, for example: =importXml("AMAZON_URL_HERE";"//span[@id='priceblock_ourprice']")



The syntax is explained here:
http://www.w3schools.com/xpath/xpath_syntax.asp

+1


source


= importXml ("AMAZON_URL_HERE"; "// span [@id = 'priceblock_ourprice']") doesn't work

0


source






More articles:


All Articles