工数表書き忘れ防止機能を作ってみた 〜 GASを使ったSlackへの自動通知 〜

Frontend Nagoya #7

Transcript

1. ޻਺දॻ͖๨Ε๷ࢭػೳ Λ࡞ͬͯΈͨ ʙ GASΛ࢖ͬͨSlack΁ͷࣗಈ௨஌ ʙ 2018೥12݄14೔ FrontEndNagoya#7 ੁݪ ࠼
2. ޻਺දॻ͖๨Ε๷ࢭػೳ Λ࡞ͬͯΈͨ ʙ GASΛ࢖ͬͨSlack΁ͷࣗಈ௨஌ ʙ 2018೥12݄14೔ FrontEndNagoya#7 ੁݪ ࠼ ࢼ࡞൛ʂ
3. ϓϩϑΟʔϧ ໊લɿੁݪ࠼ ॴଐɿ༗ݶձࣾΞοϓϧοϓϧ ʢ2018೥3݄ೖࣾʣ ৬छɿϚʔΫΞοϓΤϯδχΞ ʢϑϩϯτΤϯυΤϯδχΞͱ໊৐ΕΔΑ͏ʹͳΓ͍ͨ…ʣ
4. օ͞ΜɺGAS Λ͝ଘ஌Ͱ͔͢ʁ ʢ Google Apps Script ʣ
5. GAS ʢ Google Apps Script ʣͱ͸ʁ
6. GAS ʢ Google Apps Script ʣͱ͸ʁ Google Apps Script͸ɺG Suiteͱ౷߹͞ΕͨϏδωε ΞϓϦέʔγϣϯΛਝ଎͔ͭ؆୯ʹ࡞੒Ͱ͖Δɺ ਝ଎ͳΞϓϦέʔγϣϯ։ൃϓϥοτϑΥʔϜͰ ͢ɻJavaScriptͰίʔυΛهड़͠ɺGmailɺΧϨϯ μʔɺυϥΠϒͳͲͷ޷͖ͳG SuiteΞϓϦέʔ γϣϯ༻ͷ૊ΈࠐΈϥΠϒϥϦʹΞΫηεͰ͖· ͢ɻΠϯετʔϧ͢Δ΋ͷ͸Կ΋͋Γ·ͤΜɻϒ ϥ΢βʹίʔυΤσΟλΛΠϯετʔϧ͠ɺ GoogleͷαʔόʔͰεΫϦϓτΛ࣮ߦ͠·͢ɻ Ҿ༻ݩɿhttps:/ /developers.google.com/apps-script/overview
7. GAS ʢ Google Apps Script ʣͱ͸ʁ Google ͕ఏڙ͍ͯ͠Δ JavaScript Λϕʔεʹ ͨ͠ϓϩάϥϛϯάݴޠɻ
8. GAS ʢ Google Apps Script ʣͱ͸ʁ Google ͕ఏڙ͍ͯ͠Δ JavaScript Λϕʔεʹ ͨ͠ϓϩάϥϛϯάݴޠɻ ͦͷಛ௃͸ʁ
9. GAS ʢ Google Apps Script ʣͱ͸ʁ Google ͕ఏڙ͍ͯ͠Δ JavaScript Λϕʔεʹ ͨ͠ϓϩάϥϛϯάݴޠɻ
10. GAS ʢ Google Apps Script ʣͱ͸ʁ Google ͕ఏڙ͍ͯ͠Δ JavaScript Λϕʔεʹ ͨ͠ϓϩάϥϛϯάݴޠɻ ؆୯ʹʂ ࿈ܞ&ૢ࡞Ͱ͖Δʂ
11. ࠓ೔ͷຊ୊
12. ࠓ೔ͷຊ୊ ޻਺දॻ͖๨Ε๷ࢭػೳ Λ࡞ͬͯΈͨ ʙ GASΛ࢖ͬͨSlack΁ͷࣗಈ௨஌ ʙ
13. ࠓ೔ͷຊ୊ ޻਺දॻ͖๨Ε๷ࢭػೳ Λ࡞ͬͯΈͨ ʙ GASΛ࢖ͬͨSlack΁ͷࣗಈ௨஌ ʙ Google Spreadsheet Google Spreadsheet ͱ Slack ͷ࿈ܞ
14. ࠓ೔ͷຊ୊ ޻਺දॻ͖๨Ε๷ࢭػೳ Λ࡞ͬͯΈͨ ʙ GASΛ࢖ͬͨSlack΁ͷࣗಈ௨஌ ʙ Google Spreadsheet Google Spreadsheet ͱ Slack ͷ࿈ܞ ؆୯ʹʂʂ
15. Google Spreadsheet
16. ۩ମతͳॲཧ಺༰
17. ۩ମతͳॲཧ಺༰ ࡢ೔ͷ޻਺Λೖྗ͍ͯ͠Δ͔֬ೝ ೖྗ͞Ε͍ͯΕ͹ɺ Slack΁ʮೖྗͯͯ͑͠Β͍Ͷʂʯͱ௨஌Λ͢Δ ೖྗ͞Ε͍ͯͳ͚Ε͹ Slack΁ʮೖྗͯ͠Ͷʂʯͱ௨஌͢Δɻ
18. ։ൃͷϙΠϯτ 1. ։ൃ؀ڥ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏ 3. Slack ΁ͷ௨஌ํ๏ 4. ࣗಈͰఆظతͳ޻਺ೖྗνΣοΫɺ ɹ௨஌Λ͢Δ࢓૊Έ
19. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 1. ։ൃ؀ڥ
20. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 1. ։ൃ؀ڥ Google Spreadsheet ͷΈʂ
21. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ Google Spreadsheet ͷΈʂ 1. ։ൃ؀ڥ
22. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ Google Spreadsheet ͷΈʂ 1. ։ൃ؀ڥ
23. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ Google Spreadsheet ͷΈʂ 1. ։ൃ؀ڥ
24. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ Google Spreadsheet ͷΈʂ ؆୯ʂʂ 1. ։ൃ؀ڥ
25. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏
26. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏ άάΕ͹ͨ͘͞Μग़ͯ͘Δʂʂ
27. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏ SpreadsheetApp.getActiveSheet(); SpreadsheetApp.getActiveSheet().getLastRow(); SpreadsheetApp.getActiveSheet() ɹɹɹɹɹɹ.getRange(i, column, 1).getValue();
28. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏ SpreadsheetApp.getActiveSheet(); SpreadsheetApp.getActiveSheet().getLastRow(); SpreadsheetApp.getActiveSheet() ɹɹɹɹɹɹ.getRange(i, column, 1).getValue(); ௚ײతʹ࢖͑Δػೳ͕ἧͬͯΔ
29. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏ SpreadsheetApp.getActiveSheet(); SpreadsheetApp.getActiveSheet().getLastRow(); SpreadsheetApp.getActiveSheet() ɹɹɹɹɹɹ.getRange(i, column, 1).getValue(); ௚ײతʹ࢖͑Δػೳ͕ἧͬͯΔ ؆୯ʂʂ
30. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 3. Slack ΁ͷ௨஌
31. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ Incoming Webhook Ҿ༻ݩɿhttps:/ /get.slack.help/hc/ja/ articles/115005265063-Slack- %E3%81%A7%E3%81%AEIncoming-Webhook- %E3%81%AE%E5%88%A9%E7%94%A8 3. Slack ΁ͷ௨஌
32. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ Incoming Webhook Ҿ༻ݩɿhttps:/ /get.slack.help/hc/ja/ articles/115005265063-Slack- %E3%81%A7%E3%81%AEIncoming-Webhook- %E3%81%AE%E5%88%A9%E7%94%A8 ϫʔΫεϖʔεʹ ؆୯ʹ֎෦ͷ৘ใΛ ڞ༗Ͱ͖Δπʔϧɻ 3. Slack ΁ͷ௨஌
33. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ Incoming Webhook Ҿ༻ݩɿhttps:/ /get.slack.help/hc/ja/ articles/115005265063-Slack- %E3%81%A7%E3%81%AEIncoming-Webhook- %E3%81%AE%E5%88%A9%E7%94%A8 GASͱͷ࿈ܞํ๏͸ɺ άάΕ͹ͨ͘͞Μग़ͯ͘Δʂʂ 3. Slack ΁ͷ௨஌
34. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ Incoming Webhook Ҿ༻ݩɿhttps:/ /get.slack.help/hc/ja/ articles/115005265063-Slack- %E3%81%A7%E3%81%AEIncoming-Webhook- %E3%81%AE%E5%88%A9%E7%94%A8 3. Slack ΁ͷ௨஌ ؆୯ʂʂ GASͱͷ࿈ܞํ๏͸ɺ άάΕ͹ͨ͘͞Μग़ͯ͘Δʂʂ
35. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 4. ࣗಈ௨஌ʢτϦΨʔʣઃఆ
36. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 4. ࣗಈ௨஌ઃఆ ʢτϦΨʔʣ
37. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 4. ࣗಈ௨஌ઃఆ ʢτϦΨʔʣ GUI ͰઃఆͰ͖Δʂ
38. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 4. ࣗಈ௨஌ʢτϦΨʔʣઃఆ
39. ޻਺දॻ͖๨Ε๷ࢭػೳͷ࡞੒ 4. ࣗಈ௨஌ʢτϦΨʔʣઃఆ GUI ͰઃఆͰ͖Δʂ ؆୯ʂʂ
40. ։ൃͷϙΠϯτ 1. ։ൃ؀ڥ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏ 3. Slack ΁ͷ௨஌ํ๏ 4. ࣗಈͰఆظతͳ޻਺ೖྗνΣοΫɺ ɹ௨஌Λ͢Δ࢓૊Έ
41. ։ൃͷϙΠϯτ 1. ։ൃ؀ڥ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏ 3. Slack ΁ͷ௨஌ํ๏ 4. ࣗಈͰఆظతͳ޻਺ೖྗνΣοΫɺ ɹ௨஌Λ͢Δ࢓૊Έ ˠ Spreadsheetʹ௚઀͔͚Δ ˠ௚ײతʹ࢖͑Δػೳ͕ἧͬͯΔ ˠSlackΞϓϦͰ؆୯ઃఆ ˠGUI ը໘Ͱ؆୯ઃఆ
42. ։ൃͷϙΠϯτ 1. ։ൃ؀ڥ 2. εϓϨουγʔτͷ৘ใΛऔಘ͢Δํ๏ 3. Slack ΁ͷ௨஌ํ๏ 4. ࣗಈͰఆظతͳ޻਺ೖྗνΣοΫɺ ɹ௨஌Λ͢Δ࢓૊Έ ˠ Spreadsheetʹ௚઀͔͚Δ ˠSlackΞϓϦͰ؆୯ઃఆ ˠGUI ը໘Ͱ؆୯ઃఆ ؆୯ʂʂ ˠ௚ײతʹ࢖͑Δػೳ͕ἧͬͯΔ
43. ·ͱΊ JavaScript Λ͋·Γॻ͍ͨ͜ͱ͕ͳ͍ਓͰ΋ ʢˢࢲͷ͜ͱʣɺ ؆୯ʹɺ͓खܰʹ։ൃͰ͖ͪΌ͏ʂ Google ΞϓϦؔ࿈ͰԿ͔Λ։ൃ͍ͨ͠ͳΒɺ ͥͻGASΛ࢖ͬͯΈ͍ͯͩ͘͞ʂ
44. ࠷ޙʹ…
45. ΋͠SlackͰ௨஌ςετ͢ΔͳΒɺ μΠϨΫτϝοηʔδͰ΍Γ·͠ΐ ͏ɻɻɻ
46. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ facebook.com/raichimomo @rachicom_sugar https:/ /rachicom.net/