-
Notifications
You must be signed in to change notification settings - Fork 26
/
script.gs
70 lines (64 loc) · 2.12 KB
/
script.gs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
function sendToSlack(fallback, fields, channel) {
const url = "■1■"
const data = {
"channel" : channel,
"username" : "Googleフォーム Bot", // 1: bot 名
"attachments" : [{
"fallback" : fallback,
"text" : "★3★",
"fields": fields,
"color": "good", // 3: 左線の色
}],
"icon_emoji" : ":envelope_with_arrow:" // 2: アイコン画像
};
const payload = JSON.stringify(data);
const options = {
"method" : "POST",
"contentType" : "application/json",
"payload" : payload,
"muteHttpExceptions": true,
};
const response = UrlFetchApp.fetch(url, options);
Logger.log(response)
}
function test() {
sendToSlack("テスト通知確認です", [], "■2■");
}
function responseToText(itemResponse) {
switch (itemResponse.getItem().getType()) {
case FormApp.ItemType.CHECKBOX:
return itemResponse.getResponse().join("\n");
break;
case FormApp.ItemType.GRID:
const gridResponses = itemResponse.getResponse();
return itemResponse.getItem().asGridItem().getRows().map(function(rowName, index) {
Logger.log(rowName);
return rowName + ": " + gridResponses[index];
}).join("\n");
break;
case FormApp.ItemType.CHECKBOX_GRID:
const checkboxGridResponses = itemResponse.getResponse()
return itemResponse.getItem().asCheckboxGridItem().getRows().map(function(rowName, index) {
Logger.log(rowName);
return rowName + ": " + checkboxGridResponses[index];
}).join("\n");
break;
default:
return itemResponse.getResponse();
}
}
function onFormSubmit(e){
const itemResponses = e.response.getItemResponses();
const fallback = itemResponses.map(function(itemResponse) {
return itemResponse.getItem().getTitle() + ": " + itemResponse.getResponse();
}).join("\n");
const fields = itemResponses.map(function(itemResponse) {
const value = responseToText(itemResponse);
return {
"title": itemResponse.getItem().getTitle(),
"value": value,
"short": false, // 4: 左右2列で表示
}
});
sendToSlack(fallback, fields, "■2■");
}