Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
Google Apps Scriptの良さについてしゃべる資料
Taketoshi Aono(青野健利 a.k.a brn)
September 21, 2018
Programming
2
330
Google Apps Scriptの良さについてしゃべる資料
GASでUI作ったり claspで管理したり
GASの実行環境についてとか
Taketoshi Aono(青野健利 a.k.a brn)
September 21, 2018
Tweet
Share
More Decks by Taketoshi Aono(青野健利 a.k.a brn)
See All by Taketoshi Aono(青野健利 a.k.a brn)
CA 1Day Youth Bootcamp for Frontend LT
brn
0
360
Modern TypeScript
brn
2
570
javascript - behind the scene
brn
3
500
tc39 proposals
brn
0
520
プロダクト開発とTypeScript
brn
8
2.5k
React-Springでリッチなアニメーション
brn
1
440
javascript internationalization API
brn
0
550
How V8 executes WASM
brn
3
1.4k
memory_in_javascript.pdf
brn
0
720
Other Decks in Programming
See All in Programming
監視せなあかんし、五大紙だけにオオカミってな🐺🐺🐺🐺🐺
sadnessojisan
3
1.6k
How to Fight Production Incidents?
asatarin
0
240
AWSとCPUのムフフな関係
cmdemura
0
480
存在しないアセットへの参照と 未公開アセットでのネタバレに どう立ち向かうか / How to prevent missing assets and spoilers by assets
orgachem
0
200
フロントエンドで 良いコードを書くために
t_keshi
3
1.7k
TokyoR#103_DataProcessing
kilometer
0
550
Most Valuable Bug(?) ~インシデント未遂から得た学び~
tatsumiakahori
0
150
WordPress(再)入門 - 基礎知識・環境編
oleindesign
1
140
TSX First な Zero-Runtime SSG potato4d/dodai とその仕組み / owned static site generator #kyotojs
potato4d
1
480
Hasura の Relationship と権限管理
karszawa
0
180
ECテックカンファレンス2023
kspace
1
390
子育てとEMと転職と
_atsushisakai
1
430
Featured
See All Featured
How GitHub Uses GitHub to Build GitHub
holman
465
280k
Learning to Love Humans: Emotional Interface Design
aarron
263
38k
Designing the Hi-DPI Web
ddemaree
273
32k
Fashionably flexible responsive web design (full day workshop)
malarkey
396
63k
Building a Scalable Design System with Sketch
lauravandoore
451
31k
What’s in a name? Adding method to the madness
productmarketing
12
1.9k
For a Future-Friendly Web
brad_frost
166
7.8k
Ruby is Unlike a Banana
tanoku
93
9.6k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
227
16k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
349
27k
10 Git Anti Patterns You Should be Aware of
lemiorhan
643
54k
Large-scale JavaScript Application Architecture
addyosmani
499
110k
Transcript
amazing Google Apps Script
Name @brn (ꫬꅿ⨳ⵃ) Occupation ؿٗٝزؒٝسؒٝآص،٥ط؎ذ؍ـؒٝآص، Company Cyberagent ،سذؙأةآؔ AI Messenger
OSS Contributor of V8 About http://info.b6n.ch
What is GAS?
GoogleAppScriptךֿה Google SpreadSheetהַד⢪ִ javascriptGoogleךؙٓؐس橆㞮ד䩛鯪ח㹋遤דֹ ExcelךVBAְזװא What is GAS?
Specification
• ES5湱䔲ךjavascriptָ鎸鶢דֹ • Webـٓؐؠ♳דرغحؚ〳腉 • fetchד㢩鿇ٔا٦أהך鸬䵿〳腉 • 㹋遤穠卓⥂㶷׃גⱄⵃ欽דֹ • 暴㹀ך勴⟝ד㹋遤ׇֿׁה〳腉(儗הַ)
• 6ⴓדة؎ي،ؐز What is GAS?
Use SpreadSheet as UI
䒦爡ךفٗتؙزדכ麊欽噟ְְָה涪欰ׅ ⡎׃ծך1א1אחGUI⡲ךכ鳞ְ(㹋꿀涸ז堣腉) ֽוؒٝآص،ח׃ַדֹזְ⡲噟כ幾׃ְ(頾蚚鯪幾) ֿדSpreadSheetUIה׃ג崞欽ׅ What is GAS?
• SpreadSheet♳דⰅ⸂ؿؓ٦ي⡲䧭ׅ • GASדⳢ椚鎸鶢 • fetchדAPI〨ֻ ֿד♧菙涸זCRUDז֮玎䏝㹋植דֹתׅկ ٔحثזGUI⡲儗䟝㹀׃גGASך噟سً؎ٝחꟼׅ皘 䨽כⴓꨄ׃גֶֻה獳嗂ָ知⽃חדֹגكة٦ What
is GAS?
GAS with TypeScript
@google/clasp GoogleAppsScriptCLIד盖椚דֹخ٦ٕ push׃deploy׃ GitHubדا٦أ؝٦س盖椚׃זָٗ٦ٕؕד涪דֹ 1.5.0⟃꣬TypeScriptח㼎䘔׃ GAS with TypeScript
@types/google-apps-script TypeScriptぢֽך㘗㹀纏 ֿד㘗ך䛷䜋「ֽזָGoogleApsScript穈鴥ؔـآؑ ؙز䪔ִ GAS with TypeScript
Appendix
Environment GASך㹋遤橆㞮חאְג javaךjs㹋遤橆㞮ד֮Rhinoד㹋鄲ׁגְשְ 鑐׃חE4X圓俑㹋遤ׅהדֹׯֲ Appendix
var xml = <items>! <item name="item-1/">! <item name="item-2"/>! </items>!
javascript1.7 • const • ꂁⰻ⺪ • ⴓⶴ➿Ⰵ ך〢ְ➬圫ָ⢪ִ植遤ך➬圫ה✼䳔䚍ָזְ ꂁⰻ⺪חꟼ׃גכֲ㶷㖈׃זְ Appendix
Summary SpreadSheetفٗزة؎فה׃גⵃ欽ֿׅהד UIך銲⟝㹀纏ָ״姻然חװװׅז UIְׂ㹋鄲ׅ㜥さח剑ⴱַזח⢪ְװֻׅ ءٝفٕח㹋鄲דֹ״ֲחկ 堣腉ׅفٗزة؎ف知僒ח㹋鄲דֹךד葺ְדׅկ