GASでスプレッドシート書き出し

Transcript

1. GASͰεϓϨουγʔτॻ͖ग़͠

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

3. 1 ձࣾ঺հɾࣗݾ঺հ

4. 4 ࣗݾ঺հ ◆໊લ ླ໦ ޹೭(Suzuki Takayuki) ◆ࣗݾ঺հ ɾ1990೥ɺਆಸ઒ݝੜ·Εɻ ɾࣾձਓʹͳ͔ͬͯΒɺϓϩάϥϛϯάΛ࢝ΊΔɻ ɾ2015೥ʹϑϧεϐʔυʹೖࣾ͠ɺ2017೥ʹϑϦʔϥ

   ϯεΛ΍ͬͨޙʹ2017೥11݄ʹԭೄͰىۀɻ ◆झຯ ίεϓϨɺԻָϥΠϒɺϚϥιϯେձʹग़Δɺ໺ٿ؍ ઓ ◆Twitter @kanbo0605

5. Copyright Re:Build.inc All Rights Reserved. 1.ձࣾ঺հ ◆ձ໊ࣾ גࣜձࣾRe:Build ◆ॅॴ ԭೄݝԭೄࢢதԝ̍ஸ໨̍̒−̕

   ◆ࣄۀ಺༰ ɾࣗࣾWEBαʔϏεͷاըɾ։ൃɻ ɾडୗ։ൃ ◆ࣾһ 5໊ ◆ΤϯδχΞͷಇ͖ํ ϦϞʔτϫʔΫՄೳͳࣗ༝ͳಇ͖ํΛਪ঑ͯ͠·͢ʂ

6. 2 ػೳཁ݅

7. 7 ɾαʔϏε໊ Gooleݕࡧπʔϧ ɾγεςϜ֓ཁ - εΫϨΠϐϯά - GASͰεϓϨουγʔτ ॻ͖ग़͠ ͳͲ

   ɾ࢖͏ٕज़ ݴޠ : PHP,JavaScript ϑϨʔϜϫʔΫ: laravel5,GASͳͲ

8. 8 ཁ݅ ɾݕࡧػೳ - ෳ਺ΩʔϫʔυҰׅݕࡧػೳ - ෳ਺Ωʔϫʔυొ࿥ ɾCSVμ΢ϯϩʔυ ɾCSVϑΥʔϚοτμ΢ϯϩʔυ ɾαΠτ෼ੳػೳ

   ɾεϓϨοτγʔτʹॻ͖ग़͢ɻ

9. 3 GASͱ͸

10. 1 0 Google Apps Scriptͱ͸ Google Apps Scriptͱ͸ɺͦͷ໊ͷ௨ΓGoogle͕ఏڙΛ͍ͯ͠ΔɺJavaScriptͷεΫϦϓτ؀ڥͷ͜ͱͰ ͢ɻ ࢀߟɿhttps://blog.codecamp.jp/google-apps-script-merit

    ▪࢖͑ΔαʔϏεͷྫ - Gmail - εϓϨουγʔτ - GoogleϚοϓ - GoogleΧϨϯμʔ - Google຋༁ ্هͰड़΂ͨαʔϏεΛɺ͞Βʹ۩ମతͳγνϡΤʔγϣϯͰར༻͢Δͱ͢Ε͹ɺҎԼͷΑ͏ʹͳΓ·͢ɻ ΧϨϯμʔʹ͋Δ༧ఆΛຖே8࣌ʹϝʔϧ΁ૹ৴͢Δ εϓϨουγʔτʹӳޠͰೖྗ͞Ε͍ͯΔ಺༰Λ຋༁͢Δ εϓϨουγʔτΛcsvܗࣜʹม׵ͨ͠΋ͷΛϝʔϧͰૹ৴͢Δ Ϛοϓ্ʹεϓϨουγʔτͷॅॴҰཡΛϓϩοτ͢Δ

11. 4 DEMO

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

13. 1 3 γʔτͷྫ

14. 1 4 ίʔυҰ෦(GAS)

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

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

17. 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/