How do I get Amazon pricing information in Google Sheets?

Question

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

xml amazon web-scraping google-spreadsheet formulas google-sheets

aCuria 05 Sep '14 at 6:41

source to share

3 answers

Jeff · Answer 1 · 2014-12-14T07:20:15+0000

This worked for me:

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

bitrrU · Answer 2 · 2015-01-11T20:12:51+0000

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

Dilermano duarte · Answer 3 · 2019-07-04T19:27:03+0000

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