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
430
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
9k
JSON & Object Tips
brn
1
420
CA 1Day Youth Bootcamp for Frontend LT
brn
0
830
Modern TypeScript
brn
2
760
javascript - behind the scene
brn
3
700
tc39 proposals
brn
0
810
プロダクト開発とTypeScript
brn
8
2.8k
React-Springでリッチなアニメーション
brn
1
630
Other Decks in Programming
See All in Programming
数十万行のプロジェクトを Scala 2から3に完全移行した
xuwei_k
0
500
情報漏洩させないための設計
kubotak
5
1.2k
DevFest - Serverless 101 with Google Cloud Functions
tunmise
0
130
アクターシステムに頼らずEvent Sourcingする方法について
j5ik2o
6
660
コンテナをたくさん詰め込んだシステムとランタイムの変化
makihiro
1
180
良いユニットテストを書こう
mototakatsu
11
3.5k
Асинхронность неизбежна: как мы проектировали сервис уведомлений
lamodatech
0
1.2k
ドメインイベント増えすぎ問題
h0r15h0
2
530
MCP with Cloudflare Workers
yusukebe
2
260
php-conference-japan-2024
tasuku43
0
400
KubeCon + CloudNativeCon NA 2024 Overviewat Kubernetes Meetup Tokyo #68 / amsy810_k8sjp68
masayaaoyama
0
290
週次リリースを実現するための グローバルアプリ開発
tera_ny
1
630
Featured
See All Featured
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
33
2.7k
Scaling GitHub
holman
459
140k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
28
9.2k
Designing for humans not robots
tammielis
250
25k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
191
16k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
171
50k
The World Runs on Bad Software
bkeepers
PRO
66
11k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
59k
Stop Working from a Prison Cell
hatefulcrawdad
267
20k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
251
21k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
27
1.5k
VelocityConf: Rendering Performance Case Studies
addyosmani
327
24k
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ְׂ㹋鄲ׅ㜥さח剑ⴱַזח⢪ְװֻׅ ءٝفٕח㹋鄲דֹ״ֲחկ 堣腉ׅفٗزة؎ف知僒ח㹋鄲דֹךד葺ְדׅկ