Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
Google App Script(GAS)
CarstayJP
March 28, 2022
Programming
0
110
Google App Script(GAS)
CarstayJP
March 28, 2022
Tweet
Share
More Decks by CarstayJP
See All by CarstayJP
C向けスタートアップのプロダクト開発の進め方
carstayjp
0
230
フロントエンドエンジニアのためのセキュリティ対策
carstayjp
1
220
Other Decks in Programming
See All in Programming
Node-RED 3.0 新機能紹介
utaani
0
140
設計の学び方:自分流のススメ
masuda220
PRO
10
7k
Amazon ECSのネットワーク関連コストの話
msato
0
650
"What's new in Swift"の要約 / swift_5_7_summary
uhooi
1
330
UI Testing of Jetpack Compose Apps, AppDevCon
alexzhukovich
0
170
Springin‘でみんなもクリエイターに!
ueponx
0
220
React Nativeアプリを DDDで開発している話
nihemak
0
150
Get Ready for Jakarta EE 10
ivargrimstad
0
2.5k
こそこそアジャイル導入しようぜ!
ichimichi
0
1.2k
JetPackComposeは宣言型プログラミングパラダイムって実はよくわかってないんですが、別に使ってもいいんですよね、
conigashima
0
190
Java アプリとAWS の良い関係 - AWS でJava アプリを実行する一番簡単な方法教えます / AWS for Javarista
kanamasa
2
1.3k
競プロのすすめ
uya116
0
670
Featured
See All Featured
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
269
11k
A Modern Web Designer's Workflow
chriscoyier
689
180k
How STYLIGHT went responsive
nonsquared
85
3.9k
The Pragmatic Product Professional
lauravandoore
19
3k
Practical Orchestrator
shlominoach
178
8.6k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
315
19k
Adopting Sorbet at Scale
ufuk
63
7.6k
It's Worth the Effort
3n
172
25k
GraphQLとの向き合い方2022年版
quramy
16
8.3k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
7
1.1k
Music & Morning Musume
bryan
35
4.2k
In The Pink: A Labor of Love
frogandcode
131
21k
Transcript
Google App ScriptʢGASʣ 2022/03/26
Carstayגࣜձࣾɿ֓ཁ 2
Carstayגࣜձࣾɿϛογϣϯ 3 Stay Anywhere, Anytime. ୭͕͖ͳͱ͖ʹɺ͖ͳॴͰɺ͖ͳਓͱաͤ͝ΔੈքΛͭ͘Δ
CarstayגࣜձࣾɿϓϩμΫτ 4 ʮCarstayʯຊͰ།ҰɺΩϟϯϐϯάΧʔͱंதധεϙοτΛ༧͢Δ͜ͱ͕Ͱ͖ΔεϚϗΞϓϦͰ͢ Βͳ͍ظؒʹ༡ٳं྆ΛγΣΞ͍ͨ͠Φʔφʔɺۭ͖Λ༗ޮ׆༻͍ͨ͠றंΦʔφʔ͕ొ͍ͯ͠·͢
ࣗݾհ 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
Agenda • Google Apps ScriptʢGASʣͱ • GASͰԿ͕Ͱ͖Δͷ͔ʁ • GASͰͰ͖Δ͜ͱͷ׆༻ࣄྫ •
GASͷ੍ݶʹ͍ͭͯ 6
Google Apps Scriptͱ
Google Apps ScriptʢGASʣͱ ɾ(PPHMF"QQT4DSJQUͱ(PPHMF͕ఏڙ͍ͯ͠ΔϓϩάϥϛϯάڥͰ͢ɻ ɾ+BWB4DSJQUͱ͍͏8FCϒϥβ্Ͱಈ࡞͢ΔϓϩάϥϛϯάݴޠΛϕʔεʹ࡞͞Ε ͍ͯ·͢ɻ ɾ("4Λར༻͢Δ͜ͱͰɺ(PPHMF8PSLTQBDFͷར༻ऀઐతͳιϑτΣΞ։ൃ εΩϧ͕ͳͯ͘ɺۀվળʹܨ͕ΔΑ͏ͳΧελϜΞϓϦέʔγϣϯΛ؆қʹ։ൃ͢Δ ͜ͱ͕Ͱ͖·͢ɻ 8
GASͰԿ͕Ͱ͖Δͷ͔ʁ
GASͰԿ͕Ͱ͖Δͷ͔ʁ ɾᶃ+BWBTDSJQUͰ࣮Ͱ͖ɺ͙͢ʹ։ൃΛ࢝ΊΔ͜ͱ͕Ͱ͖Δʢ։ൃڥΛߏங͢Δඞཁ͕ͳ͍ʣ ɾᶄ࡞ۀΛࣗಈԽͰ͖Δ ɹɾྫʣ(NBJMʹಧ͍ͨϝʔϧͷఴϑΝΠϧΛࣗಈͰڞ༗ϑΥϧμʹΞοϓϩʔυ͢Δઃఆ͕Ͱ͖Δ ɹɾྫʣ(PPHMFϑΥʔϜ͕ૹ৴͞Εͨޙʹ4MBDLͳͲʹ௨͢ΔΑ͏ʹઃఆ͕Ͱ͖Δ ɾᶅσʔλΛऩू͢Δ ɹɾྫʣ8FCϖʔδ্ͷใΛ؆୯ʹऔಘͰ͖Δ ɾᶆ8FCΞϓϦέʔγϣϯΛ։ൃͰ͖Δ ɹɾ("4ʹ։ൃͨ͠πʔϧػೳΛ8FCΞϓϦέʔγϣϯͱͯ͠8FC্ʹެ։͢Δػೳ͕උΘ͍ͬͯΔ ɹɾ͕ࣗ։ൃͨ͠πʔϧΛࣾͷਓʹͬͯΒͬͨΓ͢Δ͜ͱ؆୯ʹͰ͖Δ
ɾᶇDSPOUBCͷΑ͏ʹఆظతʹ("4Λ࣮ߦ͢Δ͜ͱ͕Ͱ͖Δ 10
GASΛ࢝ΊΔ४උ
GASΛ࢝ΊΔ४උ 12 ɾGoogleΞΧϯτʢແྉͷGmailΞΧϯτͰOKʣ ɾϒϥβʢChrome, Firefox, Safari … ͳΜͰOKʣ
GASͷ͍ํ
GASͷ͍ํ 14 https://drive.google.com/drive/my-drive Λ։͍͍ͯͩ͘͞
GASͷ͍ํ 15
GASͷ͍ํ 16
GASͷ͍ํ 17
GASͷ͍ํ 18 ࣮ߦํ๏
GASͰͰ͖Δ͜ͱͷ׆༻ࣄྫ
ྫ1ʣΣϒ͔ΒใΛऔಘ 20 ɾStep1: Dev.toαΠτͷσʔλΛऔಘ͢Δ ɾStep2: εϓϨουγʔτʹσʔλΛೖΕΔ ɾStep3: ຖGASΛ࣮ߦͤ͞ΔΑ͏ʹઃఆ͢Δ
ྫ1ʣΣϒ͔ΒใΛऔಘ 21
ྫ1ʣΣϒ͔ΒใΛऔಘ 22
ྫ1ʣΣϒ͔ΒใΛऔಘ 23 ఆظతʹ࣮ߦ͢ΔΑ͏ʹઃఆ
ྫ2ʣΣϒΞϓϦέʔγϣϯ։ൃ 24
ྫ2ʣΣϒΞϓϦέʔγϣϯ։ൃ 25
GASͷ੍ݶ
GASͷ੍ݶ 27 ɾGASͳΜͰແ੍ݶʹ͏Θ͚Ͱͳ͘ɺͦͷ࣮ߦճ࣌ؒ/σʔλαΠζʹ੍ݶ͕ ઃ͚ΒΕ͍Δɻ ɾΞϓϦέʔγϣϯͷ࡞࣮ߦʹ͋ͨͬͯɺ͜ΕΒͷ੍ݶΛߟྀ͢Δඞཁ͕͋Δɻ
GASͷ੍ݶ 28 GASͷׂΓͯ ιʔεɿhttps://developers.google.com/apps-script/guides/services/quotas
GASͷ੍ݶ 29 GASͷ੍ݶ ιʔεɿhttps://developers.google.com/apps-script/guides/services/quotas
CarstayɺઈࢍΤϯδχΞืूதͰ͢ʂ 30 ˒ CTOީิΤϯδχΞ ɾϑϩϯτΤϯυΤϯδχΞ ɾΞϓϦΤϯδχΞ ɾαʔόʔαΠυΤϯδχΞ ։ൃݴޠɿTypescriptɹ։ൃϑϨʔϜϫʔΫɿReactJS, React NativeɹWebαʔόɿNodeJS
ͥͻ͓ؾܰʹ͝࿈བྷ͍ͩ͘͞ ⏬
31 ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ