Extract Amazon product details into Google Sheets

We’ve created an Amazon scraper in Google Sheets that enables you to compare product titles, images, prices, ratings, and links without any coding knowledge or complex software to download. We have configured more than 60 data points ! All you need is the ImportFromWeb add-on in Google Sheets and you’re ready to start importing powerful Amazon data into our approachable template.

With this kind of product research at your constant disposal, you can improve competitor benchmarking, follow market pricing trends without having to manually update your data, and compare your product offerings against others in your space to improve your ecommerce strategies. 

And all with just a basic knowledge of Google Sheets.

Are you intrigued? Great – because we’d love to show you how to scrape Amazon data with this straightforward template.

How does it work?

It uses the ImportFromWeb add-on that we built.

ImportFromWeb provides a simple function to extract data from any websites. You just need to find the urls of the pages you want to load and tell ImportFromWeb about the location of the elements you want to extract from those pages.

1. Install the ImportFromWeb add-on

ImportFromWeb is the add-on that collects the data. Simply install it from the Google Workspace Marketplace. You can try it for free, we offer you 1,000 requests (no credit card required!)

2. Make a copy of the Amazon Product scraper template

Make a simple copy of the template to manipulate it with the products that you wish to scrape from Amazon

3. Activate the ImportFromWeb add-on

Easy step too! In your template copy, activate the add-on through your Google sheets menu: Extensions >> ImportFromWeb >> Activate add-on

From there, open the second tab of the template (“🛒 Amazon Products Comparison Tool”) and start scraping! All you need to do is to find the products ASIN numbers from Amazon and paste them into the template!

The ASIN number is a unique identity number that appears in the Amazon product URL after /dp/

4. Input the ASINs of the products you want to compare

Input ASIN numbers into the ‘ASINs List’ column of the template and watch the scraped product information roll in. No HTML experience necessary.

And that’s it! Now you have all of the information to scrape Amazon best sellers, competitor products, and latest trends to improve benchmarking and your future ecommerce strategies.

To make better use of this template and our ImportFromWeb tool, here are a few other tips to ensure that your web scraping experience is giving you full access to valuable Amazon data:

Tip #1: Always stay up-to-date

Extracting data from Amazon product pages can be incredibly rewarding, but you don’t want this information to lose its value over night. Improve your Amazon trends and price monitoring by configuring your template with our advanced cache system to keep your information up to date. 

Based on your preferences, you can instruct the ImportFromWeb tool to update information as frequently as you like so that you’re always scraping the most current product research from your Amazon web pages.

This is a reliable way to base your ecommerce strategies on current and relevant data rather than searching through old information.

Tip #2: Scrape Amazon data from multiple markets

Don’t let geography limit you. With ImportFromWeb, you also have the ability to query a website within different markets. 

Just select the Amazon store you are interested in in the drop down menu and it will be applied to your template. You can scrape data from the following Amazon markets:

  • US (.com)
  • Canada (.ca)
  • Mexico (.com.mx)
  • Brazil (.com.br)
  • UK (.co.uk)
  • France (.fr)
  • Germany(.de)
  • Netherlands (.nl)
  • Spain (.es)
  • Italy (.it)
  • Turkey (.com.tr)
  • India (.in)
  • Saudi Arabia (.sa)
  • UAE (.ae)
  • Japan (.co.jp)
  • Australia (.com.au)
  • Singapore (.sg)

This is super helpful if you’d like to import local content like product descriptions or titles in specific languages. It can also enable you to monitor what product information displays in different countries, giving you insights into how to improve your own strategies in each market.

Tip #3 Use it anywhere

You don’t need to use this template to extract Amazon products information. It’s very easy to use the IMPORTFROMWEB function wherever you like.
Here is how you can do it:

  • Input your Amazon urls, each one in a different cell
A1https://www.amazon.com/dp/B089HJ5JXX
A2https://www.amazon.com/dp/B089HSHRH8
A3…etc
A5
:
G5
titleratingtimesEvaluatedpricefeaturedImageSourcea_plus_content
  • Use the IMPORTFROMWEB function
A7=IMPORTFROMWEB(A1, $A$5:$G$5)
  • Drag all the way down to the row with the last URL!

Any question?

If you feel stuck on anything at all, reach out to our team. We’d love to help you better understand our tools and templates so that you can achieve your desired results.