Hey everyone! I’m trying to pull Amazon price data into my Google Sheet, but I’m hitting a wall. The old formula I used doesn’t work anymore. It was something like this:
=value(importXml("amazon-product-url", "//b[@class='priceLarge']"))
But now it’s giving me errors. Has anyone figured out a new way to do this? I’ve tried a few different approaches, but nothing seems to work. It would be super helpful if someone could share an updated method or formula. Maybe there’s a different function or add-on we need to use now? Any tips or tricks would be awesome. Thanks in advance for your help!
i’ve been struggling with this too! the old methods don’t work anymore cuz amazon keeps changing their site. have u tried using the IMPORTJSON function? there’s a script you can add to sheets that lets u pull data from amazon’s API. it’s a bit tricky to set up but works great once u figure it out. lmk if u want more details!
I’ve been using a combination of Apps Script and the Amazon Product Advertising API to fetch prices reliably. It requires some setup, but it’s been working well for me.
First, you’ll need to sign up for the Amazon Product Advertising API and get your credentials. Then, create a custom function in Apps Script that makes API calls to Amazon. Here’s a simplified example:
function getAmazonPrice(asin) {
// API call logic here
return price;
}
Then in your sheet, you can use:
=getAmazonPrice(“B07X6C9RMF”)
Replace the ASIN with your product’s. This method is more stable long-term, as it uses Amazon’s official API. It does have a learning curve, but it’s worth it for consistent results.
I’ve been dealing with this issue too. After some trial and error, I found a workaround using the IMPORTFROMWEB add-on for Google Sheets. It’s not perfect, but it’s been pretty reliable for me.
Basically, you install the add-on, then use a formula like this:
=IMPORTFROMWEB(“amazon-product-url”, “price”)
You might need to tweak the selector depending on the specific product page, but it generally works well. The downside is that it updates a bit slower than the old method, so you might want to set up scheduled refreshes.
Another option I’ve heard about but haven’t tried myself is using a third-party service like Keepa or CamelCamelCamel. They have APIs that might be easier to integrate with Sheets. Just something to consider if the IMPORTFROMWEB method doesn’t work for your specific needs.