Extract Amazon product images into Google Sheets

What if you could view Amazon product images directly into Google sheets? Explore a niche or analyze your competitor’s images? Make sure you have set the right images on your listings?

We’ve created an Amazon images collector that enables you to extract in bulk Amazon product images and vizualize them into Google Sheets. All you need is the ImportFromWeb add-on and you’re ready to start importing images into our easy-to-use template.

Let’s get started!

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 images collector 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 Images collector”) 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

Set the Amazon store you are interested in.

Input ASIN numbers into the ‘ASINs List’ row of the template and watch the scraped images roll in!

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: 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 #2: Use it anywhere

You don’t need to use this template to extract Amazon products images. 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
  • Use the IMPORTFROMWEB function
A7=IMPORTFROMWEB(A1, “image_1_source,image_2_source,image_3_source”)
  • 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.