Count eBay search results for every keyword in a Google Sheet

How to count eBay search results for every keyword in a Google Sheet: install the Chrome extension, click Build from description, tell the agent what you want, and follow its prompts. A working bot is built and tested in minutes.

Here is how the automation works. To count eBay search results in bulk, list the search URLs in a Google Sheet, loop through them, scrape the "33 results for…" number at the top of each search with Get data from bot's current page, and write it back into column B of the same row with Find row in a Google Sheet and Write data to a Google Sheet. Collected at scale, the count shows how many listings compete for a keyword: market saturation before you list, under-served niches, and how a niche moves over time.

Author
Alex Barlow
Published

Build the eBay count from a description


Describe it and click the button: the agent builds and tests the scraper in your Chrome extension. eBay runs Cloudflare bot detection, so turn on Bypass bot detection before you run.

  1. Open each eBay search URL in column A of my sheet
  2. Scrape the total number of search results
  3. Write the total in column B of the same row
Click to launch the Chrome extension. Not installed? You can create an account and try it free.Opens the Chrome extension. Free account to try.

You need a Google Sheet with one eBay search URL per row in column A and column B empty. Leave it as it is while the run writes the counts into column B.

The video shows the agent building the eBay result count from the three lines above, in two minutes.

Build the eBay count step by step


The steps the agent builds, as the Builder shows them: each step by its name, with the fields to set under it. Add them yourself in this order in the step-by-step builder, or open the agent's result there to adjust it.

  • 1.0 Read data from a Google Sheet
    • Spreadsheet: your sheet
    • Sheet name: the tab with one eBay search URL per row in column A
  • 2.0 Loop through data
    • repeats for every row in [google-sheet-data]
    • 2.1 Go to page
      • URL: column A of [google-sheet-data]
    • 2.2 Get data from bot's current page
      • Select: the bold result count above the listings, or the custom selector [class*="center-top"] h1 .BOLD:first-child
      • Max results: 1
    • 2.3 Replace text
      • Data to replace words: [scrape-data]
      • Text to replace: ,
      • Replace with: empty
    • 2.4 Find row in a Google Sheet
      • Spreadsheet: your sheet
      • Sheet name: the same tab
      • Values (comma separated): column A of [google-sheet-data]
      • Exact match: on
    • 2.5 Write data to a Google Sheet
      • Spreadsheet: your sheet
      • Sheet name: the same tab
      • DATA: the replaced count
      • Write options: Add to existing data
      • Starting cell: B[find-row-google-sheet]

Common questions about counting eBay results


Why does the eBay result count come back empty?

eBay has changed its layout and the selector no longer matches. Hand the failed run to the agent and it repairs the step, or open a search page and reselect the number in Get data from bot's current page.

Why does a Cloudflare "Verify you are human" page appear on eBay?

Bypass bot detection is off. Turn it on from the Cog icon in the builder, then run again.

Why do the eBay counts land in the wrong row?

Two URLs are too alike for a partial match. In Find row in a Google Sheet, turn on Exact match.

Can I write the eBay count to another column?

Yes. Change the letter in the starting cell on Write data to a Google Sheet: D[find-row-google-sheet] writes to column D. Keep the [find-row-google-sheet] token; it is what lines the count up with its row.

Why does the automation stop before the last eBay URL?

There is a gap in the URL column, or the wrong tab is read. Keep the URLs in one continuous column with no blank rows, and check Sheet name is the tab that holds them.

Can I use this for eBay keyword research?

Yes. The result count is how many active listings compete for a search, so a column of counts is an eBay keyword research sheet: a high count means a crowded niche, a low count with steady sales means an under-served one. Add the keywords you are weighing as search URLs and compare the counts.

Can I count sold listings instead of active ones?

Yes. Add &LH_Sold=1&LH_Complete=1 to each search URL and eBay shows the number of sold listings in the same header, so the same automation counts them. eBay asks you to sign in before it shows sold listings, so sign in to eBay in the browser the automation runs in; the agent stops and asks you if it hits the login page.

Does it work on ebay.co.uk and other eBay sites?

Yes. ebay.co.uk, ebay.de and the other eBay sites use the same "results for" header, so the same selector picks the count. Put the URLs for any site in column A; they can be mixed. Counts over 100,000 show as "110,000+"; the comma is stripped but the plus sign is kept, so add a second Replace text step with + in Text to replace if you want a plain number.

Can I track the eBay counts over time?

Yes. Save the automation and set a schedule; each run writes the current counts, so a dated column or a second tab shows how a niche moves.

Where do I get help?

Get in touch with support, or ask in the axiom.ai community.

Related guides