How to scrape Amazon search results?

Author: Matt
Published: August 1, 2023
Export Amazon search results into Google Sheets

There are many reasons why one would like to scrape Amazon search results. One could be the need to monitor the Amazon rankings of the product being sold by a company. Another could be to monitor competitors’ products and the product offering in the market niche. Or you might want to get an overview of the pricing of the similar products.
All of these use cases require a simple, easy to use and reliable Amazon Search scraper. In this article we are going to show you how to easily scrape the Amazon search results and extract the data directly into a Google Sheet or an Excel document.

Possible approaches for Amazon scraping

There are several approaches on how Amazon search results can be scraped. Some of them require more technical knowledge while some of them do not require any code understanding and the best approach would differ from case to case. So let’s consider these possible approaches and solutions:

  • Apify Amazon scraper is a ready to use Amazon scraping tool that starts with a free tier which is limited to a small amount of searches. The paid version starts from $49 per month and it grows fast to $499 per month for a small team of users which makes it an expensive alternative
  • Smartproxy eCommerce Scraping API is a scraping tool that uses API calls in order to retrieve the data from any eCommerce site including Amazon. However in order to use this tool you will need to have some coding skills
  • Octoparse offers a nice looking UI for scraping Amazon searches but it offers a lot of additional features which makes it a bit hard to start with. Also this is one of the most expensive tools on the market starting with $89 per month

ImportFromWeb solution for Amazon scraping

Realizing that there is a lack of good and affordable solutions on the market, we at NoDataNoBusiness have created ImportFromWeb – the one and only tool that is installed as a Google Sheet add-on and allows you to scrape any data from any website using a simple function based on XPaths or CSS selectors.

Using ImportFromWeb you can scrape the Amazon recommendations and search results into a Google Sheet document that allows you to easily share and adjust the data in any way. The data can also be exported in one of the many supported formats like Excel, PDF, Word or others.

And for the more advanced users, ImportFromtWeb allows additional features like GEOlocation scraping where you can choose the country for which you want to scrape the data. This will allow you to for example scrape the Amazon search results from multiple countries in a matter of seconds and get the data in a single Google Sheet! That’s pretty cool, isn’t it?

How to use ImportFromWeb for Amazon search results scraping

In this tutorial we are going to show how you can easily scrape the Amazon search results with zero coding skills required. Thanks to our built-in selectors, ImportFromWeb is a fully no code tool and anyone can make the most of it. So let’s start.

The goal of this tutorial is to scrape all the Amazon search results for the query “yoga mat”. We are going to select the main data points that we want to extract from the results like: product name, price, number of reviews and rating. This is how our document will look like with this setup:

In order to accomplish this, we have used a single function: 


where A1 points to the Amazon search URLs, and in the columns A2:D2 we have added all the data points that we want to extract from the available Amazon search selectors (image, asin, title, price, rating, number of reviews, product link and featured image URL, etc… )

With this simple setup we have managed to pull all the products from the 1st search result page.

And if you like to extract the second or any other page that is also easily doable. All you need to do is to simply add the page number in the Amazon Search URL like for example:

  • case&page=2 for the second page
  • case&page=3 for the third page and so on

ImportFromWeb works with most of Amazon markets, including US (.com), Canada (.ca), Mexico (, Brazil (, UK (, France (.fr), Germany(.de), Netherlands (.nl), Spain (.es), Italy (.it), Turkey (, India (.in), Saudi Arabia (.sa), UAE (.ae), Japan (.jp), Australia (.au), Singapore (.sg)

Main benefits of using ImportFromWeb

ImportFromWeb allows you to scrape all the available data points for each product which is more than most of the tools out there. The full list of Amazon selectors can be found on this page. The data is imported directly into a Google Sheet document that allows you to easily share, manipulate or extract the data based on your specific needs.

The data scraping scheduling setup allows you to monitor the products ranking on an hourly, daily or weekly basis and all of that to be completely automated.

Introduction to our ready to use template

Using ImportFromWeb and its single function is accessible for everyone even without technical knowledge. But in order for you to scrape Amazon products listings even faster, we have created a ready-to-use template where you only need to change a few values and to scrape the Amazon search results in a matter of minutes. This is how the template looks like:

On the bottom of the screen you will find the “Get started” tab containing explanation which guides you in creating your own copy from the template.

Once done, there are 2 values that needs to be changed in the document in order to adjust it for your search:

  • your query
  • your Amazon market

And with these 2 simple changes you can scrape pretty much any Amazon search results!


There aren’t that many tools that can be used effectively for scraping Amazon search results. Some of them are limited in terms of product data that can be scraped and some find scraping paginated data challenging. Also the costs for using these tools rises very fast to hundreds or more dollars per month.

That is why we have created the ImportFromWeb – a fast, easy and reliable solution for scraping any data on any website. With ImportFromWeb you can scrape Amazon search results in no time and get all the data into a Google Sheet or an Excel document. Having the data in this format allows you to easily share it, to export it to one of the many supported export formats or update it in any way that you need.

The Amazon search results scraping provides you with an overview of the products shown based on your search query. However in case you want to collect more data from Amazon, we invite you to browse ur catalog of ready-to-use Amazon scraping solutions.

So what are you waiting for? Click here to install the addon and start scraping your Amazon search data in a matter of a few minutes!