シートをシャッフルしてSlack通知するgas

shuffle_slack_noti.js

function getLastRowWithValue() {
    const sheet = SpreadsheetApp.getActiveSheet(); 
    const names = sheet.getRange('A:A').getValues().filter(String);
    shuffle(names);
    const message = names.join('\n')
    slack(message)
 }


 function shuffle(array) {
    for(var i = array.length - 1; i > 0; i--){
        var r = Math.floor(Math.random() * (i + 1));
        var tmp = array[i];
        array[i] = array[r];
        array[r] = tmp;
    }
 }

function slack(message) {
    var slackWebhookURL = 'WEB HOOK URL IS HERE'    
    UrlFetchApp.fetch(slackWebhookURL, {
      method: 'post',
      payload: JSON.stringify({
        text: 'SOMETHING MESSAGE\n' + (orders || '')
      })
    })
}