Amazon Storefront Scraper

Extract the entire catalog of any Amazon seller in Google Sheets.

An Amazon seller catalog provides vast amounts of information on product listings, but collating this data manually is a gargantuan task. Fortunately, our ready-to-use scraping solution allows you to extract any Amazon seller catalog directly from your spreadsheet!

What you get?

With =IMPORTFROMWEB(), you extract all the products available in any Amazon Seller storefront with the following data points:

  • title
  • image
  • link
  • price
  • rating
  • reviews_count
Step by step

First of all, make sure you have installed the ImportFromWeb add-on from the Google Workspace Marketplace.

Then, just follow these easy steps:

Open a new Google Sheets and activate ImportFromWeb

To activate the add-on, go to Extensions > ImportFromWeb > Activate add-on.

Activate ImportFromWeb add-on

Input the URL of your Amazon search

ImportFromWeb requires 2 parameters: a URL and one or more data selectors.

Copy the URL from the Amazon storefront to your spreadsheet.

Input the search page selectors

Data selectors describe the specific content you want to import from your storefront. 

Pick the selectors you are interested in from our Amazon search page selectors glossary and add them to your spreadsheet. For example, you may be interested in the asin, title, price and rating.

This is what your spreadsheet should look like:

Write the =IMPORTFROMWEB() function and extract the product data

Just add this formula: =IMPORTFROMWEB(A1,A3:D3)

Within seconds, you’ll get the data for the products in your search results!

We’ve designed an easy-to-use template.
Make sure you have installed and activated ImportFromWeb in your Google Sheets.