eBay Sold Prices in Google Sheets: Price to Sell, Not Guess
Pull real eBay sold prices into Google Sheets with =EBAYSOLD("keywords"): sold price, total price, date sold, shipping and condition for recent sales. Price from what buyers paid. 14 scraping credits per listing.
Phil Nguyen · 6 min read

=EBAYSOLD("keywords") returns recent eBay sold listings, with sold price, total price, date sold, shipping and condition, into your Google Sheet at 14 scraping credits per listing. You price from what buyers actually paid, not from what other sellers are asking, so items sell instead of sitting.
Picture a reseller with 20 items to list who checks sold comps by hand on eBay's filtered search, at about 4 minutes per item. That is 80 minutes before a single listing goes up. One formula per item, dragged down a column, collects the comps, and 10 comps per item costs 140 scraping credits.
How do I pull eBay sold listings into Google Sheets?
Type the formula in a cell:
=EBAYSOLD(keywords, marketplace, sortBy, maxResults)
- keywords (required): the item, as specific as you can make it. Include brand, model, variant and condition, for example
"iPhone 15 Pro Max 256GB unlocked". More specific keywords give more accurate prices. - marketplace: which eBay site to search.
"EBAY-US"by default. - sortBy:
"endedRecently"(most recently sold first, the default),"timeNewlyListed","pricePlusPostageLowest","pricePlusPostageHighest"or"distanceNearest". - maxResults: how many sold listings to return, 30 by default.
A tight comp check for one item:
=EBAYSOLD("iPhone 15 Pro Max 256GB unlocked", "EBAY-US", "endedRecently", 10)
The cell shows ⏳ Scraping... straight away, and the sold listings arrive a little later. Results cover sales from the last 30 days.
What columns do I get?
The listings land in a new tab called Ebay Sold Listings Results. The first column, Source, holds the cell reference of the formula that fetched each row. Then come:
Title, Sold Price, Currency, Total Price, Date Sold, Shipping, Seller, Seller Rating, Item ID, URL, Condition, Listing Type, Best Offer Accepted, Shipping Type, Seller Feedback Count.
Here is the shape of the output, with made-up values for illustration:
| Source | Title | Sold Price | Currency | Total Price | Date Sold | Condition |
|---|---|---|---|---|---|---|
| B2 | Example phone 256GB unlocked | $612.00 | USD | $627.00 | 2026-11-08 | Used |
| B2 | Example phone 256GB, boxed | $655.00 | USD | $655.00 | 2026-11-06 | Used |
What can I do with the sold prices?
- Set a list price that sells. Take the median of Total Price for each item, which counts what the buyer paid including shipping. In the results tab, column E is Total Price, so
=MEDIAN(FILTER('Ebay Sold Listings Results'!E:E, 'Ebay Sold Listings Results'!A:A="B2"))gives the median for the item whose formula is in B2. Listing near that figure is pricing from evidence, and it replaces the 80 minutes of manual comps in the example. - Skip stock that will not pay. Before you buy inventory, run EBAYSOLD on it. If recent Total Prices sit below your cost plus fees, walk away. That is money not lost on items that would have sold at a loss.
- See how often buyers negotiate. Filter Best Offer Accepted to the rows where it is true. If many sales went through Best Offer, expect offers and set your own minimum before they arrive.
- Compare countries before listing abroad. Run the same keywords with
"EBAY-US"and"EBAY-GB"and compare the medians, reading the Currency column for each, to see where an item sells better.
Can I check other eBay countries and sort orders?
Yes. marketplace accepts EBAY-US, EBAY-GB, EBAY-DE, EBAY-AU, EBAY-CA, EBAY-FR, EBAY-IT and EBAY-ES. For sortBy, "pricePlusPostageLowest" puts the cheapest sales including shipping first, which is useful when you want the floor of the market rather than the latest sales.
The formula has no filters for price range, condition, auction versus Buy It Now, item location or days back. Pull the listings and filter the Sold Price, Condition or Date Sold columns in the sheet.
How much does it cost and how do I scale to many items?
EBAYSOLD costs 14 scraping credits per listing, and returns 30 listings by default. That makes a default formula 30 x 14 = 420 credits. Set maxResults to 10 and it is 140 credits, usually enough comps to price an item.
The Solo plan includes 10,000 scraping credits a month. The Free plan includes 100. If your balance cannot cover the full maxResults, SheetMagic lowers maxResults to the number of listings your balance does cover, so 100 credits returns up to 7 listings. If it cannot cover even one, the cell shows an out of credits message with the amount needed and the amount you have. See AI tokens vs scraping credits for how credits work.
To price many items, put each item's keywords in column A, starting at A2. In B2 type =EBAYSOLD(A2, "EBAY-US", "endedRecently", 10) and drag it down. Formulas dragged down one column share one results tab, and the Source column says which item each sale belongs to. In the example, 20 items at 10 comps each is 20 x 140 = 2,800 credits.
What are the pitfalls?
- Vague keywords. "iPhone 15" mixes storage sizes, models and broken units into one median. Add the variant and condition.
- The $ sign on every price. Sold Price, Total Price and Shipping are written with a $ sign, even on EBAY-GB or EBAY-DE. Read the Currency column for the real currency.
- Waiting on the cell. ⏳ Scraping... is normal while the search runs. The listings then appear in the results tab, never below the formula.
- Nesting EBAYSOLD inside AITEXT. The formula returns the Scraping placeholder first, so AITEXT would read the placeholder. Put AITEXT in its own column and point it at the result cells, for example a Title cell.
- Re-running a frozen formula. With Keep Formula on (the default) the formula cell is kept as text so it does not run and charge again. Delete the leading apostrophe to refresh the comps. Each refresh is a new run and is charged again.
For Amazon pricing research, see Amazon product research in Google Sheets. For every scraper in one place, see the web scraping guide.
Text and scraping formulas run on the free allowance. Install from the Google Workspace Marketplace, no card, no expiry.
Install free for Google SheetsAbout the author
Phil NguyenPhil builds SheetMagic, the Google Sheets add-on that brings AI and web scraping into the spreadsheet, used by 6,000+ people. He writes these guides from the formulas he runs on his own sheets.
