Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

Avatar for Takayuki Takayuki PRO
January 20, 2019

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

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

Avatar for Takayuki

Takayuki PRO

January 20, 2019
Tweet

More Decks by Takayuki

Other Decks in Technology

Transcript

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

    ◆ࣄۀ಺༰ ɾࣗࣾWEBαʔϏεͷاըɾ։ൃɻ ɾडୗ։ൃ ◆ࣾһ 5໊ ◆ΤϯδχΞͷಇ͖ํ ϦϞʔτϫʔΫՄೳͳࣗ༝ͳಇ͖ํΛਪ঑ͯ͠·͢ʂ
  2. 7 ɾαʔϏε໊ Gooleݕࡧπʔϧ ɾγεςϜ֓ཁ - εΫϨΠϐϯά - GASͰεϓϨουγʔτ ॻ͖ग़͠ ͳͲ

    ɾ࢖͏ٕज़ ݴޠ : PHP,JavaScript ϑϨʔϜϫʔΫ: laravel5,GASͳͲ
  3. 1 0 Google Apps Scriptͱ͸ Google Apps Scriptͱ͸ɺͦͷ໊ͷ௨ΓGoogle͕ఏڙΛ͍ͯ͠ΔɺJavaScriptͷεΫϦϓτ؀ڥͷ͜ͱͰ ͢ɻ ࢀߟɿhttps://blog.codecamp.jp/google-apps-script-merit

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