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

google apps scriptでもモダン開発したい

E63c0cf4a77b1799e02f97689db83d91?s=47 kaidouji85
August 20, 2016
Technology
0
570

google apps scriptでもモダン開発したい

プリキュアハッカソンのLT資料です。

E63c0cf4a77b1799e02f97689db83d91?s=128

kaidouji85

August 20, 2016
Tweet

More Decks by kaidouji85

See All by kaidouji85
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
91
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
130
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
330
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
110
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
120
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
30
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
93
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
280
E63c0cf4a77b1799e02f97689db83d91?s=48 kaidouji85
0
360

Other Decks in Technology

See All in Technology
19fc8f6113c5c3d86e6176362ff29479?s=48 kanaugust
PRO
0
240
46342ba2b13fb202412adeb6ed13528e?s=48 natsusan
0
200
93a5ee4559a212954cc17f072ae16748?s=48 yukitodate
2
330
F593efb2c199100c8086dbf130c71ffa?s=48 helayoty
0
140
8db3c91c8b3d3e5686f62fbf43c303dd?s=48 satoryu
0
2.4k
D683c1df0b6584c3f1e279ef6c8c04f9?s=48 layerx
1
940
A4d5b3aae2e67f31b513c88c726514c2?s=48 smzksts
0
280
120b74af626c2b23f954926ef68ac5d6?s=48 papix
0
150
Bee82b2f6e75097641a3ba5ce70c2368?s=48 takem001
0
910
19fc8f6113c5c3d86e6176362ff29479?s=48 kanaugust
PRO
0
180
03858bb7b6debdd69ea0531b0f57c612?s=48 con_mame
4
2k
3487ed46845ad0c09d36c3c1c0533ea6?s=48 masakick
0
130

Featured

See All Featured
A415db3ac9e9668acbc1fb36eead84ac?s=48 mthomps
39
2.3k
Ef32e0b1ac5082450dc8c1fca3a26b5c?s=48 cherdarchuk
71
260k
78b475797a14c84799063c7cd073962f?s=48 holman
461
280k
2bb923c57a1fdc3a2eb484bb8d565fd2?s=48 ufuk
56
5.4k
1519587b1a0febb658c36c94f6272b0d?s=48 roundedbygravity
84
7.8k
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
11
1.3k
016edace78ffe826f2348d1e0c504afd?s=48 maggiecrowley
8
430
719435d98d452de7ac367c828266cf01?s=48 erikaheidi
13
4.2k
282d599b414022eba5096510f675b6e2?s=48 chrislema
173
14k
245cee81a9c424266e5e401d844ea881?s=48 lara
16
2.6k
F68cb25ae3e5c2106997454b13b7737d?s=48 brad_frost
156
6.4k
7cbd3f5f922d798cc312eaf596de7ae6?s=48 iamctodd
17
1.8k

Transcript

  1. Google Apps Script 2016/08/20 ஛಺༎հ Ͱ΋Ϟμϯ։ൃ͍ͨ͠

  2. ࣗݾ঺հ ஛಺ɹ༎հ ϓϩάϥϚʔͰ͢ ීஈ͸javascriptɺ java࢖ͬͯ·͢

  3. օ͞Μ͸ Google Apps ScriptΛ ͝ଘ஌Ͱ͔͢ʁ

  4. Google Apps Scriptͱ͸ google spread sheetͳͲͰಠࣗεΫϦϓτΛ ࣮ߦͰ͖Δػೳ ཁ͸ΤΫηϧϚΫϩͷgoogle spread sheet൛

    Ѫশ͸GAS ݴޠ͸java script

  5. ͚Ͳɺதن໛Ҏ্ͷ ։ൃ͸ਏ͍ Google Apps Script͸௒ศར

  6. GASͷ͍͚ͯͳ͍ͱ͜Ζ 1.σϓϩΠ͕͍͢͝໘౗͍͘͞ 2.ϥΠϒϥϦ؅ཧ΋࢖͍ʹ͍͘ 3.ϞδϡʔϧԽͷػೳ͕ऑ͍

  7. GASͷ͍͚ͯͳ͍ͱ͜Ζ 1.σϓϩΠ͕͍͢͝໘౗͍͘͞ 2.ϥΠϒϥϦ؅ཧ΋࢖͍ʹ͍͘ 3.ϞδϡʔϧԽͷػೳ͕ऑ͍ GASʹखܰʹσϓϩΠͰ͖ΔίϚϯυ͸࠷ۙ·Ͱͳ͔ͬͨ ͔ͩΒɺखಈͰσϓϩΠʢίϐϖ͢Δʣ

  8. GASͷ͍͚ͯͳ͍ͱ͜Ζ 1.σϓϩΠ͕͍͢͝໘౗͍͘͞ 2.ϥΠϒϥϦ؅ཧ΋࢖͍ʹ͍͘ 3.ϞδϡʔϧԽͷػೳ͕ऑ͍ ֎෦ϥΠϒϥϦΛऔΓࠐΉํ๏͸ҰԠ͋Δ ͚ͲɺϑΝΠϧ͝ͱʹઃఆ͢Δඞཁ͕Δ

  9. GASͷ͍͚ͯͳ͍ͱ͜Ζ 1.σϓϩΠ͕͍͢͝໘౗͍͘͞ 2.ϥΠϒϥϦ؅ཧ΋࢖͍ʹ͍͘ 3.ϞδϡʔϧԽͷػೳ͕ऑ͍ جຊ͸શ෦άϩʔόϧ ͻͱੲͷjavascriptͱಉ͡໰୊

  10. ͜ΕΛղܾ͢ΔπʔϧΛ ࠷ۙݟ͚ͭ·ͨ͠ ͦΕ͸……

  11. node-google-apps-script

  12. node-google-apps-scriptͱ͸ ϩʔΧϧͷjsΛGASʹσϓϩΠͰ͖Δ Ͱ͖Δͷ͸ͦΕ͚ͩ npmϞδϡʔϧ͔ͩΒgruntɺgulpͱ΋؆୯ʹ
 ࿈ܞͰ͖Δ

  13. ஫ҙ఺ σϓϩΠͰ͖Δͷ͸stand alone script͚ͩ εϓϨουγʔτͷεΫϦϓτʹ௚઀σϓϩΠ
 ͸Ͱ͖ͳ͍ ओཁॲཧΛstand alone scriptʹ੾Γग़ͯ͠ɺ γʔτ͝ͱʹͦΕΛࢀর͢Δߏ੒ʹ͢Δඞཁ͕͋Δ

  14. ޙͷ໰୊͸Ϗϧυπʔϧ Λ࢖͑͹Կͱ͔ͳΔ

  15. Ϗϧυ Ϗϧυ js σϓϩΠ js node-google-apps-script σϓϩΠ·ͰͷྲྀΕ

  16. ͜ΕͰ΋՝୊͕͋Δ 1. GAS͸ιʔεϚοϓ͕࢖͑ͳ͍ 2. GAS͸άϩʔόϧؔ਺୯Ґ͡Όͳ͍ͱσόο άͰ͖ͳ͍

  17. ͜ΕͰ΋՝୊͕͋Δ 1. GAS͸ιʔεϚοϓ͕࢖͑ͳ͍ 2. GAS͸άϩʔόϧؔ਺୯Ґ͡Όͳ͍ͱσόο άͰ͖ͳ͍ Ϗϧυπʔϧ͕ग़ͨ͠ίʔυͰσόοά͢Δ͔͠ͳ͍

  18. ͜ΕͰ΋՝୊͕͋Δ 1. GAS͸ιʔεϚοϓ͕࢖͑ͳ͍ 2. GAS͸άϩʔόϧؔ਺୯Ґ͡Όͳ͍ͱσόο άͰ͖ͳ͍ Ϗϧυπʔϧ͕άϩʔόϧؔ਺ΛӅṭ͢Δ browserifyͳΒgasifyΛ࢖͑͹ղܾͰ͖Δ

  19. ՝୊΋ଟʑ͋Γ·͕͢

  20. ಉ͡ιʔεͳΒ ಉ͡ߏ੒ͷGASΛ ͍ͭ΋ͰσϓϩΠͰ͖Δ

  21. ·ͱΊ node-google-apps-scriptͰGASΛ؆୯ʹ σϓϩΠͰ͖ΔΑ͏ʹͳͬͨ ϞδϡʔϧԽɺϥΠϒϥϦ؅ཧʹ͸ browselifyɺwebpaskͳͲΛ࢖͓͏ ιʔεϚοϓ͸ఘΊ·͠ΐ͏ɺgasifyΛ࢖͑͹ ଟগ͸ϚγʹͳΔ

  22. ͝ਗ਼ௌ͋Γ͕ͱ͏ ͍͟͝·ͨ͠

  23. ࢀߟจݙ ͦͷ1 node-google-apps-script
 https:/ /github.com/danthareja/node- google-apps-script gasify
 https:/ /www.npmjs.com/package/ gasify

  24. ࢀߟจݙ ͦͷ2 Google Apps ScriptͰrequire()ͯ͠ΈΔ
 http:/ /qiita.com/fossamagna/items/ 7c65e249e1e5ecad51ff