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
440
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
3k
Parsing Javascript
brn
13
9.1k
JSON & Object Tips
brn
1
440
CA 1Day Youth Bootcamp for Frontend LT
brn
0
870
Modern TypeScript
brn
2
770
javascript - behind the scene
brn
3
710
tc39 proposals
brn
0
830
プロダクト開発とTypeScript
brn
8
2.8k
React-Springでリッチなアニメーション
brn
1
650
Other Decks in Programming
See All in Programming
クリーンアーキテクチャから見る依存の向きの大切さ
shimabox
3
710
Amazon S3 TablesとAmazon S3 Metadataを触ってみた / 20250201-jawsug-tochigi-s3tables-s3metadata
kasacchiful
0
170
Honoのおもしろいミドルウェアをみてみよう
yusukebe
1
210
一休.com のログイン体験を支える技術 〜Web Components x Vue.js 活用事例と最適化について〜
atsumim
0
600
ファインディLT_ポケモン対戦の定量的分析
fufufukakaka
0
780
CI改善もDatadogとともに
taumu
0
120
PHPのバージョンアップ時にも役立ったAST
matsuo_atsushi
0
150
メンテが命: PHPフレームワークのコンテナ化とアップグレード戦略
shunta27
0
170
仕様変更に耐えるための"今の"DRY原則を考える / Rethinking the "Don't repeat yourself" for resilience to specification changes
mkmk884
5
1.6k
お前もAI鬼にならないか?👹Bolt & Cursor & Supabase & Vercelで人間をやめるぞ、ジョジョー!👺
taishiyade
7
4.1k
苦しいTiDBへの移行を乗り越えて快適な運用を目指す
leveragestech
0
710
第3回関東Kaggler会_AtCoderはKaggleの役に立つ
chettub
3
1.1k
Featured
See All Featured
We Have a Design System, Now What?
morganepeng
51
7.4k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
666
120k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
21
2.5k
Building a Modern Day E-commerce SEO Strategy
aleyda
38
7.1k
Adopting Sorbet at Scale
ufuk
74
9.2k
Making Projects Easy
brettharned
116
6k
Large-scale JavaScript Application Architecture
addyosmani
511
110k
Designing for humans not robots
tammielis
250
25k
Thoughts on Productivity
jonyablonski
69
4.5k
Imperfection Machines: The Place of Print at Facebook
scottboms
267
13k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
248
1.3M
A better future with KSS
kneath
238
17k
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ְׂ㹋鄲ׅ㜥さח剑ⴱַזח⢪ְװֻׅ ءٝفٕח㹋鄲דֹ״ֲחկ 堣腉ׅفٗزة؎ف知僒ח㹋鄲דֹךד葺ְדׅկ