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
390
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.6k
Parsing Javascript
brn
12
7.3k
JSON & Object Tips
brn
1
300
CA 1Day Youth Bootcamp for Frontend LT
brn
0
690
Modern TypeScript
brn
2
680
javascript - behind the scene
brn
3
610
tc39 proposals
brn
0
660
プロダクト開発とTypeScript
brn
8
2.7k
React-Springでリッチなアニメーション
brn
1
500
Other Decks in Programming
See All in Programming
Micro Frontends for Java Microservices - Utah JUG 2024
mraible
PRO
1
110
PostmanでAPIの動作確認が楽になった話
h455h1
0
190
MetricKitで予期せぬ終了を検知する話 / Detect unexpected termination with MetricKit
nekowen
1
200
デフォルトにして至高、RubyMineの大好きな所
ruzia
0
1k
Build Apps for iOS, Android & Desktop in 100% Kotlin With Compose Multiplatform (mDevCamp 2024)
zsmb
0
480
Ruby Pattern Matching
bkuhlmann
0
930
Docker_OSS_ホスティング入門
satokoki645
0
100
2 週間で Twitter Bot を作ってみた
contour_gara
0
800
Goのmultiple errorsについて (2024年4月版)
syumai
4
1.2k
Ruby Function Composition
bkuhlmann
1
340
Anthropic Cookbook のおすすめレシピ
schroneko
7
1.3k
Ruby GitHub Packages
bkuhlmann
0
650
Featured
See All Featured
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
8
3.4k
WebSockets: Embracing the real-time Web
robhawkes
59
7k
Web Components: a chance to create the future
zenorocha
306
41k
Six Lessons from altMBA
skipperchong
22
3k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
275
13k
Intergalactic Javascript Robots from Outer Space
tanoku
266
26k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
358
22k
Design by the Numbers
sachag
274
18k
Building Effective Engineering Teams - LeadDev
addyosmani
32
1.9k
RailsConf 2023
tenderlove
9
570
What the flash - Photography Introduction
edds
64
11k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
21
1.9k
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ְׂ㹋鄲ׅ㜥さח剑ⴱַזח⢪ְװֻׅ ءٝفٕח㹋鄲דֹ״ֲחկ 堣腉ׅفٗزة؎ف知僒ח㹋鄲דֹךד葺ְדׅկ