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

02886e95c50822b9aa2552da1e518491?s=47 Takayuki
January 20, 2019

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

スクレイピングとGASでスプレッドシート書き出しの話

02886e95c50822b9aa2552da1e518491?s=128

Takayuki

January 20, 2019
Tweet

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/