Extract any Amazon Search into Google Sheets

Gain access to any product offerings and identify
emerging products on Amazon straight in Google Sheets


We’ve created an Amazon Search scraper in Google Sheets that enables you to automatically import the product listings for any Amazon search query. Without any coding knowledge or complex software to download, you get the products lists of hundred Amazon products with their corresponding name, link, image, rating, price….

All you need is the ImportFromWeb add-on in Google Sheets and you’re ready to start importing powerful Amazon data into our template. With this kind of tool, you can easily analyze the product offerings in your business area, monitor your products rankings or identify emerging products and trends.

And all this without any technical knowledge!

Wanna test it? Great – let’s follow this easy step-by-step!

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 Search scraper template

Make a simple copy of the template to manipulate it and enter your Amazon query.

3. Activate the ImportFromWeb add-on

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

From there, open the 🚀 AMAZON SEARCH tab; you’re ready to start scraping any Amazon query!

4. Set up your query

3 settings are required:

  • your query
  • the Amazon store you want to collect data from
  • the number of searches pages you want to be scraped

Once done, just let the =IMPORTFROMWEB() function in cell D26 do the job!

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 the ImportFromWeb tool, you also have the ability to query any Amazon market.

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 (.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.

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.