GASで今日のタスクをslack通知する方法【files.upload APIを使わずグラフ投稿】

function main(){
  sendTodayTasksToSlack();
  postChartsWithPreviewToSlack();
}

function sendTodayTasksToSlack() {
  const slackWebhookUrl = 'https://hooks.slack.com/services/xxxxxxxxx/xxxxxxxxxxx/xxxxxxxxxxxxxxxxxxxxx'; // 御社のWebhook URLを入力

  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const taskSheet = ss.getSheetByName('データ整形');
  const nameSheet = ss.getSheetByName('最初に埋める');

  const taskData = taskSheet.getDataRange().getValues();
  const nameData = nameSheet.getDataRange().getValues();

  postToSlack(slackWebhookUrl, '今日期限のタスクは以下の通りです。');

  for (let i = 4; i < taskData.length; i++) {
    const row = taskData[i];
    const taskId = row[29]; // AD列

    if (!taskId) continue;

    const genre = row[32];      // AG列
    const taskName = row[30];   // AE列
    const status = row[31];     // AF列
    const tantouName = row[33]; // AH列
    const dcName = row[34];     // AI列

    const startDate = convertToDateString(row[35]); // AJ列
    const deadline = convertToDateString(row[36]);  // AK列

    const priority = row[38];   // AM列
    const notes = row[39];      // AN列

    const tantouMention = getSlackMentionName(tantouName, nameData);
    const dcMention = getSlackMentionName(dcName, nameData);

    const message = `
担当者：<@${tantouMention}>
ダブルチェック：<@${dcMention}>

\`\`\`
タスクID：${taskId}
ジャンル：${genre}
タスク名：${taskName}
ステータス：${status}
担当者：${tantouName}
ダブルチェック担当者：${dcName}
着手日：${startDate}
期限日：${deadline}
重要度：${priority}

備考
${notes}
\`\`\`
`;
    postToSlack(slackWebhookUrl, message.trim());
  }
}

function getSlackMentionName(personName, nameData) {
  for (let i = 0; i < nameData.length; i++) {
    if (nameData[i][7] === personName) {
      return nameData[i][8] || personName;
    }
  }
  return personName;
}

function convertToDateString(cellValue) {
  if (cellValue instanceof Date) {
    return Utilities.formatDate(cellValue, Session.getScriptTimeZone(), 'yyyy/MM/dd');
  } else if (typeof cellValue === 'number') {
    const jsDate = new Date(1899, 11, 30 + cellValue); // 注意: ローカルタイムでOK
    return Utilities.formatDate(jsDate, Session.getScriptTimeZone(), 'yyyy/MM/dd');
  } else {
    return cellValue;
  }
}

function postToSlack(webhookUrl, message) {
  const payload = JSON.stringify({ text: message });

  UrlFetchApp.fetch(webhookUrl, {
    method: 'post',
    contentType: 'application/json',
    payload: payload,
  });
}





const IMGUR_CLIENT_ID = 'xxxxxxxxxxxxxxxx';  // Imgurから取得したClient-ID
const SLACK_WEBHOOK_URL = 'https://hooks.slack.com/services/xxxxxxxxx/xxxxxxxxxxx/xxxxxxxxxxxxxxxxxxxxx'; // 御社のWebhook URLを入力

function postChartsWithPreviewToSlack() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName('graph');
  const charts = sheet.getCharts();

  charts.forEach((chart, index) => {
    const blob = chart.getAs('image/png').setName(`chart_${index + 1}.png`);

    // Imgurに画像アップロード
    const imgurUrl = uploadImageToImgur(blob);
    if (!imgurUrl) {
      Logger.log(`グラフ${index + 1}のImgurアップロードに失敗しました`);
      return;
    }

    // Slackに送信（画像URL付き）
    const slackMessage = {
        text: imgurUrl  

    };

    UrlFetchApp.fetch(SLACK_WEBHOOK_URL, {
      method: 'post',
      contentType: 'application/json',
      payload: JSON.stringify(slackMessage),
    });
  });
}

function uploadImageToImgur(blob) {
  try {
    const encoded = Utilities.base64Encode(blob.getBytes());
    const options = {
      method: 'post',
      headers: {
        Authorization: 'Client-ID ' + IMGUR_CLIENT_ID,
      },
      payload: {
        image: encoded,
        type: 'base64',
      },
      muteHttpExceptions: true,
    };

    const response = UrlFetchApp.fetch('https://api.imgur.com/3/image', options);
    const result = JSON.parse(response.getContentText());

    if (result.success) {
      return result.data.link; 
    } else {
      Logger.log('Imgurエラー: ' + JSON.stringify(result));
      return null;
    }
  } catch (e) {
    Logger.log('Imgurアップロード失敗: ' + e.message);
    return null;
  }
}