GASでスプレッドシート書き出し

by Takayuki

Slide 1

Slide 1 text

GASͰεϓϨουγʔτॻ͖ग़͠

Slide 2

Slide 2 text

1 ձࣾ঺հɾࣗݾ঺հ 2 ػೳཁ݅ Agenda 3 GASͱ͸ 4 DEMO

Slide 3

Slide 3 text

1 ձࣾ঺հɾࣗݾ঺հ

Slide 4

Slide 4 text

4 ࣗݾ঺հ ◆໊લ ླ໦ ޹೭(Suzuki Takayuki) ◆ࣗݾ঺հ ɾ1990೥ɺਆಸ઒ݝੜ·Εɻ ɾࣾձਓʹͳ͔ͬͯΒɺϓϩάϥϛϯάΛ࢝ΊΔɻ ɾ2015೥ʹϑϧεϐʔυʹೖࣾ͠ɺ2017೥ʹϑϦʔϥ ϯεΛ΍ͬͨޙʹ2017೥11݄ʹԭೄͰىۀɻ ◆झຯ ίεϓϨɺԻָϥΠϒɺϚϥιϯେձʹग़Δɺ໺ٿ؍ ઓ ◆Twitter @kanbo0605

Slide 5

Slide 5 text

Slide 6

Slide 6 text

2 ػೳཁ݅

Slide 7

Slide 7 text

7 ɾαʔϏε໊ Gooleݕࡧπʔϧ ɾγεςϜ֓ཁ - εΫϨΠϐϯά - GASͰεϓϨουγʔτ ॻ͖ग़͠ ͳͲ ɾ࢖͏ٕज़ ݴޠ : PHP,JavaScript ϑϨʔϜϫʔΫ: laravel5,GASͳͲ

Slide 8

Slide 8 text

8 ཁ݅ ɾݕࡧػೳ - ෳ਺ΩʔϫʔυҰׅݕࡧػೳ - ෳ਺Ωʔϫʔυొ࿥ ɾCSVμ΢ϯϩʔυ ɾCSVϑΥʔϚοτμ΢ϯϩʔυ ɾαΠτ෼ੳػೳ ɾεϓϨοτγʔτʹॻ͖ग़͢ɻ

Slide 9

Slide 9 text

3 GASͱ͸

Slide 10

Slide 10 text

1 0 Google Apps Scriptͱ͸ Google Apps Scriptͱ͸ɺͦͷ໊ͷ௨ΓGoogle͕ఏڙΛ͍ͯ͠ΔɺJavaScriptͷεΫϦϓτ؀ڥͷ͜ͱͰ ͢ɻ ࢀߟɿhttps://blog.codecamp.jp/google-apps-script-merit ■࢖͑ΔαʔϏεͷྫ - Gmail - εϓϨουγʔτ - GoogleϚοϓ - GoogleΧϨϯμʔ - Google຋༁ ্هͰड़΂ͨαʔϏεΛɺ͞Βʹ۩ମతͳγνϡΤʔγϣϯͰར༻͢Δͱ͢Ε͹ɺҎԼͷΑ͏ʹͳΓ·͢ɻ ΧϨϯμʔʹ͋Δ༧ఆΛຖே8࣌ʹϝʔϧ΁ૹ৴͢Δ εϓϨουγʔτʹӳޠͰೖྗ͞Ε͍ͯΔ಺༰Λ຋༁͢Δ εϓϨουγʔτΛcsvܗࣜʹม׵ͨ͠΋ͷΛϝʔϧͰૹ৴͢Δ Ϛοϓ্ʹεϓϨουγʔτͷॅॴҰཡΛϓϩοτ͢Δ

Slide 11

Slide 11 text

4 DEMO

Slide 12

Slide 12 text

1 2 શମߏ੒ ϑϩϯτΤϯυ εΫϨΠϐϯά αʔόαΠυ LaravelͷίϚϯ υΛ࣮ߦ GASͷAPIΛୟ͘ goutte

Slide 13

Slide 13 text

1 3 γʔτͷྫ

Slide 14

Slide 14 text

1 4 ίʔυҰ෦(GAS)

Slide 15

Slide 15 text

1 5 ίʔυҰ෦(LaravelίϚϯυ)

Slide 16

Slide 16 text

1 6 ίʔυҰ෦(LaravelίϚϯυ)

Slide 17

Slide 17 text

1 7 ࢀߟจݙ https://qiita.com/soundTricker/items/1bcfc5c9e80d29a7ae4b https://qiita.com/niiyz/items/30fab61adc4fcf87b98a https://qiita.com/zaburo/items/45d748ae3966bf08323f https://www.virment.com/google-drive-api-activate/ https://qiita.com/chihiro/items/20a54865c15966e807ee https://dev.classmethod.jp/smartphone/iphone/google_app_script_spreadsheet_ios/