eBay
WebToSheets supports two eBay page types: a single listing and a search results page, each with its own selectors.
lightbulb
Thankfully, you do not need to write any of this by hand. Open the sidebar's
Formula Builder, pick eBay, choose
Listing or Search results, and fill in the rest.
info
Supported domains
Note that WebToSheets supports eBay's international marketplaces, so you may pull from regional sites too:com, co.uk, com.au, de,
ca, fr, it, es, at, ch,
com.sg, com.my, ph, ie, pl, nl.
Scraping a single listing
To pull one item's details, you may point =SCRAPE() at a listing URL like ebay.com/itm/<item-id>.
Available selectors
| Field | Selector | Example value |
|---|---|---|
| Listing title Listing title |
title
|
Fujifilm GFX 100 II Body |
| Price Current price (numeric value only) |
price
|
7499.00 |
| Currency Currency code from the price |
currency
|
USD |
| Original price Original/strike-through price |
list_price
|
7999.00 |
| Condition Item condition (e.g. Brand New, Very Good - Refurbished) |
condition
|
Brand New |
| Brand Brand name |
brand
|
Fujifilm |
| Model Model name |
model
|
GFX 100 II |
| Seller Seller username |
seller_name
|
cameradealer |
| Seller positive % Seller positive feedback (e.g. "99.4% positive") |
seller_rating
|
99.8% |
| Seller feedback count Number of seller feedback ratings |
seller_reviews_count
|
5432 |
| Shipping cost Shipping cost (numeric value) |
shipping_cost
|
0.00 |
| Shipping notes Shipping description (e.g. "Free 1-2 day delivery") |
shipping_notes
|
Free 2-day shipping |
| Return policy Seller return policy |
return_policy
|
30 days returns |
| Image URL Listing image URL. Use image/2 for the second image, etc. |
image
+ /N
|
https://i.ebayimg.com/… |
| Quantity / sold Available quantity or units sold, as shown by eBay |
quantity
|
3 |
| eBay product ID eBay Product ID (ePID) |
epid
|
12345678901 |
Example
To track a single listing's title, price, and condition, pass those selectors to =SCRAPE() as the second argument:
=SCRAPE("https://www.ebay.com/itm/356227875584", "title,price,condition")A
B
C
1
|
Fujifilm GFX 100 II Body
7499.00
Brand New
fx
Scraping search results
Sometimes you want an entire search page rather than a single item. To do so, you may point =SCRAPE() at a
/sch/ path with an _nkw keyword. Every selector then returns a
column of results (one full search page, often 50+ items). If you would like just one row,
you may add /N to the selector.
Available selectors
| Field | Selector | Example value |
|---|---|---|
| Result title Listing titles |
product_title
+ /N
|
Fujifilm GFX 100 II |
| Price Item price |
price
+ /N
|
7499.00 |
| Result URL Listing URLs |
product_url
+ /N
|
https://ebay.com/itm/3562… |
| Condition Item condition |
condition
+ /N
|
Pre-Owned |
| Image URL Result image URLs |
image
+ /N
|
https://i.ebayimg.com/… |
| Shipping cost Shipping cost |
shipping_cost
+ /N
|
10.50 |
| Item location Item location |
shipping_location
+ /N
|
United States |
| Free returns Free returns label (when offered) |
free_returns
+ /N
|
Yes |
| Watchers Number of watchers (when shown) |
watchers
+ /N
|
234 |
| Items sold Number of items sold (when shown) |
items_sold
+ /N
|
1250 |
| Seller Seller name |
seller_name
+ /N
|
toprated99 |
| Seller feedback count Seller feedback count |
seller_rating_count
+ /N
|
8901 |
| Buying format Buying format (e.g. Buy It Now, Best Offer) |
extra_info
+ /N
|
Almost gone |
Example
To compare titles, prices, and sellers across a search, pass those selectors to =SCRAPE():
=SCRAPE("https://www.ebay.com/sch/i.html?_nkw=fujifilm+gfx", "product_title,price,seller_name")A
B
C
1
|
Fujifilm GFX 50R Medium Format Mirrorless Camera 51.4MP - Excellent
2525.00
pierce334
2
Fujifilm GFX100S Medium Format Camera (Body Only)
3499.00
comp_ghost
3
Fujifilm GFX 50S II 51.4MP Body with Accessories - Excellent
2500.00
amzho_1
4
Fujifilm GFX100RF Digital Camera (Silver), MINT 1500 Shutter Count
4399.00
yood3
5
Fujifilm GFX 50R 51.4MP Mirrorless Camera Body, 2 Battery, Charger
2198.00
homerbev
6
Fujifilm GFX 50S 51.4MP Medium Format Camera - Black (Body Only)
1600.00
alesssangu_94
7
Fujifilm GFX 50S Camera w/ EVF-GFX1 Viewfinder, 2x OEM Batteries
1799.95
computeroverhauls
8
Fujifilm GFX 100 102MP Mirrorless Camera w/ Battery and Charger
3289.99
itsworthmore
9
Fujifilm GFX 100 102MP Medium-Format Mirrorless Camera Body #71
3294.60
mapcamera
10
Fujifilm GFX 100 II Medium Format Camera, ShutterCount 31710 [Near Mint]
5850.30
kabukicamera
11
Fujifilm GFX 100RF Silver, Shutter Count 343 [Top Mint]
3999.00
aoscamera_97
12
Fujifilm GFX 100S Mirrorless Camera Body, Shutter Count 12975 [Exc+3]
2811.00
united_camera
13
Fujifilm GFX 100 102MP Medium Format Camera, Shutter Count 32770
2995.00
epe_ab
14
Fujifilm GFX 50S Digital Camera Body, Black (Preowned)
1579.95
ja154292
15
Fujifilm GFX 100 II Medium Format Camera, ShutterCount 10036 [Near Mint]
6199.00
gusulabo.japan
fx
Still stuck?
We usually reply within 24 hours on business days.