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

Slide 1

Slide 1 text

amazing Google Apps Script

Slide 2

Slide 2 text

Name @brn (ꫬꅿ⨳ⵃ) Occupation ؿٗٝزؒٝسؒٝآص،٥ط؎ذ؍ـؒٝآص، Company Cyberagent ،سذؙأةآؔ AI Messenger OSS Contributor of V8 About http://info.b6n.ch

Slide 3

Slide 3 text

What is GAS?

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

Speciﬁcation

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

Use SpreadSheet as UI

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

GAS with TypeScript

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

Appendix

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

var xml = ! ! ! !

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

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