Pull eBay Sold Prices into Google Sheets Automatically (2026)

Short answer: to pull eBay sold prices into Google Sheets automatically, paste one Apps Script into your sheet that calls the eBay Sold Listings API (GET https://api.ebaysoldlistingsapi.com/scrape) for each keyword, writes up to 240 completed sales per keyword as rows (sold price, sold date, title, condition, shipping, listing URL), and runs on a daily time-driven trigger. Setup takes about 5 minutes and the free plan includes 50 requests a month, no card.

What you get

• A Keywords tab where you list what to track, one keyword per row, with an optional eBay marketplace.
• A Sold tab rewritten on every refresh: one row per completed sale with keyword, sold price, currency, sold date, title, condition, shipping, total price, Best Offer flag, accepted offer price and the eBay listing URL.
• An eBay Sold menu in the sheet: refresh now, refresh every day, stop refreshing.
• Up to 240 sold listings per keyword per refresh, across 8 eBay marketplaces (ebay.com, ebay.co.uk, ebay.de, ebay.com.au, ebay.ca, ebay.fr, ebay.it, ebay.es), in each marketplace's own currency.

Step 1: Get an API key

Create a free account and copy your API key from the dashboard. Keys start with eb_. The free plan includes 50 requests a month, and each keyword in a refresh uses one request. Errors are never billed.

Step 2: Set up the sheet

1. Create a tab named Keywords. Put Keyword in A1 and Marketplace in B1.
2. From row 2 down, add one keyword per row in column A, for example steam deck oled or pokemon charizard ex 199/165 psa 10. Keep keywords short: brand plus model, or card name plus set and number.
3. Column B is optional. Leave it empty for ebay.com, or enter ebay.co.uk, ebay.de, ebay.com.au, ebay.ca, ebay.fr, ebay.it or ebay.es.

Step 3: Paste the Apps Script

Open Extensions, Apps Script, replace the contents of Code.gs with the script below, and save. Then open Project Settings, Script properties, and add a property named EBAY_SOLD_API_KEY with your key as the value, so the key never sits in a cell.

// eBay sold prices into Google Sheets, refreshed automatically.
// "Keywords" tab: column A = keyword, column B = optional marketplace (ebay.com, ebay.co.uk, ...).
// "Sold" tab: rewritten on every refresh, one row per completed sale.

const API_URL = "https://api.ebaysoldlistingsapi.com/scrape";
const HEADERS = ["Keyword", "Sold price", "Currency", "Sold date", "Title", "Condition",
  "Shipping", "Total price", "Best Offer", "Accepted offer", "URL"];

function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu("eBay Sold")
    .addItem("Refresh sold prices now", "refreshSoldPrices")
    .addItem("Refresh every day", "installDailyTrigger")
    .addItem("Stop automatic refresh", "removeDailyTrigger")
    .addToUi();
}

function refreshSoldPrices() {
  const ss = SpreadsheetApp.getActive();
  const input = ss.getSheetByName("Keywords");
  if (!input) throw new Error('Create a tab named "Keywords" with one keyword per row in column A.');
  if (input.getLastRow() < 2) return;

  const key = PropertiesService.getScriptProperties().getProperty("EBAY_SOLD_API_KEY");
  if (!key) throw new Error("Add EBAY_SOLD_API_KEY in Project Settings, Script properties.");

  const jobs = input.getRange(2, 1, input.getLastRow() - 1, 2).getValues()
    .map((r) => ({ keyword: String(r[0]).trim(), site: String(r[1] || "ebay.com").trim() }))
    .filter((j) => j.keyword);

  const rows = [];
  const errors = [];
  jobs.forEach((job) => {
    const data = fetchSold_(job, key);
    if (data.error) {
      errors.push(job.keyword + ": " + data.error);
      return;
    }
    data.results.forEach((r) => rows.push([
      job.keyword,
      Number(r.soldPrice) || "",
      r.soldCurrency || "",
      r.endedAt ? new Date(r.endedAt + "T00:00:00") : "",
      r.title || "",
      r.condition || "",
      Number(r.shippingPrice) || 0,
      Number(r.totalPrice) || "",
      r.bestOfferAccepted ? "Yes" : "",
      r.acceptedOfferPrice ? Number(r.acceptedOfferPrice) : "",
      r.url || "",
    ]));
  });

  // Keep the last good data if every keyword failed.
  if (!rows.length && errors.length) throw new Error(errors.join(" | "));

  const out = ss.getSheetByName("Sold") || ss.insertSheet("Sold");
  out.clearContents();
  out.getRange(1, 1, 1, HEADERS.length).setValues([HEADERS]).setFontWeight("bold");
  if (rows.length) out.getRange(2, 1, rows.length, HEADERS.length).setValues(rows);
  out.getRange(1, HEADERS.length + 2).setValue("Last refresh: " + new Date().toLocaleString());
  out.getRange(2, HEADERS.length + 2).setValue(errors.join(" | "));
}

function fetchSold_(job, key) {
  const url = API_URL + "?keyword=" + encodeURIComponent(job.keyword) +
    "&ebaySite=" + encodeURIComponent(job.site) + "&bestOfferPrice=true";
  for (let attempt = 0; attempt < 3; attempt++) {
    const res = UrlFetchApp.fetch(url, {
      headers: { Authorization: "Bearer " + key },
      muteHttpExceptions: true,
    });
    const code = res.getResponseCode();
    if (code === 200) return JSON.parse(res.getContentText());
    if (code === 429 || code >= 500) {
      const h = res.getHeaders();
      const wait = Number(h["Retry-After"] || h["retry-after"]) || 5;
      Utilities.sleep(Math.min(wait, 30) * 1000);
      continue;
    }
    let message = "HTTP " + code;
    try { message = JSON.parse(res.getContentText()).error || message; } catch (e) {}
    return { error: message };
  }
  return { error: "still failing after 3 tries, the next refresh will retry" };
}

function installDailyTrigger() {
  removeDailyTrigger();
  ScriptApp.newTrigger("refreshSoldPrices").timeBased().everyDays(1).atHour(6).create();
  SpreadsheetApp.getActive().toast("Sold prices will refresh every day around 6 AM.");
}

function removeDailyTrigger() {
  ScriptApp.getProjectTriggers()
    .filter((t) => t.getHandlerFunction() === "refreshSoldPrices")
    .forEach((t) => ScriptApp.deleteTrigger(t));
}

The same script, kept up to date, is in the public Google Sheets example alongside the Python and Node.js examples.

Step 4: Run it once, then turn on automatic refresh

1. Reload the spreadsheet. An eBay Sold menu appears next to Help.
2. Click eBay Sold, Refresh sold prices now. Google asks you to authorize the script the first time (it needs to call an external URL and edit this sheet).
3. Check the Sold tab: one row per completed sale, newest data from eBay.
4. Click eBay Sold, Refresh every day. A time-driven trigger now refreshes the Sold tab every morning around 6 AM, even when the sheet is closed.

Want a different schedule? Change everyDays(1).atHour(6) to everyHours(12) for twice a day, or everyWeeks(1).onWeekDay(ScriptApp.WeekDay.MONDAY) for weekly. If a scheduled refresh fails, Google emails you the error and the Sold tab keeps its last good data.

Step 5: Turn the rows into prices

Because every sale is a row, plain Sheets formulas give you the numbers you price from. With your keyword in A2 of any tab:

On sales closed through an accepted Best Offer, eBay shows the listing price, so Sold price is an upper bound on those rows. The Accepted offer column holds the price the buyer actually paid when it is available, and the daily refresh fills in prices that were still pending. See Best Offer prices. For a full pricing method (sample size, outliers, condition), read how to price items from eBay sold comps.

How many requests does it use?

One request per keyword per refresh, and each request returns up to 240 sold listings.

Apps Script stops a single run after 6 minutes, so for hundreds of keywords split them across sheets or use batch jobs: send up to 100 keywords in one job and import the finished CSV. See plans and pricing.

Ways to get eBay sold prices into Google Sheets, compared

More on eBay's own options: eBay official APIs compared and does the eBay Browse API return sold listings?.

Variations

• One number per cell: a custom =EBAYSOLD(A2) function that returns the median sold price directly. See eBay sold prices in Google Sheets with a custom function.
• Used or new only: add &itemCondition=used (or new) to the URL in fetchSold_.
• A date window: add &soldAfter=2026-10-01 to only keep recent sales.
• CSV instead of JSON: add &format=csv and parse with Utilities.parseCsv. See CSV export.
• Excel or a local file: export eBay sold data to a spreadsheet with a short Python script.

More blog