Import Amazon product Price and Title into Google Sheets

3
votes

I'm trying to figure out "how to" import price and title for items sold on Amazon into a Google sheet. I'm using this amazon URL structure https://www.amazon.com/dp/########## and replacing the ###'s with the ASIN number for the product. I'd like that URL to be used to populate the Title and Price columns in the sheet linked below.

I've tested several tutorials and SO posts and have the title working (but not perfect), but I can't seem to figure out price.

Any ideas? Thanks a MILLION!

Google Spreadsheet

https://docs.google.com/spreadsheets/d/1BkaKayngPkyfjOpzKRbYBAJAVWML9r3Fo-pN758CIrU/edit#gid=0

Working Formula For Title

=REGEXREPLACE(ImportXML("https://www.amazon.com/dp/"&B2,"//title"),"Amazon.com: ","")

Tutorials Tested

I found this solution that proves it can be done, but it won't work for my use case.

https://docs.google.com/spreadsheets/d/1ETaMSeCpEUlWQsEXPfVkOC4faQBWMIMLEmculbH9wIg/edit#gid=1

Product - https://www.labnol.org/internet/amazon-price-tracker/28156/

1
google-sheets
Have you been able to go any further on this? I'm curious to see current solutions! – bafromca

1 Answers

4
votes

Grab it from another price website.

=importXml("https://camelcamelcamel.com/product/"&B2,"//span[@class='green']")