append-values-to-spreadsheet.ts

import { google } from "googleapis";

async function appendValuesToSpreadsheet() {
  const authClient = new google.auth.GoogleAuth({
    keyFilename: "credential.json",
    scopes: ["https://www.googleapis.com/auth/spreadsheets"],
  });

  const sheetsClient = google.sheets({
    version: "v4",
    auth: authClient,
  });

  const spreadsheetId = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX";
  const range = "シート1!A1";
  const values = [
    [
      new Date().toLocaleString("ja-JP", { timeZone: "Asia/Tokyo" }),
      "山田太郎",
      "タイトルです",
      "本文です",
    ],
  ];

  const response = await sheetsClient.spreadsheets.values.append({
    spreadsheetId,
    range,
    valueInputOption: "RAW",
    insertDataOption: "INSERT_ROWS",
    requestBody: {
      values,
    },
  });
  if (response.status !== 200) {
    console.error(response);
    throw new Error("Failed to append values to spreadsheet");
  }
}