Google Apps Scriptで三日坊主を克服する

10/31にGaiaxさんが主催の『Google Apps Script 活用ミートアップ』で使用した資料です。
https://gaiax.connpass.com/event/69200/

Transcript

1. Google Apps ScriptͰ ࡾ೔๥ओΛࠀ෰͢Δ @tadaken3
2. ࣗݾ঺հ • λμέϯ(@tadaken3) • ژ౎ग़਎ • ෳۀɿ͍ͭ΋ྡʹITͷ͓࢓ࣄʢhttps://tonari-it.comʣ • झຯɿࣗసंɺےτϨ • ຊۀɿσʔλΞφϦετ
3. ےτϨͯ͠·͔͢ʁ
4. ےτϨ͍ͨ͠Ͱ͢ΑͶʁ
5. ͔ͤͬ͘δϜ௨͍Λ࢝Ί͚ͨͲɺ • ࢓ࣄ͕๩ͯ͘͠ • ࠓ೔ɺӍ͔ͩΒ • ҿΈձʹ༠ΘΕͨ • ΍Δؾ͕ग़ͳ͍ ͋Δ͋Δ
6. Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ ؍ଌ͑͞Ͱ͖Ε͹ׯবͰ͖Δɻ
 ׯবͰ͖ΔͳΒɺ੍ޚ΋Ͱ͖Δɻ
7. ᶃߦಈͷه࿥ ᶆૹ৴ࢦࣔ ᶅܭࢉ݁Ռͷ อଘ ᶄܦա೔਺ͷ ܭࢉ εϓϨουγʔτ εϚʔτϑΥϯ Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ Google Apps Script LINE Notify API
8. Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ IFTTTͰϘλϯΛ࡞Δ
9. Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ εϓϨουγʔτʹه࿥
10. Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ //IFTTTͷ೔෇ܗ͔ࣜΒ௨ৗͷ೔෇ʹม׵ function toDateFromIFTTT(str){ str = String(str); str = str.replace(/at.*/,"")//ਖ਼نදݱͰatΑΓޙΖͷ෦෼Λ࡟আ d = new Date(str); return d; } IFTTTͷ೔෇ܗࣜ(str)Λdateʹม׵
11. Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ var ss = SpreadsheetApp.getActiveSpreadsheet(); //εϓϨουγʔτΛऔಘ var sheet = ss.getSheetByName("log"); //γʔτΛऔಘ //γʔτͷ࠷ऴߦʹܦա೔Λܭࢉ͢ΔࣜΛηοτ͢Δ function setFormuraLastRow(){ //γʔτͷ࢖༻ൣғͷ͏ͪ࠷ऴߦΛऔಘ var maxRow = sheet.getDataRange().getLastRow(); //Aྻͷ࠷ऴߦͷ஋Λऔಘ var str = sheet.getRange(maxRow,1).getValue(); //εϓϨουγʔτ༻ͷࣜ var code = '=TODAY() - TO_DATE(B'+ maxRow+')'; //ϑΥʔϚοτͨ͠೔෇Ληοτ sheet.getRange(maxRow,2).setValue(toDateFromIFTTT(str)); //ࣜΛηοτ͢Δ sheet.getRange(maxRow,3).setFormula(code); } ܦա೔਺Λܭࢉ͢Δ
12. Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ ܦա೔਺͕ܭࢉͰ͖ͨ
13. Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ //LINEʹ௨஌ΛૹΔؔ਺ function sentToLine(message){ var token = "ઌఔऔಘͨ͠ΞΫηετʔΫϯ"; var options = { "method" : "post", "payload" : "message=" + message, "headers" : {"Authorization" : "Bearer "+ token} }; UrlFetchApp.fetch("https://notify-api.line.me/api/notify",options); } LINE NotifyʹϝοηʔδΛૹΔ
14. Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ function main(){ setFormuraLastRow() var maxRow = sheet.getDataRange().getLastRow(); var passDate = sheet.getRange(maxRow,3).getValue(); var message =""; //ܦա೔͕̏೔΋͘͠͸7೔Ҏ্ͩͬͨΒLINEʹ௨஌ΛૹΔ if (passDate==3 || passDate>=7){ message = "࠷ऴτϨʔχϯά͔Β"+ passDate + "೔ܦա͠·ͨ͠"; sentToLine(message); } } ૊Θ࣮ͤͯ૷͢Δ
15. ·ͱΊ • IFTTTΛ࢖ͬͯγʔτʹߦಈΛه࿥ • GASͰܦա೔਺Λܭࢉͱૹ৴൑ఆ • LINE NotifyͰ௨஌ Google Apps ScriptͰࡾ೔๥ओΛࠀ෰͢Δ
16. ଞʹ΋ • Fitbit APIͱ૊ΘͤͯઁऔΧϩϦʔͱӫཆૉΛ௨஌ • ΰϛͷ೔ͷલ೔ʹ௨஌ • ਌΍༑ਓͷ஀ੜ೔ͷ1िؒલʹ௨஌ ͋ͳ͚ͨͩͷ ύʔιφϧτϨʔφʔ݉Ոఉ಺bot͕࡞ΕΔ
17. – tadaken3 “ ےτϨʹ΋Google Apps Scriptʹ΋ ऴΘΓ͕ͳ͍”
18. ϒϩάͷಡऀొ࿥͓ئ͍͠·͢ʂ http://tadaken3.hatenablog.jp
19. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠