How to Fetch Live Amazon Listings in Google Sheets

Audit your catalog attributes and create listings in other marketplaces

Introduction

Managing an Amazon catalog means constantly checking whether your listings have the right attributes — correct titles, images, pricing, bullet points, and product types. But verifying this data in Seller Central means clicking into each listing one at a time. If you have hundreds or thousands of SKUs, that's simply not feasible.

And when you're ready to expand to new marketplaces — Canada, Mexico, UK, Germany — you face another challenge: re-entering all your listing data from scratch for each new marketplace. There's no easy way to copy your existing listing attributes and submit them elsewhere.

SellerSheet's Live Listings feature solves both problems with two workflows:

  • Fetch & Audit Live Listings — Pull real-time listing data for all your SKUs directly into Google Sheets. Review every attribute Amazon is using — status, images, issues, product type — in one spreadsheet view.
  • Create Listings in Other Marketplaces — Use the JSON data from your fetched listings to create the same listings in other Amazon marketplaces with minimal effort.

Video tutorial coming soon

Prerequisites

  • Store Authorization: Ensure you have authorized your Amazon store on the SellerSheet Dashboard.
  • Sidebar Installed: You need the SellerSheet Google Sheets sidebar installed. If not, follow the Onboarding Guide.
  • SKUs Ready: You need a list of SKUs to fetch. You can get these from the All Listings Report (via Store Reports) or enter them manually.

How the Sidebar Works

Before diving into Live Listings, here's a quick reminder of how SellerSheet works. Every feature follows the same three-step pattern:

1

Go to the right sheet

Each feature has its own spreadsheet and sheet tabs. Navigate to the correct one first.

2

Fill in the colored columns

Yellow = required, Light Yellow = optional, Gray = auto-filled.

3

Click the sidebar button

Buttons inside a named dropdown only work when you're on that matching sheet tab.

For the full guide — including color coding details and tooltips — see the How SellerSheet Sidebar Works section in the documentation.

Getting Started

The Live Listings feature uses the Create Listings spreadsheet. If this is your first time, SellerSheet will create it automatically in your SellerSheet Google Drive folder. This spreadsheet contains multiple sheet tabs including Live Listings and Create Listings.

Opening the Spreadsheet

There are two ways to get to your Create Listings spreadsheet:

A From Google Drive

Open your SellerSheet folder in Google Drive, then open the Create Listings spreadsheet. Launch the sidebar from Extensions → SellerSheet and navigate to the Create Listings tab.

B From My Resources

Open the sidebar in any Google Sheet, go to the Home tab, and click the Create Listings link under My Resources. This opens the spreadsheet directly — then reopen the sidebar from Extensions.

Screenshot: SellerSheet sidebar with Create Listings tab showing Live Listings dropdown

The Create Listings tab in the SellerSheet sidebar

Getting Your SKU List

Before fetching live listings, you need a list of SKUs. The fastest way to get your complete catalog of SKUs is from the All Listings Report — an Amazon report that contains every active listing in your Seller Central account.

Option A: Copy SKUs from All Listings Report

  1. Open the Store Reports spreadsheet (see the Store Reports tutorial).
  2. In the Store Reports sheet, create a report with Report Name set to All Listings Report and your Store name.
  3. Click Create Reports, then Get Reports to download it.
  4. Open the downloaded report — it contains your full catalog with SKU, ASIN, price, and other basic fields. Copy the SKU column.

Option B: Enter SKUs Manually

If you only need to check a few specific listings, you can type the SKUs directly into the Live Listings sheet. No report needed.

Pro Tip: Full Catalog Audit

For a complete catalog audit, use the All Listings Report to get every SKU in your account, then paste them all into Live Listings. This gives you a comprehensive view of your entire catalog's health in one spreadsheet.

Workflow 1: Fetch & Audit Live Listings

The Problem

You have hundreds of SKUs and need to verify which attributes Amazon is actually using — titles, images, pricing, bullet points, status, product type, and listing issues. But Seller Central only lets you check one listing at a time. Opening each ASIN, scrolling through the edit page, noting down discrepancies — it's hours of tedious manual work with no way to compare listings side by side.

With SellerSheet's Live Listings, you can fetch real-time listing data for all your SKUs at once and review everything in a spreadsheet. Here's how:

1. Fill in Store and SKU Columns

Navigate to the Live Listings sheet tab within the Create Listings spreadsheet. Fill in the required columns:

  • Store: Your store identifier (e.g., MyStore-US).
  • SKU: The seller SKU for each listing you want to fetch. Paste your list from the All Listings Report or type them in.

Screenshot: Live Listings sheet with Store and SKU columns filled in

The Live Listings sheet with Store and SKU columns ready for fetching

2. Click Get Listings

In the sidebar, expand the Live Listings dropdown under the Create Listings tab, then click Get Listings. SellerSheet calls Amazon's Listings Items API for each SKU and populates the sheet with real-time data.

The API processes SKUs in batches of 50, so even large catalogs are handled efficiently. All rows with a Store and SKU filled in will be processed.

3. Review the Results

After fetching, the following columns are auto-filled for each SKU:

Live Listings Column Reference

  • Store + SKU: You fill these in (required).
  • ASIN: The Amazon Standard Identification Number for this listing.
  • Image: The main listing image URL.
  • Last Updated Date: When Amazon last updated this listing's data.
  • Status: The listing's current status (e.g., BUYABLE, DISCOVERABLE).
  • Product Type: The Amazon product type classification (e.g., PRODUCT, LUGGAGE).
  • Issues: Any listing quality or compliance issues flagged by Amazon.
  • JSON: The full API response as JSON — used for creating listings in other marketplaces.
  • Dynamic Attributes: All listing attributes (title, bullet points, brand, etc.) are extracted into individual columns automatically.

Screenshot: Live Listings sheet with fetched data showing ASIN, status, product type, and attributes

Fetched live listing data with all attributes expanded into columns

Pro Tip: Audit Listing Issues

Pay special attention to the Issues column. Amazon flags problems like missing attributes, image quality warnings, and compliance violations here. You can filter or sort by this column to quickly find listings that need attention.

Listing Status Meanings

  • BUYABLE: The listing is live and available for purchase.
  • DISCOVERABLE: The listing appears in search results but may have restrictions.
  • NOT_BUYABLE: The listing exists but is suppressed or inactive — check the Issues column for details.

Workflow 2: Create Listings in Other Marketplaces

The Problem

You already sell in the US marketplace and want to expand to Canada, Mexico, UK, or Germany. But each new marketplace requires you to re-enter all your listing data — title, bullet points, description, images, keywords — from scratch. For sellers with hundreds of ASINs, manually recreating listings across multiple marketplaces is a massive time investment and prone to errors.

The JSON data from Live Listings contains your complete listing attributes in the exact format Amazon's API expects. You can copy this JSON into the Create Listings sheet, change the store to your target marketplace, and submit — SellerSheet handles the rest.

1. Fetch Your Existing Listings

First, complete Workflow 1 above to fetch your live listings. Make sure the JSON column is populated for the SKUs you want to replicate.

2. Copy the JSON to Create Listings Sheet

Switch to the Create Listings sheet tab. For each listing you want to create in another marketplace:

  1. Copy the JSON value from the Live Listings sheet for that SKU.
  2. Paste it into the JSON column in the Create Listings sheet.
  3. Fill in the Store column with your target marketplace store (e.g., MyStore-CA for Canada, MyStore-UK for UK).
  4. Fill in the SKU column — use the same SKU or a new one for the target marketplace.
  5. Fill in the required fields: Language Local, Barcode Type, and Barcode Value as needed for the target marketplace.

Screenshot: Create Listings sheet with JSON pasted from Live Listings and target store set

Create Listings sheet configured with JSON from Live Listings for a new marketplace

3. Validate Your Listings

Before submitting, click Preview / Validate Listings in the sidebar. SellerSheet sends the listing data to Amazon for validation without actually creating the listing. This lets you catch issues — missing required attributes, invalid values, marketplace-specific requirements — before they cause submission errors.

4. Submit to Amazon

Once validation passes, click Create / Update Listings in the sidebar. SellerSheet submits each listing to Amazon via the Listings Items API. The Status column updates to show whether the submission was accepted.

Important: Marketplace-Specific Adjustments

Some attributes may need adjustments for the target marketplace. For example, product descriptions may need to be translated, prices need to be in local currency, and some product types or category requirements differ between marketplaces. Always validate before submitting to catch these differences early.

Pro Tip: Validate Before Submitting

Always use Preview / Validate Listings first. This dry-run catches issues like missing required attributes or invalid category mappings without affecting your live account. Fix any flagged issues, then submit with confidence.

Which Workflow Should You Use?

Each workflow is designed for a different need. Use this table to choose the right one:

What You NeedWorkflowSheetBest For
Check listing attributes & statusFetch & AuditLive ListingsCatalog audits, finding suppressed listings, verifying attributes
Expand to new marketplacesCreate in Other MarketplacesLive Listings + Create ListingsReplicating US listings to CA, MX, UK, DE, etc.

Maximizing Efficiency with Google Sheets

Since all your listing data lands in Google Sheets, you can leverage its full power for analysis and automation:

  • Full catalog health check: Combine the All Listings Report with Live Listings to get a complete picture. The report gives you the basic catalog data; Live Listings gives you the detailed attributes and issues.
  • Filter and sort by issues: Use Google Sheets' built-in filter feature to quickly find all listings with issues, or sort by status to group suppressed listings together.
  • Cross-reference with VLOOKUP: Use VLOOKUP or INDEX/MATCH to cross-reference Live Listings data with your own inventory spreadsheets, pricing sheets, or order data.
  • Bulk marketplace expansion: Fetch all your US listings, copy the JSON column for all rows, paste into Create Listings, and set the store to your target marketplace. Process hundreds of listings across marketplaces in minutes instead of days.
  • Track changes over time: Periodically re-fetch your live listings and compare with previous snapshots to detect unexpected attribute changes, status changes, or new issues.
WhatsApp WhatsApp