Amazon Search Scraper

Extract products data from Amazon Search Results pages in Google Sheets

To help you get started right away, you can use this free Google Sheets template

An Amazon search 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 select and extract the data points you want directly from your spreadsheet!

Analyze the product offerings in your specific business area, gaining valuable insights into market trends, customer preferences, and competitor strategies. Monitor your product rankings with precision, ensuring you stay ahead and optimize your visibility. Identify emerging products and trends early on, enabling you to adapt your offerings and capitalize on new opportunities.

Using the ImportFromWeb add-on and the function it adds to Google Sheets, you can extract the Product Data from the Amazon Search Results pages without technical knowledge!

What you get?

With =IMPORTFROMWEB(), you extract the following data points from any Amazon search results page:

  • asin
  • name
  • image
  • link
  • price
  • rating

See all available Amazon search page data points

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 your Amazon search to your spreadsheet.

Input the Amazon search URL

Input the search page selectors

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

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, rating, and reviews_count.

This is what your spreadsheet should look like:

Input Amazon data selectors

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

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

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

Write the IMPORTFROMWEB() funcion

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

Frequently Asked Questions

How to scrape in a specific language on Amazon?

Most of the time, the =IMPORTFROMWEB() function extracts the content of the ASINs in the default language of the Amazon store.

But sometimes, the language of the page loaded by ImportFromWeb isn’t right. For example, you’ll get the content in English for an amazon.de product, instead of being in German.

Luckily, you can force the language using the “language” parameter, as follow:

The new generated URL will look like: https://www.amazon.de/dp/B07NQ6R7R1?language=de_DE

And this is the URL you have to input into your =IMPORTFROMWEB() function!