Google App Script（GAS）

Transcript

1. Google App ScriptʢGASʣ 2022/03/26
2. Carstayגࣜձࣾɿ֓ཁ 2
3. Carstayגࣜձࣾɿϛογϣϯ 3 Stay Anywhere, Anytime. ୭΋͕޷͖ͳͱ͖ʹɺ޷͖ͳ৔ॴͰɺ޷͖ͳਓͱաͤ͝ΔੈքΛͭ͘Δ
4. CarstayגࣜձࣾɿϓϩμΫτ 4 ʮCarstayʯ͸೔ຊͰ།ҰɺΩϟϯϐϯάΧʔͱंதധεϙοτΛ༧໿͢Δ͜ͱ͕Ͱ͖ΔεϚϗΞϓϦͰ͢ ৐Βͳ͍ظؒʹ༡ٳं྆ΛγΣΞ͍ͨ͠Φʔφʔɺۭ͖஍Λ༗ޮ׆༻͍ͨ͠றं৔Φʔφʔ͕ొ࿥͍ͯ͠·͢
5. ࣗݾ঺հ Ngo Van Thang | ϑϧελοΫΤϯδχΞ ▼ ܦྺ ɾ2014೥ʹଔۀޙʹདྷ೔ ɾ2014೥ ιʔγϟϧήʔϜӡӦձࣾʹೖࣾ ɹɾήʔϜαʔόӡ༻ ɾ2016೥ ೿ݣձࣾʹೖࣾ ɹɾίʔσΟϯάςεταʔϏεɺLINE഑৴αʔϏε։ൃ ɾ2018೥ ϒϩοΫνΣʔϯձࣾʹೖࣾ ɹɾϒϩοΫνΣʔϯΛ࢖ͬͨΫϦΤʔλͱاۀͷϚονϯάαʔϏεɺӽڥEC։ൃ ɾ2020೥ Carstayגࣜձࣾʹೖࣾ | Tech Lead ɹɾ։ൃશൠ؅ཧɺίʔυϨϏϡʔɺ΢ΣϒɾΞϓϦ։ൃ ▼झຯ ɾήʔϜʢΞΫγϣϯήʔϜɺFPS etcʣ ɾαοΧʔ ɾίϚϯυϥΠϯ͕޷͖ Ngo Van Thangʢ30ࡀʣ Github: @nooptr Facebook: https://www.facebook.com/thanghedspi 5
6. Agenda • Google Apps ScriptʢGASʣͱ͸ • GASͰԿ͕Ͱ͖Δͷ͔ʁ • GASͰͰ͖Δ͜ͱͷ׆༻ࣄྫ • GASͷ੍ݶʹ͍ͭͯ 6
7. Google Apps Scriptͱ͸
8. Google Apps ScriptʢGASʣͱ͸ ɾ(PPHMF
   "QQT
   4DSJQUͱ͸(PPHMF͕ఏڙ͍ͯ͠Δϓϩάϥϛϯά؀ڥͰ͢ɻ
   ɾ+BWB4DSJQUͱ͍͏8FCϒϥ΢β্Ͱಈ࡞͢ΔϓϩάϥϛϯάݴޠΛϕʔεʹ࡞੒͞Ε ͍ͯ·͢ɻ
   ɾ("4Λར༻͢Δ͜ͱͰɺ
   (PPHMF
   8PSLTQBDF
   ͷར༻ऀ͸ઐ໳తͳιϑτ΢ΣΞ։ൃ εΩϧ͕ͳͯ͘΋ɺۀ຿վળʹܨ͕ΔΑ͏ͳΧελϜΞϓϦέʔγϣϯΛ؆қʹ։ൃ͢Δ ͜ͱ͕Ͱ͖·͢ɻ 8
9. GASͰԿ͕Ͱ͖Δͷ͔ʁ
10. GASͰԿ͕Ͱ͖Δͷ͔ʁ ɾᶃ+BWBTDSJQUͰ࣮૷Ͱ͖ɺ͙͢ʹ։ൃΛ࢝ΊΔ͜ͱ͕Ͱ͖Δʢ։ൃ؀ڥΛߏங͢Δඞཁ͕ͳ͍ʣ
    ɾᶄ࡞ۀΛࣗಈԽͰ͖Δ
    ɹɾྫʣ(NBJMʹಧ͍ͨϝʔϧͷఴ෇ϑΝΠϧΛࣗಈͰڞ༗ϑΥϧμʹΞοϓϩʔυ͢Δઃఆ͕Ͱ͖Δ
    ɹ
    ɾྫʣ(PPHMFϑΥʔϜ͕ૹ৴͞Εͨޙʹ4MBDLͳͲʹ௨஌͢ΔΑ͏ʹઃఆ͕Ͱ͖Δ
    ɾᶅσʔλΛऩू͢Δ
    ɹɾྫʣ8FCϖʔδ্ͷ৘ใΛ؆୯ʹऔಘͰ͖Δ
    ɾᶆ8FCΞϓϦέʔγϣϯΛ։ൃͰ͖Δ
    ɹɾ("4ʹ͸։ൃͨ͠πʔϧ΍ػೳΛ8FCΞϓϦέʔγϣϯͱͯ͠8FC্ʹެ։͢Δػೳ͕උΘ͍ͬͯΔ
    ɹɾࣗ෼͕։ൃͨ͠πʔϧΛࣾ಺ͷਓʹ࢖ͬͯ΋ΒͬͨΓ͢Δ͜ͱ΋؆୯ʹͰ͖Δ
    ɾᶇDSPOUBCͷΑ͏ʹఆظతʹ("4Λ࣮ߦ͢Δ͜ͱ͕Ͱ͖Δ
    10
11. GASΛ࢝ΊΔ४උ
12. GASΛ࢝ΊΔ४උ 12 ɾGoogleΞΧ΢ϯτʢແྉͷGmailΞΧ΢ϯτͰ΋OKʣ ɾϒϥ΢βʢChrome, Firefox, Safari … ͳΜͰ΋OKʣ
13. GASͷ࢖͍ํ
14. GASͷ࢖͍ํ 14 https://drive.google.com/drive/my-drive Λ։͍͍ͯͩ͘͞
15. GASͷ࢖͍ํ 15
16. GASͷ࢖͍ํ 16
17. GASͷ࢖͍ํ 17
18. GASͷ࢖͍ํ 18 ࣮ߦํ๏
19. GASͰͰ͖Δ͜ͱͷ׆༻ࣄྫ
20. ྫ1ʣ΢Σϒ͔Β৘ใΛऔಘ 20 ɾStep1: Dev.toαΠτͷσʔλΛऔಘ͢Δ ɾStep2: εϓϨουγʔτʹσʔλΛೖΕΔ ɾStep3: ຖ෼GASΛ࣮ߦͤ͞ΔΑ͏ʹઃఆ͢Δ
21. ྫ1ʣ΢Σϒ͔Β৘ใΛऔಘ 21
22. ྫ1ʣ΢Σϒ͔Β৘ใΛऔಘ 22
23. ྫ1ʣ΢Σϒ͔Β৘ใΛऔಘ 23 ఆظతʹ࣮ߦ͢ΔΑ͏ʹઃఆ
24. ྫ2ʣ΢ΣϒΞϓϦέʔγϣϯ։ൃ 24
25. ྫ2ʣ΢ΣϒΞϓϦέʔγϣϯ։ൃ 25
26. GASͷ੍ݶ
27. GASͷ੍ݶ 27 ɾGAS͸ͳΜͰ΋ແ੍ݶʹ࢖͏Θ͚Ͱ͸ͳ͘ɺͦͷ࣮ߦճ਺΍࣌ؒ/σʔλαΠζʹ੍ݶ͕ ઃ͚ΒΕ͍Δɻ ɾΞϓϦέʔγϣϯͷ࡞੒΍࣮ߦʹ͋ͨͬͯ͸ɺ͜ΕΒͷ੍ݶΛߟྀ͢Δඞཁ͕͋Δɻ
28. GASͷ੍ݶ 28 GASͷׂΓ౰ͯ ιʔεɿhttps://developers.google.com/apps-script/guides/services/quotas
29. GASͷ੍ݶ 29 GASͷ੍ݶ ιʔεɿhttps://developers.google.com/apps-script/guides/services/quotas
30. CarstayɺઈࢍΤϯδχΞืूதͰ͢ʂ 30 ˒ CTOީิΤϯδχΞ ɾϑϩϯτΤϯυΤϯδχΞ ɾΞϓϦΤϯδχΞ ɾαʔόʔαΠυΤϯδχΞ ։ൃݴޠɿTypescriptɹ։ൃϑϨʔϜϫʔΫɿReactJS, React NativeɹWebαʔόɿNodeJS ͥͻ͓ؾܰʹ͝࿈བྷ͍ͩ͘͞ ⏬
31. 31 ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ