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

スクレイピングと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/