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.
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.
- Open each eBay search URL in column A of my sheet
- Scrape the total number of search results
- Write the total in column B of the same row
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 SheetSpreadsheet: your sheetSheet 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 pageURL: column A of[google-sheet-data]
- 2.2
Get data from bot's current pageSelect: the bold result count above the listings, or the custom selector[class*="center-top"] h1 .BOLD:first-childMax results: 1
- 2.3
Replace textData to replace words:[scrape-data]Text to replace: ,Replace with: empty
- 2.4
Find row in a Google SheetSpreadsheet: your sheetSheet name: the same tabValues (comma separated): column A of[google-sheet-data]Exact match: on
- 2.5
Write data to a Google SheetSpreadsheet: your sheetSheet name: the same tabDATA: the replaced countWrite options: Add to existing dataStarting cell:B[find-row-google-sheet]
- repeats for every row in
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
Scrape Instagram post links for every search term in a Google Sheet
- Read the search terms from my Terms tab
- Search Instagram for each term
- Collect every post link on the results
- Write them to my Posts tab and delete the term
Extract data from HTML with AI into a Google Sheet
- Open each URL in column A of my sheet
- Ask me which data the AI should extract
- Put the results in that URL's row from column B
Scrape Helium10 Magnet keywords into a Google Sheet
- Read the search terms from my sheet
- Search each one in Helium10 Magnet
- Scrape each keyword phrase and its CPR
- Add them to the data tab of my sheet
- Delete the search term once it is done