Google App Script（GAS）

by CarstayJP

Slide 1

Slide 1 text

Google App ScriptʢGASʣ 2022/03/26

Slide 2

Slide 2 text

Carstayגࣜձࣾɿ֓ཁ 2

Slide 3

Slide 3 text

Carstayגࣜձࣾɿϛογϣϯ 3 Stay Anywhere, Anytime. ୭΋͕޷͖ͳͱ͖ʹɺ޷͖ͳ৔ॴͰɺ޷͖ͳਓͱաͤ͝ΔੈքΛͭ͘Δ

Slide 4

Slide 4 text

CarstayגࣜձࣾɿϓϩμΫτ 4 ʮCarstayʯ͸೔ຊͰ།ҰɺΩϟϯϐϯάΧʔͱंதധεϙοτΛ༧໿͢Δ͜ͱ͕Ͱ͖ΔεϚϗΞϓϦͰ͢ ৐Βͳ͍ظؒʹ༡ٳं྆ΛγΣΞ͍ͨ͠Φʔφʔɺۭ͖஍Λ༗ޮ׆༻͍ͨ͠றं৔Φʔφʔ͕ొ࿥͍ͯ͠·͢

Slide 5

Slide 5 text

ࣗݾ঺հ 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

Slide 6

Slide 6 text

Agenda ● Google Apps ScriptʢGASʣͱ͸ ● GASͰԿ͕Ͱ͖Δͷ͔ʁ ● GASͰͰ͖Δ͜ͱͷ׆༻ࣄྫ ● GASͷ੍ݶʹ͍ͭͯ 6

Slide 7

Slide 7 text

Google Apps Scriptͱ͸

Slide 8

Slide 8 text

Google Apps ScriptʢGASʣͱ͸ ɾ(PPHMF"QQT4DSJQUͱ͸(PPHMF͕ఏڙ͍ͯ͠Δϓϩάϥϛϯά؀ڥͰ͢ɻ ɾ+BWB4DSJQUͱ͍͏8FCϒϥ΢β্Ͱಈ࡞͢ΔϓϩάϥϛϯάݴޠΛϕʔεʹ࡞੒͞Ε ͍ͯ·͢ɻ ɾ("4Λར༻͢Δ͜ͱͰɺ(PPHMF8PSLTQBDFͷར༻ऀ͸ઐ໳తͳιϑτ΢ΣΞ։ൃ εΩϧ͕ͳͯ͘΋ɺۀ຿վળʹܨ͕ΔΑ͏ͳΧελϜΞϓϦέʔγϣϯΛ؆қʹ։ൃ͢Δ ͜ͱ͕Ͱ͖·͢ɻ 8

Slide 9

Slide 9 text

GASͰԿ͕Ͱ͖Δͷ͔ʁ

Slide 10

Slide 10 text

GASͰԿ͕Ͱ͖Δͷ͔ʁ ɾᶃ+BWBTDSJQUͰ࣮૷Ͱ͖ɺ͙͢ʹ։ൃΛ࢝ΊΔ͜ͱ͕Ͱ͖Δʢ։ൃ؀ڥΛߏங͢Δඞཁ͕ͳ͍ʣ ɾᶄ࡞ۀΛࣗಈԽͰ͖Δ ɹɾྫʣ(NBJMʹಧ͍ͨϝʔϧͷఴ෇ϑΝΠϧΛࣗಈͰڞ༗ϑΥϧμʹΞοϓϩʔυ͢Δઃఆ͕Ͱ͖Δ ɹɾྫʣ(PPHMFϑΥʔϜ͕ૹ৴͞Εͨޙʹ4MBDLͳͲʹ௨஌͢ΔΑ͏ʹઃఆ͕Ͱ͖Δ ɾᶅσʔλΛऩू͢Δ ɹɾྫʣ8FCϖʔδ্ͷ৘ใΛ؆୯ʹऔಘͰ͖Δ ɾᶆ8FCΞϓϦέʔγϣϯΛ։ൃͰ͖Δ ɹɾ("4ʹ͸։ൃͨ͠πʔϧ΍ػೳΛ8FCΞϓϦέʔγϣϯͱͯ͠8FC্ʹެ։͢Δػೳ͕උΘ͍ͬͯΔ ɹɾࣗ෼͕։ൃͨ͠πʔϧΛࣾ಺ͷਓʹ࢖ͬͯ΋ΒͬͨΓ͢Δ͜ͱ΋؆୯ʹͰ͖Δ ɾᶇDSPOUBCͷΑ͏ʹఆظతʹ("4Λ࣮ߦ͢Δ͜ͱ͕Ͱ͖Δ 10

Slide 11

Slide 11 text

GASΛ࢝ΊΔ४උ

Slide 12

Slide 12 text

GASΛ࢝ΊΔ४උ 12 ɾGoogleΞΧ΢ϯτʢແྉͷGmailΞΧ΢ϯτͰ΋OKʣ ɾϒϥ΢βʢChrome, Firefox, Safari … ͳΜͰ΋OKʣ

Slide 13

Slide 13 text

GASͷ࢖͍ํ

Slide 14

Slide 14 text

GASͷ࢖͍ํ 14 https://drive.google.com/drive/my-drive Λ։͍͍ͯͩ͘͞

Slide 15

Slide 15 text

GASͷ࢖͍ํ 15

Slide 16

Slide 16 text

GASͷ࢖͍ํ 16

Slide 17

Slide 17 text

GASͷ࢖͍ํ 17

Slide 18

Slide 18 text

GASͷ࢖͍ํ 18 ࣮ߦํ๏

Slide 19

Slide 19 text

GASͰͰ͖Δ͜ͱͷ׆༻ࣄྫ

Slide 20

Slide 20 text

ྫ1ʣ΢Σϒ͔Β৘ใΛऔಘ 20 ɾStep1: Dev.toαΠτͷσʔλΛऔಘ͢Δ ɾStep2: εϓϨουγʔτʹσʔλΛೖΕΔ ɾStep3: ຖ෼GASΛ࣮ߦͤ͞ΔΑ͏ʹઃఆ͢Δ

Slide 21

Slide 21 text

ྫ1ʣ΢Σϒ͔Β৘ใΛऔಘ 21

Slide 22

Slide 22 text

ྫ1ʣ΢Σϒ͔Β৘ใΛऔಘ 22

Slide 23

Slide 23 text

ྫ1ʣ΢Σϒ͔Β৘ใΛऔಘ 23 ఆظతʹ࣮ߦ͢ΔΑ͏ʹઃఆ

Slide 24

Slide 24 text

ྫ2ʣ΢ΣϒΞϓϦέʔγϣϯ։ൃ 24

Slide 25

Slide 25 text

ྫ2ʣ΢ΣϒΞϓϦέʔγϣϯ։ൃ 25

Slide 26

Slide 26 text

GASͷ੍ݶ

Slide 27

Slide 27 text

GASͷ੍ݶ 27 ɾGAS͸ͳΜͰ΋ແ੍ݶʹ࢖͏Θ͚Ͱ͸ͳ͘ɺͦͷ࣮ߦճ਺΍࣌ؒ/σʔλαΠζʹ੍ݶ͕ ઃ͚ΒΕ͍Δɻ ɾΞϓϦέʔγϣϯͷ࡞੒΍࣮ߦʹ͋ͨͬͯ͸ɺ͜ΕΒͷ੍ݶΛߟྀ͢Δඞཁ͕͋Δɻ

Slide 28

Slide 28 text

GASͷ੍ݶ 28 GASͷׂΓ౰ͯ ιʔεɿhttps://developers.google.com/apps-script/guides/services/quotas

Slide 29

Slide 29 text

GASͷ੍ݶ 29 GASͷ੍ݶ ιʔεɿhttps://developers.google.com/apps-script/guides/services/quotas

Slide 30

Slide 30 text

CarstayɺઈࢍΤϯδχΞืूதͰ͢ʂ 30 ˒ CTOީิΤϯδχΞ ɾϑϩϯτΤϯυΤϯδχΞ ɾΞϓϦΤϯδχΞ ɾαʔόʔαΠυΤϯδχΞ ։ൃݴޠɿTypescriptɹ։ൃϑϨʔϜϫʔΫɿReactJS, React NativeɹWebαʔόɿNodeJS ͥͻ͓ؾܰʹ͝࿈བྷ͍ͩ͘͞ ⏬

Slide 31

Slide 31 text

31 ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ