Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Google Apps Scriptの良さについてしゃべる資料

Cf337591106e061c317b6e103c80e961?s=47 Taketoshi Aono(青野健利 a.k.a brn)
September 21, 2018
Programming
2
310

Google Apps Scriptの良さについてしゃべる資料

GASでUI作ったり claspで管理したり
GASの実行環境についてとか

Cf337591106e061c317b6e103c80e961?s=128

Taketoshi Aono(青野健利 a.k.a brn)

September 21, 2018
Tweet

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
Cf337591106e061c317b6e103c80e961?s=48 brn
0
280
Modern TypeScript
Cf337591106e061c317b6e103c80e961?s=48 brn
2
540
javascript - behind the scene
Cf337591106e061c317b6e103c80e961?s=48 brn
3
460
tc39 proposals
Cf337591106e061c317b6e103c80e961?s=48 brn
0
480
プロダクト開発とTypeScript
Cf337591106e061c317b6e103c80e961?s=48 brn
8
2.4k
React-Springでリッチなアニメーション
Cf337591106e061c317b6e103c80e961?s=48 brn
1
420
javascript internationalization API
Cf337591106e061c317b6e103c80e961?s=48 brn
0
500
How V8 executes WASM
Cf337591106e061c317b6e103c80e961?s=48 brn
3
1.3k
memory_in_javascript.pdf
Cf337591106e061c317b6e103c80e961?s=48 brn
0
660

Other Decks in Programming

See All in Programming
プロダクトの成長とSREと
5a9fb3b80c517e51e4e95a27b63c6a67?s=48 takuyatezuka
0
120
SAM × Dockerでサーバーレス開発が超捗った話
Cd029ecf0f2e807120fcf05161ce84b8?s=48 yu_yukk_y
1
420
段階的な技術的負債の解消方法.pdf
41e5cd2b99a8e7c84f91a8137c8be3ed?s=48 ko2ic
2
950
10歳の minne から、これから長く続くプロダクトを作るすべての人へ
Dd21eeb4e9dc073f37239571b85fd2ab?s=48 tsumichan
9
3.7k
ECサイトの脆弱性診断をいい感じにやりたい/OWASPKansaiNight_LT1_220727
341ac9f717b3904d6674784c0fcd9cf2?s=48 owaspkansai
0
300
Efficient UI testing in Android
2b0404a5db1a74f01bf3bf94d142e28c?s=48 alexzhukovich
2
130
2022 - COSCUP - 打造高速 Ruby 專案開發流程
888339de9e7a88688b6acb30d33e66cd?s=48 elct9620
0
100
YATA: collaborative documents and how to make them fast
009174d68aa95ae39054afa749013f78?s=48 horusiath
1
170
Recap CDN, Edge, WebAssembly | ワインと鍋.js#1
33ef4c1ebe619115b552db9a9f9a3509?s=48 sadnessojisan
2
1.2k
Lookerとdbtの共存
739b3e6644385d832834f6d4db498642?s=48 ttccddtoki
0
670
MLOps勉強会_リアルタイムトラフィックのサーバレスMLOps基盤_20220810
7771ba477a3bee861bc62012a143bffe?s=48 strsaito
1
450
夕食断食にTRY!/for-lt-12th
82492720940b57cec5072e190213ba3a?s=48 pachikuriii
0
250

Featured

See All Featured
Thoughts on Productivity
A16eb159db895e3b01d3dc95767ad595?s=48 jonyablonski
44
2.4k
Creatively Recalculating Your Daily Design Routine
48c098b6579220a67a6ba949be6e4b5a?s=48 revolveconf
207
10k
Rebuilding a faster, lazier Slack
C0b42577cfc2b321be3474618107e933?s=48 samanthasiow
62
7.3k
Mobile First: as difficult as doing things right
0fe2973fa8d27d96547e43322341183a?s=48 swwweet
213
7.6k
The Art of Programming - Codeland 2020
719435d98d452de7ac367c828266cf01?s=48 erikaheidi
32
11k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
C44e1f7e22c3f23cff7bc130871047ef?s=48 eileencodes
119
28k
10 Git Anti Patterns You Should be Aware of
Dafc4723e9a1c067796c0fec6f509774?s=48 lemiorhan
638
52k
Ruby is Unlike a Banana
6804f1775cb4babfcc3851298566fbce?s=48 tanoku
91
9.3k
Streamline your AJAX requests with AmplifyJS and jQuery
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
127
8.5k
The Language of Interfaces
Fde6c3a50ca518a909ef35c22c0ee0e4?s=48 destraynor
148
21k
The Pragmatic Product Professional
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
19
3.1k
Easily Structure & Communicate Ideas using Wireframe
0c6fd6a08d0f898159cda7cafcacf07f?s=48 afnizarnur
181
15k

Transcript

  1. amazing Google Apps Script

  2. Name @brn (ꫬꅿ⨳ⵃ) Occupation ؿٗٝزؒٝسؒٝآص،٥ط؎ذ؍ـؒٝآص، Company Cyberagent ،سذؙأةآؔ AI Messenger

    OSS Contributor of V8 About http://info.b6n.ch

  3. What is GAS?

  4. GoogleAppScriptךֿה Google SpreadSheetהַד⢪ִ׷ javascript׾Googleךؙٓؐس橆㞮ד䩛鯪ח㹋遤דֹ׷ ExcelךVBA׫׋ְזװא What is GAS?

  5. Specification

  6. •  ES5湱䔲ךjavascriptָ鎸鶢דֹ׷ •  Webـٓؐؠ♳דرغحؚ〳腉 •  fetchד㢩鿇ٔا٦أהך鸬䵿׮〳腉 •  㹋遤穠卓׾⥂㶷׃גⱄⵃ欽דֹ׷ •  暴㹀ך勴⟝ד㹋遤ׇׁ׷ֿה׮〳腉(儗꟦הַ)

    •  6ⴓ꟦דة؎ي،ؐز What is GAS?

  7. Use SpreadSheet as UI 

  8. 䒦爡ךفٗتؙزדכ麊欽噟⹡ְָ׹ְ׹ה涪欰ׅ׷ ⡎׃ծ׉ך1א1אחGUI׾⡲׷ךכ鳞ְ(㹋꿀涸ז堣腉׌׏׋׶) ׌ֽוؒٝآص،ח׃ַדֹזְ⡲噟כ幾׵׃׋ְ(頾蚚鯪幾) ׉ֿדSpreadSheet׾UIה׃ג崞欽ׅ׷ What is GAS?

  9. •  SpreadSheet♳דⰅ⸂ؿؓ٦ي׾⡲䧭ׅ׷ •  GASדⳢ椚׾鎸鶢 •  fetchדAPI׾〨ֻ ֿ׸ד♧菙涸זCRUDז׵֮׷玎䏝㹋植דֹתׅկ ٔحثזGUI׾⡲׷儗׾䟝㹀׃גGASך噟⹡سً؎ٝחꟼׅ׷皘 䨽כⴓꨄ׃גֶֻה獳嗂ָ知⽃חדֹגكة٦ What

    is GAS?

  10. GAS with TypeScript

  11. @google/clasp GoogleAppsScript׾CLIד盖椚דֹ׷خ٦ٕ push׃׋׶deploy׃׋׶ GitHubדا٦أ؝٦س׾盖椚׃זָ׵ٗ٦ٕؕדꟚ涪דֹ׷ 1.5.0⟃꣬TypeScriptח㼎䘔׃׋ GAS with TypeScript

  12. @types/google-apps-script TypeScriptぢֽך㘗㹀纏 ֿ׸ד㘗ך䛷䜋׾「ֽזָ׵GoogleApsScript穈׫鴥׫ؔـآؑ ؙز׾䪔ִ׷ GAS with TypeScript

  13. Appendix

  14. Environment GASך㹋遤橆㞮חאְג javaךjs㹋遤橆㞮ד֮׷Rhinoד㹋鄲ׁ׸גְ׷׏שְ 鑐׃חE4X圓俑׾㹋遤ׅ׷הדֹ׍ׯֲ Appendix

  15. var xml = <items>! <item name="item-1/">! <item name="item-2"/>! </items>!

  16. javascript1.7 •  const •  ꂁ⴨ⰻ⺪ •  ⴓⶴ➿Ⰵ ך〢ְ➬圫ָ⢪ִ׷植遤ך➬圫ה✼䳔䚍ָזְ ꂁ⴨ⰻ⺪חꟼ׃גכ׮ֲ㶷㖈׃זְ Appendix

  17. Summary SpreadSheet׾فٗزة؎فה׃גⵃ欽ׅ׷ֿהד UIך銲⟝㹀纏ָ״׶姻然חװ׶װׅז׏׋ UI׾ְׂ㹋鄲ׅ׷㜥さח剑ⴱַ׵׉׸ז׶ח⢪ְװֻׅ ءٝفٕח㹋鄲דֹ׷״ֲחկ 堣腉ׅ׷فٗزة؎ف׾知僒ח㹋鄲דֹ׷ךד葺ְדׅկ