【GAS】Retrieving Data from Google Analytics GA4

function runReport() {
  const propertyId = '<GA4 Account ID>';

  try {
    // Set up metrics (e.g., activeUsers and eventCount)
    const metric = {
      name: 'activeUsers'
    };

    const metric1 = {
      name: 'eventCount'
    };

    // Set up dimensions (e.g., date and eventName)
    const dimension = {
      name: 'date'
    };

    const dimension1 = {
      name: 'eventName'
    };

    // Set up date range
    const dateRange = {
      startDate: '7daysAgo',
      endDate: 'yesterday'
    };

    const request = {
      entity: {
        propertyId: propertyId
      },
      dimensions: [dimension, dimension1],
      metrics: [metric, metric1],
      dateRanges: [dateRange]
    };

    const response = Analytics.Data.ga.get(request);

    if (!response.rows) {
      Logger.log('No rows returned.');
      return;
    }

    const headers = [...response.columnHeaders.map(header => header.name)];
    const rows = [headers, ...response.rows];
    return rows;
  } catch (e) {
    // TODO (Developer) - Handle exception
    Logger.log('Failed with error: %s', e.error);
  }
}

function getDate() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sh = ss.getSheetByName("Sheet1");
  const rows = runReport();
  sh.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
}