【Google Apps Script】DiscordのWebhookを使って行動を習慣化する

1
/**
2
 * @description Getting notification to send webhook requests.
3
 * @param {string} sheetName
4
 * @return {string[] || bool}
5
*/
6
function addRow(sheetName){
7
  let today = new Date();
8
  const hour = today.getHours();
9
  const overtimeStart = 3;
10
  const overtimeEnd = 10;
11
  if(hour >= overtimeStart && hour < overtimeEnd){
12
    return false;
13
  }
14

15
  const numColumns = 5;
16
  let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
17
  let newRow = sheet.getLastRow() + 1;
18
  let range = sheet.getRange(newRow, 1, 1, numColumns);
19
  let newValues = [
20
    [
21
      newRow - 1
22
      , today
23
      , today
24
      , ""
25
      , ""
26
    ]
27
  ];
28
  range.setValues(newValues);
29
  return newValues;
30
}

1
/**
2
 * @description Getting notification to send webhook requests.
3
 * @return {string{}}
4
*/
5
function createHabitNotification(){
6
  const bucketUrl = URL_OF_STORAGE_FOR_WEBLIP;
7
  const folderOfImage = IMAGE_FOLDER_FOR_SERVICES;
8
  let imageFolderUrl = `${bucketUrl}/${folderOfImage}`;
9

10
  let content = "歯を開いて！";
11
  let urlOfSheet = URL_OF_SHEET;
12
  iconUrl = `${imageFolderUrl}/${IMAGE_FILE_FOR_SPREADSHEET}`;
13
  let embeds = [];
14
  embeds.push({
15
    "title": "シートに記入！"
16
    , "color": 4569935
17
    , "url": urlOfSheet
18
    , "footer": {
19
      "text": "GoogleSpreadsheet"
20
      , "icon_url": iconUrl
21
    }
22
  })
23

24
  let returnEmbeds = embeds;
25
  console.log(returnEmbeds);
26

27
  const payload = {
28
    "username": "歯を開かせるあゆ"
29
    , "content": content
30
    , "embeds": returnEmbeds
31
    // , "tts": true
32

33
  console.log(payload);
34

35
  return payload;
36
}