How to connect Google Sheets to TWICE Commerce

const BASE_URL = 'https://server.twicecommerce.com/internal/reporting/';
const CURRENCY = 'EUR';
const FROM_DATE = '2025-01-01';

function refreshTwiceLedgers() {
  const to = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), 'yyyy-MM-dd');
  loadLedger_('revenue', 'Revenue', to);
  loadLedger_('payments', 'Payments', to);
}

function loadLedger_(ledger, sheetName, to) {
  const key = PropertiesService.getScriptProperties().getProperty('TWICE_API_KEY');
  const url = BASE_URL + ledger + '/export?from=' + FROM_DATE + '&to=' + to + '&currency=' + CURRENCY;
  const response = UrlFetchApp.fetch(url, {
    headers: { 'X-API-KEY': key },
    muteHttpExceptions: true,
  });
  if (response.getResponseCode() !== 200) {
    throw new Error(ledger + ' export failed with ' + response.getResponseCode() + ': ' +
      response.getContentText().slice(0, 200));
  }

  const text = response.getContentText('UTF-8').replace(/^/, '');
  const parsed = Utilities.parseCsv(text, ';');
  const width = parsed[0].length;
  // A truncated export ends in a one-cell notice row. Keep only full rows.
  const rows = parsed.filter((row) => row.length === width);
  if (rows.length < parsed.length) {
    throw new Error(ledger + ' export was truncated. Move FROM_DATE later or split the period.');
  }

  // Write numbers as numbers, so the sheet's locale cannot misread 202.42.
  // Codes with a leading zero stay text.
  const values = rows.map((row, i) =>
    i === 0 ? row : row.map((cell) => (/^-?(0|[1-9]\d*)(\.\d+)?$/.test(cell) ? Number(cell) : cell)),
  );

  const spreadsheet = SpreadsheetApp.getActive();
  const sheet = spreadsheet.getSheetByName(sheetName) || spreadsheet.insertSheet(sheetName);
  sheet.clearContents();
  sheet.getRange(1, 1, values.length, width).setValues(values);
}