How do I get UFC data into Google Sheets?

=MMA_EVENTS("ufc", "upcoming")                       upcoming UFC cards, soonest first
=MMA_EVENTS("", "completed", 50)                     the last 50 cards of every promotion
=MMA_CARD("ufc-dwcs-93-2026-09-22")                  a full card, headliner first, with results
=MMA_CARD(C2)                                        the card of the event slug in cell C2
=MMA_FIGHTER("jon-jones")                            bio, records and career stats
=MMA_FIGHTER_HISTORY("jon-jones")                    every bout, every promotion, newest first
=MMA_RANKINGS("ufc", "lightweight")                  today's board ("C" = champion)
=MMA_RANKINGS("ufc", "bantamweight", "2019-03-01")   the board as it stood on that day
=MMA_FIGHT_STATS(84176)                              both corners, whole fight
=MMA_FIGHT_STATS(84176, 2)                           round 2 only
=MMA_ODDS("ufc-fight-night-2026-08-29")              consensus line per bout, information only
=MMA_STAT_LEADERS("knockouts", "ufc", 10)            a Record Book leaderboard

# The request behind =MMA_CARD("ufc-dwcs-93-2026-09-22")
curl "https://api.ufcalendar.com/v1/events/ufc-dwcs-93-2026-09-22" \
  -H "Authorization: Bearer $UFCAL_API_KEY"

# pip install ufcalendar gspread
# Push the next UFC card into a sheet on a schedule (cron, GitHub Actions...).
# gspread needs a Google service account with the sheet shared to it.
import gspread
from ufcalendar import FightAPI

api = FightAPI()  # reads UFCAL_API_KEY from the environment
ws = gspread.service_account().open("MMA data").sheet1

nxt = next(api.events("ufc", limit=1))
rows = [["Bout", "Weight class", "Section", "Winner", "Method", "Round", "Time"]]
for f in api.event(nxt["slug"])["card"]:
    if f["status"] == "cancelled":
        continue
    r = f["result"] or {}
    a, b = f["fighter_a"], f["fighter_b"]
    winner = next((c["name"] for c in (a, b) if c["id"] == r.get("winner_fighter_id")), "")
    rows.append([f"{a['name']} vs {b['name']}", f["weight_class"], f["card_section"],
                 winner, r.get("method"), r.get("round"), r.get("time")])

ws.clear()
ws.update(rows, "A1")
print(f"{nxt['title']}: {len(rows) - 1} bouts")

// Google Apps Script (JavaScript): Extensions > Apps Script, paste, save.
// Project Settings > Script properties: add UFCAL_API_KEY = your key.
// Then in any cell: =NEXT_CARD("ufc")

/**
 * The next card of a promotion, one row per bout.
 * @param {string} org ufc, pfl, oktagon, bkfc or rizin
 * @customfunction
 */
function NEXT_CARD(org) {
  const key = PropertiesService.getScriptProperties().getProperty("UFCAL_API_KEY");
  const get = (path) => JSON.parse(UrlFetchApp.fetch("https://api.ufcalendar.com/v1" + path, {
    headers: { Authorization: "Bearer " + key },
  }).getContentText());

  const next = get(`/events?org=${org || "ufc"}&limit=1`).data[0];
  if (!next) return "No upcoming card";
  const rows = [["Bout", "Weight class", "Section", "Winner", "Method"]];
  for (const f of get(`/events/${next.slug}`).data.card) {
    if (f.status === "cancelled") continue;
    const r = f.result || {};
    const winner = [f.fighter_a, f.fighter_b].find((c) => c.id === r.winner_fighter_id);
    rows.push([`${f.fighter_a.name} vs ${f.fighter_b.name}`, f.weight_class || "",
      f.card_section || "", winner ? winner.name : "", r.method || ""]);
  }
  return rows;
}

{
  "data": {
    "id": 2556,
    "slug": "ufc-dwcs-93-2026-09-22",
    "title": "Dana White's Contender Series 93",
    "org": "ufc",
    "sport": "mma",
    "starts_at": "2026-09-22T23:00:00.000Z",
    "tz": "America/Los_Angeles",
    "status": "completed",
    "venue": { "name": "Meta Apex", "city": "Las Vegas", "country_code": "US", … },
    "card": [
      {
        "id": 84176,
        "ordering": 1,
        "card_section": "main",
        "weight_class": "Middleweight",
        "is_title": false,
        "is_main": true,
        "scheduled_rounds": 3,
        "status": "completed",
        "fighter_a": { "id": 25314, "slug": "norbert-novenyi-jr", "name": "Norbert Novenyi Jr.", … },
        "fighter_b": { "id": 33707, "slug": "theo-haig", "name": "Theo Haig", … },
        "result": {
          "winner_fighter_id": 25314,
          "method": "Decision - Unanimous",
          "method_normalized": "decision_unanimous",
          "round": 3,
          "time": "05:00",
          "time_seconds": 300,
          …
        },
        "referee": "Herb Dean",
        …
      },
      …
    ],
    …
  },
  "meta": {}
}