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

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

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

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

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

Other Decks in Programming

Transcript

  1. amazing
    Google
    Apps
    Script

    View full-size slide

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

    View full-size slide

  3. What is GAS?

    View full-size slide

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

    View full-size slide

  5. Specification

    View full-size slide

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

    View full-size slide

  7. Use SpreadSheet as UI

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  10. GAS with TypeScript

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  14. var xml = !
    !
    !
    !

    View full-size slide

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

    View full-size slide

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

    View full-size slide