毎日出社できるオフィスがない弊社が、社内コミュニケーションを活性化させるための施策をGASでサクッと作ってみた

const main = () => {
  const targetMembers = getTargetMembers()
  const mustMembers = targetMembers.filter(member => {
    return ['正社員', '役員'].includes(member[header.indexOf('雇用形態')])
  }).map(members => members[header.indexOf('名前')])

  const wantMembers = targetMembers.filter(member => {
    return !['正社員', '役員'].includes(member[header.indexOf('雇用形態')])
  }).map(members => members[header.indexOf('名前')])

  // 正社員で3人ずつグルーピングする
  const mustSliced = sliceByNumber(mustMembers, 3, 3)
  const shuffledWants = shuffle(wantMembers)

  // 正社員グループにwantメンバーを一人ずつ入れていく
  mustSliced.reverse().forEach((a, i) => {
    if(shuffledWants.pop()) {
      a.push(shuffledWants.pop())
    }
  })

  const needInfo = generateNeedInfo(mustSliced)
  const messageBlock = generateMessageBlock(needInfo)

  notificationToSlack(messageBlock, GENERAL_ACTIVE)

  return true
}

// 毎週月曜日の夜中に、10:00にトリガー設定する
const setTrigger = () => {
  const time = new Date()
  time.setHours(10)
  time.setMinutes(00)
  ScriptApp.newTrigger('main').timeBased().at(time).create()
}

const sliceByNumber = (array, number, minimum) => {
  const shuffled = shuffle(array)
  const length = Math.ceil(shuffled.length / number)
  const slicedArr = new Array(length).fill().map((_, i) =>
    shuffled.slice(i * number, (i + 1) * number)
  )

  const lastElem = slicedArr[slicedArr.length - 1]
  if(lastElem.length < minimum) {
    for(let i=0; i<lastElem.length; i++) {
      slicedArr[i].push(lastElem[i])
    }
    slicedArr.pop()
  }

  return slicedArr
}

const shuffle = array => {
  let currentIndex = array.length, randomIndex;

  while (currentIndex != 0) {
    randomIndex = Math.floor(Math.random() * currentIndex)
    currentIndex--

    [array[currentIndex], array[randomIndex]] = [array[randomIndex], array[currentIndex]]
  }

  return array
}

const getMeetUrl = () => {
  const calendarId = 'primary'
  const dt = new Date()
  const date = dt.getFullYear() + '-' + (dt.getMonth() + 1) + '-' + dt.getDate()
  const requestId = Math.random().toString(32).substring(2)
  const response = Calendar.Events.insert({
    summary: "breakingTime",
    singleEvents: true,
    allDayEvent: true,
    start: { date },
    end: { date },
    conferenceData: {
      createRequest: {
        requestId,
        conferenceSolutionKey: {
          type: "hangoutsMeet"
        }
      }
    }
  },calendarId, { conferenceDataVersion: 1 })

  Calendar.Events.remove(calendarId, response.id)

  if (response.conferenceData.createRequest.status.statusCode === "success") {
    const meetUrl = response.conferenceData.entryPoints[0].uri

    return meetUrl
  }

  return ''
}

const getTalkTheme = () => {
  return WADAI[Math.floor(Math.random() * (WADAI.length-1))]
}

const getTargetMembers = () => {
  return targetData.filter(data => data[header.indexOf('朝会参加')] === '◯')
}

const generateNeedInfo = arr => {
  return arr.map((names, index) => {
    return {
      members: names.map(name => `${name}さん`),
      eventLink: getMeetUrl() || DUMMY_LINKS[index] || 'https://meet.google.com/qsh-vfqu-ckb',
      talkTheme: getTalkTheme()
    }
  })
}

const generateMessageBlock = arr => {
  let blocks = [
    {
      "type": "section",
      "text": {
        "type": "mrkdwn",
        "text": "【:sparkles: Breaking Time :sparkles: ※11:00になりましたら、各リンクへご入室ください】\n・<https://note.com/overflow_inc/n/n812979ec5ef2|Breaking Time>とは\n・参加者の変更などは<https://docs.google.com/spreadsheets/d/hogehoge|こちら>から:woman-tipping-hand: \n\n雑談タイムで、10分間、社内メンバーと交流しましょう！\nトークテーマは、参考程度に！\nまた、参加者が2人以下の場合は、別のチームに飛び入り参加してください :+1: "
      }
    },
    {
      "type": "divider"
    }
  ]

  arr.forEach((a, index) => {
    blocks.push({
      "type": "section",
      "text": {
        "type": "mrkdwn",
        "text": `*グループ${ALPHABETS[index]}*`
      }
    })
    blocks.push({
      "type": "section",
      "text": {
        "type": "mrkdwn",
        "text": `:people_holding_hands: メンバー： ${a.members.join(", ")}\n\n:speech_balloon: トークテーマ：「${a.talkTheme}」\n\n:speech_balloon: RoomLink：<${a.eventLink}|こちらから入室>`
      }
    })
    blocks.push({
      "type": "divider"
    })
  })

  blocks.push({
    "type": "section",
    "text": {
      "type": "plain_text",
      "text": "今週も頑張っていきましょうー！"
    }
  })

  return blocks
}

const notificationToSlack = (messageBlock, room) => {
  const postUrl = `${自分で設定したSlackWebhookURL}`
  const roomName = room ? room : "#test_channel"
  const jsonData =
  {
    "channel": roomName,
    "blocks": messageBlock
  }
  const payload = JSON.stringify(jsonData)
  const options =
  {
    "method" : "post",
    "contentType" : "application/json",
    "payload" : payload,
    "muteHttpExceptions": true
  }
  const res = UrlFetchApp.fetch(postUrl, options)
  return res.getContentText()
}

const STAFF_LIST_SHEET_KEY = 'dummy'
const POST_TARGET_SLACK_CHANNEL = '#dummy'
const SHEET_NAME = 'dummy'
const DUMMY_LINKS = [
  'https://meet.google.com/dummy'
]
const ALPHABETS = ['A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z']

const targetBook = SpreadsheetApp.openById(STAFF_LIST_SHEET_KEY)
const targetSheet = targetBook.getSheetByName(SHEET_NAME)
const targetData = targetSheet.getDataRange().getValues()
const header = targetData[1]

const WADAI = [
  "最近気になっていること",
  "最近気になるニュース",
  "好きな芸能人",
  ....
]