하루 3시간 되찾기
AI 자동화 실전 플레이북 15

// 슬랙 웹훅 URL (여기에 입력)
const SLACK_URL = 'https://hooks.slack.com/services/...';

function sendDailyReport() {
  const sheet = SpreadsheetApp
    .getActiveSpreadsheet()
    .getSheetByName('매출');
  const data = sheet.getDataRange().getValues();

  // 어제 날짜 구하기
  const yesterday = new Date();
  yesterday.setDate(yesterday.getDate() - 1);
  const target = Utilities.formatDate(
    yesterday, 'Asia/Seoul', 'yyyy-MM-dd');

  let todaySales = 0, prevSales = 0;
  for (let i = 1; i < data.length; i++) {
    const d = Utilities.formatDate(
      new Date(data[i][0]), 'Asia/Seoul', 'yyyy-MM-dd');
    if (d === target) {
      todaySales = data[i][1];
      if (i > 1) prevSales = data[i-1][1];
      break;
    }
  }

  const rate = prevSales > 0
    ? (((todaySales - prevSales) / prevSales) * 100).toFixed(1)
    : 'N/A';
  const sign = rate > 0 ? '+' : '';
  const msg = `📊 어제 매출: ${todaySales.toLocaleString()}원 | 전일 대비 ${sign}${rate}%`;

  UrlFetchApp.fetch(SLACK_URL, {
    method: 'POST',
    contentType: 'application/json',
    payload: JSON.stringify({ text: msg })
  });
}