Webhook とアクセストークンで外部とつなぐ

{
  "event": "hackathon.registration",
  "timestamp": "2026-01-27T10:30:00Z",
  "hackathon": {
    "numberId": 123,
    "displayId": "your-hackathon-id",
    "title": "ハッカソン名"
  },
  "participant": {
    "playerId": "user123",
    "fullName": "山田 太郎",
    "email": "user@example.com",
    "registeredAt": "2026-01-27T10:30:00Z",
    "participationType": "matching",
    "allowMatching": true
  }
}

const crypto = require("crypto")

function isValid(rawBody, timestamp, signatureHeader, secret) {
  const expected =
    "sha256=" +
    crypto.createHmac("sha256", secret).update(`${timestamp}.${rawBody}`).digest("hex")
  return (
    expected.length === signatureHeader.length &&
    crypto.timingSafeEqual(Buffer.from(expected), Buffer.from(signatureHeader))
  )
}

// 「=」などで始まる値が数式として扱われないようにする
const safe = (v) => (typeof v === "string" && /^[=+\-@]/.test(v) ? "'" + v : v)

function doPost(e) {
  const data = JSON.parse(e.postData.contents)
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("応募") // 先に「応募」シートを作っておく
  sheet.appendRow([
    data.timestamp,
    data.event,
    safe(data.hackathon.title),
    safe(data.participant.fullName),
    safe(data.participant.email),
    data.participant.participationType || "",
  ])
  return ContentService.createTextOutput("ok")
}

{
  "mcpServers": {
    "craft-stadium": {
      "command": "npx",
      "args": ["craft-stadium-mcp"],
      "env": {
        "CRAFTSTADIUM_TOKEN": "cs_pat_..."
      }
    }
  }
}