Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Google App Script(GAS)

Google App Script(GAS)

1c7c5f4254748d5e3da9a1095e42d85c?s=128

CarstayJP

March 28, 2022
Tweet

More Decks by CarstayJP

Other Decks in Programming

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"QQT4DSJQUͱ͸(PPHMF͕ఏڙ͍ͯ͠Δϓϩάϥϛϯά؀ڥͰ͢ɻ ɾ+BWB4DSJQUͱ͍͏8FCϒϥ΢β্Ͱಈ࡞͢ΔϓϩάϥϛϯάݴޠΛϕʔεʹ࡞੒͞Ε ͍ͯ·͢ɻ ɾ("4Λར༻͢Δ͜ͱͰɺ(PPHMF8PSLTQBDFͷར༻ऀ͸ઐ໳తͳιϑτ΢ΣΞ։ൃ εΩϧ͕ͳͯ͘΋ɺۀ຿վળʹܨ͕ΔΑ͏ͳΧελϜΞϓϦέʔγϣϯΛ؆қʹ։ൃ͢Δ ͜ͱ͕Ͱ͖·͢ɻ 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 ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ