Amazon 3P Sellers Tracking Tool

Track third-party seller activity on Amazon listings.

To help you get started right away, you can use this free Google Sheets template to extract all the offers for 1 specific listing or this template to track 3P sellers activity on multiple listings.

With our 3P Sellers tracking Tool, you effortlessly gain a strategic advantage in understanding market dynamics and pricing trends.

Uncover valuable pricing intelligence, identify key competitors, and assess their strategies with ease. Stay informed about changing market conditions, adapt your pricing strategies, and optimize your product positioning for maximum success.

Using the ImportFromWeb add-on and the function it adds to Google Sheets, you can track all Amazon Sellers Competing on a Listing, without technical knowledge!

What you get?

With =IMPORTFROMWEB(), you extract the following data points on sellers for hundreds of Amazon products.

price
type of offer
link to seller page
FBA / FBM
…

See all available Amazon product page data points

Step by step

Start with a Google Sheets template

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.

Input the Amazon product URLs

You can input the product URLs directly or build them using the product ASINs: =”https://www.amazon.com/dp/”&A2 (where column A contains all your ASINs).

Input the Amazon data selectors

Data selectors describe the specific content you want to import from the Amazon product pages.

In this case, we’re interested in data related to the offerings from Amazon sellers or vendors, so we’ll use sellers_names and sellers_prices.

For a full list, see our Amazon product page selectors glossary.

This is what your spreadsheet should look like:

Write the =IMPORTFROMWEB() function and extract Amazon competitor data

Just add this formula: =IMPORTFROMWEB(A2,B1:C1)

Within seconds, you’ll get the results for the first product.

Add the “compare” option

The function’s “compare” option ensures that the results for one product are all kept within the same row, without spilling over: =IMPORTFROMWEB(A2,B1:C1,"compare")