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

Transcript

1. 1.

   amazing Google Apps Script

2. 2.

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

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

   What is GAS?
   

4. 4.

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

5. 5.

   Specification
   

6. 6.

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

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

   Use SpreadSheet as UI
   

8. 8.

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

9. 9.

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

   is GAS?
10. 10.

    GAS with TypeScript
    

11. 11.

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

12. 12.

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

13. 13.

    Appendix
    

14. 14.

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

15. 15.

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

16. 16.

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

17. 17.

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