初心者でも簡単！GAS×Chat GPTで業務効率化した事例を紹介します！

function notification_everyweek() {
 const membersSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("メンバーリスト");
 const dutySheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("担当表");


 const members = getSlackIds(membersSheet);
 const today = Utilities.formatDate(new Date(), "JST", "yyyy-MM-dd");


 const dutyRange = dutySheet.getDataRange();
 const dutyValues = dutyRange.getValues();


 for (let i = 1; i < dutyValues.length; i++) {
   const row = dutyValues[i];
   const date = Utilities.formatDate(row[0], "JST", "yyyy-MM-dd");
   const person = row[1];


   if (date === today && members[person]) {
     const message = `<@${members[person]}> さん、${date}の週の掃除担当です。よろしくお願いいたします。`;
     postToSlack(message);
   }
 }
}


function getSlackIds(sheet) {
 const range = sheet.getDataRange();
 const values = range.getValues();
 let members = {};


 values.forEach(row => {
   const name = row[0];
   const slackId = row[1];
   members[name] = slackId;
 });


 return members;
}


function postToSlack(message) {
 const SLACK_WEBHOOK_URL = 'https://hooks.slack.com/services/(省略)';
 const payload = JSON.stringify({text: message});
 const options = {
   method: 'post',
   contentType: 'application/json',
   payload: payload
 };


 UrlFetchApp.fetch(SLACK_WEBHOOK_URL, options);
}


//シフトデータを取得
function getShifts() {
 var today = new Date();
 var firstDayOfThisMonth = new Date(today.getFullYear(), today.getMonth(), 1);
 var lastDayOfThisMonth = new Date(today.getFullYear(), today.getMonth() + 1, 0);


 var from = formatDate(firstDayOfThisMonth);
 var to = formatDate(lastDayOfThisMonth);




 var apiUrl = 'https://opluswork.com/api/e/v1/(省略)/shifts?from=' + from + '&to=' + to;
 var apiKey = ''; // 実際のAPIキーに置き換えてください
 var options = {
 'method' : 'get',
 'headers': {
   'Authorization': 'Bearer ' + apiKey
 },
 'muteHttpExceptions': true
};


 var response = UrlFetchApp.fetch(apiUrl, options);
 var data = JSON.parse(response.getContentText());
 Logger.log(data);
 var employeeMap = getEmployeeData();
 writeToSpreadsheet(data.shifts, employeeMap);


 }

const endpoint2 = "https://api.twitter.com/2/tweets";


//認証を確認し、ツイート
function check_and_maketweet() {
 const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("投稿内容");
 const rows = sheet.getDataRange().getValues();
 // ヘッダ行をスキップし、各行をチェック
 for (let i = 1; i < rows.length; i++) {
   let row = rows[i];
   let [no, content, postDate, approved, status] = row;
   // 承認されており、まだ投稿されていないものを検出
   if (approved === true && status !== 'posted') {
     let today = new Date();
     let postDateObj = new Date(postDate);
     if (postDateObj <= today) {
       postTwitter(content); // Twitterに投稿
       sheet.getRange(i + 1, 5).setValue('posted'); // ステータスを更新
       return;//一度に２ツイートしないように
     }
   }
 }
}


//ツイートの処理
function postTwitter(twitterText) {
 let service = getService(); // OAuthサービスのインスタンス取得


 if (service.hasAccess()) {  
   let message = {
     text: twitterText
   };


   let response = UrlFetchApp.fetch(endpoint2, {
     method: "post",
     headers: {
       Authorization: 'Bearer ' + service.getAccessToken()
     },
     muteHttpExceptions: true,
     payload: JSON.stringify(message),
     contentType: "application/json"
   });


   let result = JSON.parse(response.getContentText());
   Logger.log(JSON.stringify(result, null, 2));
 } else {
   Logger.log("Not Authorized");
   return null;
 }
}