Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Google Apps Scriptの良さについてしゃべる資料
Search
Taketoshi Aono(青野健利 a.k.a brn)
September 21, 2018
Programming
2
420
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)
document.write再考
brn
6
2.9k
Parsing Javascript
brn
12
8.9k
JSON & Object Tips
brn
1
370
CA 1Day Youth Bootcamp for Frontend LT
brn
0
770
Modern TypeScript
brn
2
740
javascript - behind the scene
brn
3
670
tc39 proposals
brn
0
770
プロダクト開発とTypeScript
brn
8
2.8k
React-Springでリッチなアニメーション
brn
1
590
Other Decks in Programming
See All in Programming
Piniaの現状と今後
waka292
2
520
Successful with Signals: 3 Rules for Your Architecture
manfredsteyer
PRO
0
140
フロントエンドの現在地とこれから
koba04
10
4.7k
CSC509 Lecture 06
javiergs
PRO
0
130
GPU Hash Table | レイトレ合宿10
yknishidate
0
330
レガシーな Android アプリのリアーキテクチャ戦略
oidy
1
160
ML-прайсинг_на_Lamoda__вошли_и_вышли__приключение_на_20_минут__Слава_Цыганков.pdf
lamodatech
0
400
The Efficiency Paradox and How to Save Yourself and the World
hollycummins
0
230
2024-10-01 dev2next - Observability for Modern JVM Applications
jonatan_ivanov
1
140
Re:proS_案内資料
rect
0
170
cgroup v2 support in Kubeadm
kentatada
0
220
今日で分かる!カスタムコップの作り方
krpk1900
2
270
Featured
See All Featured
Ruby is Unlike a Banana
tanoku
96
11k
Learning to Love Humans: Emotional Interface Design
aarron
272
40k
Large-scale JavaScript Application Architecture
addyosmani
510
110k
Building a Modern Day E-commerce SEO Strategy
aleyda
38
6.9k
Code Review Best Practice
trishagee
64
17k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
28
9k
Fontdeck: Realign not Redesign
paulrobertlloyd
81
5.2k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
664
120k
Scaling GitHub
holman
458
140k
YesSQL, Process and Tooling at Scale
rocio
167
14k
The Straight Up "How To Draw Better" Workshop
denniskardys
232
130k
Practical Orchestrator
shlominoach
186
10k
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ְׂ㹋鄲ׅ㜥さח剑ⴱַזח⢪ְװֻׅ ءٝفٕח㹋鄲דֹ״ֲחկ 堣腉ׅفٗزة؎ف知僒ח㹋鄲דֹךד葺ְדׅկ