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

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

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

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׾ְׂ㹋鄲ׅ׷㜥さח剑ⴱַ׵׉׸ז׶ח⢪ְװֻׅ ءٝفٕח㹋鄲דֹ׷״ֲחկ 堣腉ׅ׷فٗزة؎ف׾知僒ח㹋鄲דֹ׷ךד葺ְדׅկ