Din data, dina verktyg

const GOFFY_API = 'https://backend.goffy.app';
const SHEET_NAME = 'Holes';
const MAX_ROUNDS = 20; // Newest first. Each round is one more request, so raise it deliberately.

function importGoffyHoles() {
  const book = SpreadsheetApp.getActiveSpreadsheet();
  if (!book) throw new Error('No spreadsheet attached. Create the script from the sheet: Extensions -> Apps Script.');
  const token = PropertiesService.getScriptProperties().getProperty('GOFFY_TOKEN');
  if (!token) throw new Error('Add GOFFY_TOKEN under Project Settings -> Script properties.');

  const rounds = fetchGoffy('/api/me/rounds', token).slice(0, MAX_ROUNDS);
  const rows = [];
  const shotTypes = {};

  rounds.forEach(function (summary) {
    const round = fetchGoffy('/api/me/rounds/' + summary.roundId, token);
    const names = {};
    round.players.forEach(function (player) { names[player.playerId] = player.name || player.playerId; });

    round.holeEntries.forEach(function (entry) {
      const events = round.holeEvents.filter(function (event) {
        return event.playerId === entry.playerId && event.holeNumber === entry.hole;
      });
      events.forEach(function (event) { shotTypes[event.eventType] = true; });
      rows.push({
        playDate: summary.playDate,
        courseName: summary.courseName,
        player: names[entry.playerId] || entry.playerId,
        hole: entry.hole,
        par: entry.par,
        strokeIndex: entry.holeIndex,
        // Blank on a hole Goffy has not measured itself. It is never filled in from an
        // imported scorecard, so an empty cell means unknown, not "no length".
        lengthMeters: entry.lengthMeters,
        grossStrokes: entry.grossStroke,
        handicapStrokes: entry.handicapStroke,
        netStrokes: entry.netStroke,
        pickup: entry.pickup,
        greenInRegulation: entry.greenInRegulation,
        events: events,
      });
    });
  });

  const fixed = ['playDate', 'courseName', 'player', 'hole', 'par', 'strokeIndex', 'lengthMeters',
    'grossStrokes', 'handicapStrokes', 'netStrokes', 'pickup', 'greenInRegulation'];
  const shotColumns = Object.keys(shotTypes).sort();
  const columns = fixed.concat(shotColumns);

  const sheet = book.getSheetByName(SHEET_NAME) || book.insertSheet(SHEET_NAME);
  sheet.clear();
  sheet.getRange(1, 1, 1, columns.length).setValues([columns]).setFontWeight('bold');
  if (rows.length) {
    const values = rows.map(function (row) {
      return columns.map(function (column) {
        if (shotColumns.indexOf(column) === -1) return row[column] == null ? '' : row[column];
        const hit = row.events.filter(function (event) { return event.eventType === column; })[0];
        if (!hit) return '';
        // An event with no value happened at all: fairway hit, ball in water.
        return hit.eventValue == null ? 'yes' : hit.eventValue;
      });
    });
    sheet.getRange(2, 1, values.length, columns.length).setValues(values);
  }
  sheet.setFrozenRows(1);
  sheet.autoResizeColumns(1, columns.length);
  book.setActiveSheet(sheet);
  book.toast(rows.length + ' hole rows from ' + rounds.length + ' rounds', 'Goffy');
  Logger.log('Wrote %s hole rows from %s rounds', rows.length, rounds.length);
}

function fetchGoffy(path, token) {
  const response = UrlFetchApp.fetch(GOFFY_API + path, {
    headers: { Authorization: 'Bearer ' + token },
    muteHttpExceptions: true,
  });
  if (response.getResponseCode() !== 200) {
    throw new Error('Goffy answered ' + response.getResponseCode() + ' for ' + path + ': ' + response.getContentText().slice(0, 300));
  }
  return JSON.parse(response.getContentText());
}

let
    Token  = "<token>",
    Base   = "https://backend.goffy.app",
    Get    = (path as text) =>
               Json.Document(Web.Contents(Base, [
                   RelativePath = path,
                   Headers      = [Authorization = "Bearer " & Token]
               ])),

    Rounds = Table.FirstN(Table.FromRecords(Get("api/me/rounds")), 20),
    Detail = Table.AddColumn(Rounds, "detail", each Get("api/me/rounds/" & [roundId])),
    Lines  = Table.ExpandListColumn(
               Table.AddColumn(Detail, "entry", each [detail][holeEntries]), "entry"),
    Holes  = Table.ExpandRecordColumn(Lines, "entry",
               {"playerId", "hole", "par", "holeIndex", "lengthMeters",
                "grossStroke", "handicapStroke", "netStroke", "pickup", "greenInRegulation"})
in
    Holes