eBay is one of the largest global marketplace besides Amazon. Whether your website is competing with this marketplace or because you are directly selling there, you can gain powerful insights for your commercial strategy by analyzing eBay data. With our custom-built function, ImportFromWeb, you can easily scrape and extract data from eBay.
We’ve created an eBay scraper in Google Sheets that enables you to compare product titles, images, prices, ratings, and links without any coding knowledge or complex software to download
How does it work?
Our function, ImportFromWeb, is built on top of Google Sheets extending its functionalities. It can extract any element available on a webpage. You can retrieve directly in Google Sheets any information you need and cross it with other data sources. How cool is that?
1. Install the ImportFromWeb add-on
ImportFromWeb is the add-on that collects the data. Simply install it from the Google Workspace Marketplace. You can try it for free, we offer you 1,000 requests (no credit card required!)
2. Make a copy of the eBay scraper template
Make a simple copy of the template to manipulate it with the products that you wish to scrape from eBay
3. Activate the ImportFromWeb add-on
In your template copy, activate the add-on through your Google sheets menu: Extensions >> ImportFromWeb >> Activate add-on
From there, open the second tab of the template (“🛒 eBay Products Comparison Tool”) and start scraping! All you need to do is to find the item numbers from eBay and paste them into the template!
The item number is a unique identity number that appears in the eBay product URL after /itm/
4. Input the item number of the products you want to compare
Input item numbers into the corresponding column of the template and watch the scraped product information roll in.
And that’s it! Now you have all of the information to scrape eBay best sellers, competitor products, and latest trends to improve benchmarking and your future ecommerce strategies.
To make better use of this template and our ImportFromWeb tool, here are a few other tips to ensure that your web scraping experience is giving you full access to valuable eBay data:
Tip #1: Always stay up-to-date
Extracting data from eBay product pages can be incredibly rewarding, but you don’t want this information to lose its value over night. Improve your eBay trends and price monitoring by configuring your template with our advanced cache system to keep your information up to date.
Based on your preferences, you can instruct the ImportFromWeb tool to update information as frequently as you like so that you’re always scraping the most current product research from your eBay web pages.
This is a reliable way to base your ecommerce strategies on current and relevant data rather than searching through old information.
Tip #2: Scrape eBay data from multiple markets
Don’t let geography limit you. With ImportFromWeb, you also have the ability to query a website within different markets.
Just select the eBay store you are interested in in the drop down menu and it will be applied to your template. You can scrape data from the following eBay markets:
- US (.com)
- Canada (.ca)
- Mexico (.com.mx)
- Brazil (.com.br)
- UK (.co.uk)
- France (.fr)
- Germany(.de)
- Netherlands (.nl)
- Spain (.es)
- Italy (.it)
- Turkey (.com.tr)
- India (.in)
- Saudi Arabia (.sa)
- UAE (.ae)
- Japan (.co.jp)
- Australia (.com.au)
- Singapore (.sg)
This is super helpful if you’d like to import local content like product descriptions or titles in specific languages. It can also enable you to monitor what product information displays in different countries, giving you insights into how to improve your own strategies in each market.
Tip #3 Use it anywhere
You don’t need to use this template to extract eBay products information. It’s very easy to use the IMPORTFROMWEB function wherever you like.
Here is how you can do it:
- Input your eBay urls, each one in a different cell
- Type the elements you want to extract (picking them from our list of Amazon data selectors)
| A5 : G5 | title | price | ship_price | stock | return_policy | image |
- Use the IMPORTFROMWEB function
| A7 | =IMPORTFROMWEB(A1, $A$5:$G$5) |
- Drag all the way down to the row with the last URL!
Any question?
If you feel stuck on anything at all, reach out to our team. We’d love to help you better understand our tools and templates so that you can achieve your desired results.