Is there a tracking API that takes a CSV or spreadsheet of tracking numbers?

import csv, os, requests

KEY = os.environ["LASTSCANNED_KEY"]
with open("shipments.csv", newline="") as f:
    rows = list(csv.DictReader(f))  # needs a tracking_number column

numbers = list(dict.fromkeys(r["tracking_number"].strip().upper() for r in rows if r["tracking_number"].strip()))
found = {}
for i in range(0, len(numbers), 35):  # 35 per request never passes the per-carrier cap
    res = requests.get("https://api.lastscanned.com/v1/track",
                       params={"numbers": ",".join(numbers[i:i + 35])},
                       headers={"Authorization": f"Bearer {KEY}"}, timeout=120)
    res.raise_for_status()
    for entry in res.json()["results"]:
        found[entry["trackingNumber"]] = entry

with open("tracked.csv", "w", newline="") as f:
    out = csv.DictWriter(f, fieldnames=[*rows[0].keys(), "carrier", "status", "last_scan_utc", "last_scan", "location", "error"])
    out.writeheader()
    for r in rows:
        e = found.get(r["tracking_number"].strip().upper(), {})
        res_ = e.get("result") or {}
        last = (res_.get("events") or [{}])[0]  # newest first
        out.writerow({**r, "carrier": res_.get("carrier"), "status": res_.get("status"),
                      "last_scan_utc": last.get("timestamp"), "last_scan": last.get("description"),
                      "location": last.get("location"), "error": (e.get("error") or {}).get("code")})

// Extensions > Apps Script. Set LASTSCANNED_KEY under Project Settings > Script Properties.
function trackColumnA() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const key = PropertiesService.getScriptProperties().getProperty("LASTSCANNED_KEY");
  const last = sheet.getLastRow();
  if (last < 2) return;
  const numbers = sheet.getRange(2, 1, last - 1, 1).getValues().map(([n]) => String(n).trim().toUpperCase());
  const found = {};
  const unique = [...new Set(numbers.filter(Boolean))];
  for (let i = 0; i < unique.length; i += 35) {
    const res = UrlFetchApp.fetch("https://api.lastscanned.com/v1/track?numbers=" + encodeURIComponent(unique.slice(i, i + 35).join(",")),
      { headers: { Authorization: "Bearer " + key } });
    for (const e of JSON.parse(res.getContentText()).results) found[e.trackingNumber] = e;
  }
  const out = numbers.map((n) => {
    const e = found[n] || {};
    const r = e.result || {};
    const scan = (r.events || [])[0] || {};
    return [r.carrier || "", r.status || (e.error ? e.error.code : ""), scan.timestamp || "", scan.description || ""];
  });
  sheet.getRange(2, 2, out.length, 4).setValues(out);
}