API de odds da Pinnacle no Google Sheets

// Extensions > Apps Script, then paste.
const PROPS = PropertiesService
  .getScriptProperties();
const BASE = PROPS.getProperty('BASE');
const KEY = PROPS.getProperty('KEY');
const SPORT_ID = 1; // 1 = soccer

function refreshOdds() {
  const url = BASE + '/kit/v1/markets' +
    '?event_type=prematch&sport_id=' +
    SPORT_ID;
  const res = UrlFetchApp.fetch(url, {
    headers: { 'x-portal-apikey': KEY },
    muteHttpExceptions: true,
  });
  if (res.getResponseCode() !== 200) {
    console.warn(res.getContentText());
    return;
  }
  const data = JSON.parse(
    res.getContentText());
  const rows = data.events.map((ev) => {
    const p = ev.periods || {};
    const ml = (p.num_0 || {})
      .money_line || {};
    return [new Date(ev.starts),
      ev.league_name, ev.home, ev.away,
      ml.home || '', ml.draw || '',
      ml.away || ''];
  });
  const sheet = SpreadsheetApp
    .getActive().getSheetByName('Odds');
  sheet.clearContents();
  sheet.appendRow(['Starts', 'League',
    'Home', 'Away', '1', 'X', '2']);
  if (rows.length) {
    sheet.getRange(2, 1, rows.length, 7)
      .setValues(rows);
  }
}

Selecione o código para copiá-lo.