Google Sheets 當後端？Discord Bot 的輕量資料層

npm install googleapis

import { google } from "googleapis";
import fs from "fs";
 
// 「./key/」裡的檔名要改成你實際下載的 JSON 檔名
const keys = JSON.parse(
  fs.readFileSync("./key/bot-service-account.json", "utf-8")
);
 
const auth = new google.auth.GoogleAuth({
  credentials: {
    client_email: keys.client_email,
    private_key: keys.private_key,
  },
  scopes: ["https://www.googleapis.com/auth/spreadsheets"],
});
 
// 建立 Sheets API 客戶端（整個應用程式共用這一個）
export const sheets = google.sheets({ version: "v4", auth });

BOT_TOKEN=...
GUILD_ID=...
SPREADSHEET_ID=你的試算表ID

import { google } from "googleapis";
import fs from "fs";
 
// 「./key/」裡的檔名要改成你實際下載的 JSON 檔名
const keys = JSON.parse(
  fs.readFileSync("./key/bot-service-account.json", "utf-8")
);
 
const auth = new google.auth.GoogleAuth({
  credentials: {
    client_email: keys.client_email,
    private_key: keys.private_key,
  },
  scopes: ["https://www.googleapis.com/auth/spreadsheets"],
});
 
export const sheets = google.sheets({ version: "v4", auth });
 
// 查詢使用者上次簽到日期（回傳日期字串，或 null 表示從未簽到）
export async function getLastCheckIn(userId) {
  const response = await sheets.spreadsheets.values.get({
    spreadsheetId: process.env.SPREADSHEET_ID,
    range: "簽到記錄!A:B",
  });
  const rows = response.data.values ?? [];
  const found = rows.find((row) => row[0] === userId);
  return found ? found[1] : null;
}
 
// 更新或新增簽到記錄
export async function setCheckIn(userId, dateStr) {
  const response = await sheets.spreadsheets.values.get({
    spreadsheetId: process.env.SPREADSHEET_ID,
    range: "簽到記錄!A:B",
  });
  const rows = response.data.values ?? [];
  const rowIndex = rows.findIndex((row) => row[0] === userId);
 
  if (rowIndex !== -1) {
    await sheets.spreadsheets.values.update({
      spreadsheetId: process.env.SPREADSHEET_ID,
      range: `簽到記錄!A${rowIndex + 1}:B${rowIndex + 1}`,
      valueInputOption: "USER_ENTERED",
      resource: { values: [[userId, dateStr]] },
    });
  } else {
    await sheets.spreadsheets.values.append({
      spreadsheetId: process.env.SPREADSHEET_ID,
      range: "簽到記錄!A:B",
      valueInputOption: "USER_ENTERED",
      resource: { values: [[userId, dateStr]] },
    });
  }
}

import dotenv from "dotenv";
import { Client, GatewayIntentBits } from "discord.js";
import { getLastCheckIn, setCheckIn } from "./googleSheets.js";
 
dotenv.config();
 
const client = new Client({
  intents: [
    GatewayIntentBits.Guilds,
    GatewayIntentBits.GuildMembers,
  ],
});
 
client.once("ready", async () => {
  console.log(`✅ Bot 已上線：${client.user.tag}`);
 
  const guild = await client.guilds.fetch(process.env.GUILD_ID);
  await guild.commands.set([
    { name: "ping", description: "測試 Bot 是否正常運作" },
    { name: "daily", description: "每日簽到" },
  ]);
  console.log("📝 指令已更新！");
});
 
client.on("interactionCreate", async (interaction) => {
  if (!interaction.isChatInputCommand()) return;
 
  if (interaction.commandName === "ping") {
    await interaction.reply("🏓 Pong！Bot 正常運作！");
  }
 
  if (interaction.commandName === "daily") {
    const userId = interaction.user.id;
    const today = new Date().toLocaleDateString("zh-TW", {
      timeZone: "Asia/Taipei",
    });
 
    const lastDate = await getLastCheckIn(userId);
    if (lastDate === today) {
      return interaction.reply({ content: "今天已經簽到過了！", flags: 64 });
    }
 
    await setCheckIn(userId, today);
    await interaction.reply(`✅ 簽到成功！今日日期：${today}`);
  }
});
 
client.login(process.env.BOT_TOKEN);