【LINE】グループID(Group ID)の取得方法｜Messaging APIで 特定のグループにメッセージを送るために必要

const SPREADSHEET_ID = 'スプシID';
const SHEET_NAME = 'シート1'; //シート名

function doPost(e) {
  try {
    const json = JSON.parse(e.postData.contents);
    const ss = SpreadsheetApp.openById(SPREADSHEET_ID);
    const sheet = ss.getSheetByName(SHEET_NAME);

    if (!sheet) {
      throw new Error(`シート "${SHEET_NAME}" が見つかりません。`);
    }

    if (!json.events || json.events.length === 0) {
      sheet.appendRow([new Date(), "No events"]);
      return ContentService
        .createTextOutput(JSON.stringify({ status: 'no events' }))
        .setMimeType(ContentService.MimeType.JSON);
    }

    json.events.forEach(event => {
      const type = event.type || "";
      const sourceType = event.source?.type || "";
      const groupId = event.source?.groupId || "";
      const userId = event.source?.userId || "";
      const messageType = event.message?.type || "";
      const messageText = event.message?.text || "";
      const timestamp = new Date(event.timestamp);

      sheet.appendRow([
        timestamp,
        sourceType,
        groupId,
        userId,
        messageType,
        messageText
      ]);
    });

    return ContentService
      .createTextOutput(JSON.stringify({ status: 'ok' }))
      .setMimeType(ContentService.MimeType.JSON);

  } catch (err) {
    const sheet = (() => {
      try { return SpreadsheetApp.openById(SPREADSHEET_ID).getSheetByName(SHEET_NAME); }
      catch (_) { return null; }
    })();
    if (sheet) {
      sheet.appendRow([new Date(), "Error", err.message]);
    }
    return ContentService
      .createTextOutput(JSON.stringify({ status: 'error', message: err.message }))
      .setMimeType(ContentService.MimeType.JSON);
  }
}