Use the API from Sheets and no-code tools

// Store the key once: Project Settings → Script Properties → PTCG_API_KEY.
// Never put it in a cell — anyone with view access on the sheet can read it.
const BASE = "https://api.pokemontcgapi.com";

function key_() {
  return PropertiesService.getScriptProperties().getProperty("PTCG_API_KEY");
}

function fetch_(path) {
  const cache = CacheService.getScriptCache();
  const hit = cache.get(path);
  if (hit) return JSON.parse(hit);

  const res = UrlFetchApp.fetch(BASE + path, {
    headers: { "X-Api-Key": key_() },
    muteHttpExceptions: true,
  });
  const body = JSON.parse(res.getContentText());
  if (res.getResponseCode() !== 200) {
    throw new Error(body.error.code + ": " + body.error.message);
  }

  // Six hours: card data changes when a set releases, prices once a day.
  cache.put(path, JSON.stringify(body), 21600);
  return body;
}

/**
 * Card name for one or many ids.
 * @param {string|Array} ids A card id, or a range of them.
 * @customfunction
 */
function PTCG_NAME(ids) {
  return lookup_(ids, "name");
}

/**
 * Current index price in EUR.
 * @param {string|Array} ids A card id, or a range of them.
 * @customfunction
 */
function PTCG_PRICE(ids) {
  const flat = flatten_(ids);
  return flat.map(function (id) {
    if (!id) return "";
    const body = fetch_("/v1/cards/" + id + "/prices?currency=EUR");
    const point = body.data.filter(function (p) { return p.variant === "INDEX"; })[0];
    return point ? point.price : "";
  }).map(function (v) { return [v]; });
}

function flatten_(ids) {
  return (Array.isArray(ids) ? ids : [[ids]])
    .reduce(function (acc, row) { return acc.concat(row); }, [])
    .map(String);
}

// One request per 100 ids instead of one per row. This is the whole trick.
function lookup_(ids, field) {
  const flat = flatten_(ids);
  const found = {};

  for (var i = 0; i < flat.length; i += 100) {
    const slice = flat.slice(i, i + 100).filter(String);
    if (slice.length === 0) continue;
    const body = fetch_(
      "/v1/cards/batch?select=id,name,set_name,rarity&ids=" + slice.join(","),
    );
    body.data.forEach(function (card) { found[card.id] = card; });
  }

  return flat.map(function (id) {
    return [found[id] ? found[id][field] : ""];
  });
}