google apps scriptでもモダン開発したい

by kaidouji85

Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

Google Apps Scriptͱ͸ google spread sheetͳͲͰಠࣗεΫϦϓτΛ ࣮ߦͰ͖Δػೳ ཁ͸ΤΫηϧϚΫϩͷgoogle spread sheet൛ Ѫশ͸GAS ݴޠ͸java script

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

node-google-apps-script

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

Ϗϧυ Ϗϧυ js σϓϩΠ js node-google-apps-script σϓϩΠ·ͰͷྲྀΕ

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

՝୊΋ଟʑ͋Γ·͕͢

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

͝ਗ਼ௌ͋Γ͕ͱ͏ ͍͟͝·ͨ͠

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

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