[B! GAS] kuchitamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kuchitama id:kuchitama

GASã«é–¢ã™ã‚‹kuchitamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Google Apps Scriptã§ã¯ã¦ãªãƒ–ãƒã‚°ã®é€±é–“PVæ•°ã‚’ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã—ã¦ã€Spread Sheetã¸æ›¸ãè¾¼ã‚€ã¨ã“ã‚ã¾ã§è‡ªå‹•åŒ–ã—ã¦ã¿ãŸ - ã‚€ã«ãˆã‚‹ç‰§å ´
æ¦‚è¦ 11æœˆã‹ã‚‰ã‚«ãƒƒã‚¯ã•ã‚“( id:kakku22 )ã®ãƒ–ãƒã‚°ãƒ¡ãƒ³ã‚¿ãƒ¼ã‚’å—ã‘ã¦ã„ã¾ã™ã€‚ ãã“ã§KPIã¨ã—ã¦ã€ Twitterãƒ•ã‚©ãƒãƒ¯ãƒ¼æ•° ãƒ–ãƒã‚°é€±é–“PV ãƒ–ãƒã‚°èªè€…ç™»éŒ²æ•° ã®3ã¤ã‚’Google Spread Sheetã«è¨˜éŒ²ã—ã¦ã„ã¾ã™ã€‚ æ¯Žé€±æœ«ã«è¨˜éŒ²ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€æ‰‹ä½œæ¥ã§ã‚„ã‚‹ä½œæ¥ã§ã¯ãªã„ãªï¼ã¨æ€ã„ç«‹ã£ãŸãŸã‚ã€Google Apps Script(ä»¥ä¸‹GAS)ã‚’åˆ©ç”¨ã—ã¦è‡ªå‹•åŒ–ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ãƒ–ãƒã‚°é€±é–“PVã®ã¿è¨˜äº‹ã«ã—ã¾ã™ã€‚ GASã§ãƒã‚°ã‚¤ãƒ³å‡¦ç† ã¯ã¦ãªãƒ–ãƒã‚°ã®é€±é–“PVã¯ãƒã‚°ã‚¤ãƒ³ã—ãŸã‚ã¨ã§ãªã„ã¨è¦‹ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“ã€‚ ãã“ã§ã€ã¯ã¦ãªãƒ–ãƒã‚°ã®ãƒã‚°ã‚¤ãƒ³ã§åˆ©ç”¨ã•ã‚Œã‚‹URLã«å¯¾ã—ã¦ã€POSTã§ãƒã‚°ã‚¤ãƒ³æƒ…å ±ã‚’é€ã‚Šã¾ã™ã€‚ ã¯ã¦ãªãƒ–ãƒã‚°ã®ãƒã‚°ã‚¤ãƒ³ã§åˆ©ç”¨ã™ã‚‹URLã¯ã“ã“ https://www.hatena.ne.jp/login ãã‚Œã§ã¯ã“ã®URLã«å¯¾ã—ã¦POSTãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’é€ã‚Šã¾ã™ã€‚ va
kuchitama 2018/11/27
GAS

ã‚¹ãƒ—ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°

è‡ªå‹•åŒ–
ãƒªãƒ³ã‚¯
Google Apps Scriptsã§TypescriptãŒè¶…ç°¡å˜ã«ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸï¼ - ã‚¢ã‚¯ãƒˆã‚¤ãƒ³ãƒ‡ã‚£é–‹ç™ºè€…ãƒ–ãƒã‚°
morishitaã§ã™ã€‚ Cloud Functions ã¨ä¸¦ã¶(?)Google ã®ã‚µãƒ¼ãƒãƒ¬ã‚¹ãª JavaScript å®Ÿè¡Œç’°å¢ƒã¨ã„ãˆã° Google Apps Scriptsï¼ˆGASï¼‰ã§ã™ã€‚ GAS ã£ã¦ã‚ã® Excel ã§è¨€ã† VB ã‚¹ã‚¯ãƒªãƒ—ãƒˆç’°å¢ƒã®ã‚ˆã†ãªã‚‚ã®ã§ã—ã‚‡ã†ï¼Ÿã€€ã¨æ€ã£ãŸã‚ãªãŸï¼ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ãã®èªè˜ãŒå¤‰ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ä»¥å‰ã¯ä½¿ã„ã‚„ã™ã„ã¨ã¯è¨€ã„é›£ã‹ã£ãŸGASã§ã™ãŒã€æœ€è¿‘ã¯ä½¿ã„ã‚„ã™ããªã£ã¦ãã¾ã—ãŸã€‚ ã¨ã„ã£ã¦ã‚‚ã€GAS è‡ªä½“ãŒã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã•ã‚ŒãŸã®ã§ã¯ãªãå‘¨è¾ºãƒ„ãƒ¼ãƒ«ãŒæ•´å‚™ãŒé€²ã¿é–‹ç™ºãƒ»é‹ç”¨ã—ã‚„ã™ã„çŠ¶æ³ãŒæ•´ã£ã¦ããŸã‹ã‚‰ã§ã™ã€‚ ãã—ã¦ã€ãªã‚“ã¨æœ€è¿‘Typescript ã§ã¨ã¦ã‚‚å®Ÿè£…ã—ã‚„ã™ããªã£ãŸã®ã§ã€ãã‚Œã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ google/clasp ä»¥å‰ã® GAS ã¯ Web ã‚¨ãƒ‡ã‚£ã‚¿ä¸Šã§ã—ã‹å®Ÿè£…ã§ããšã€ã‚³ãƒ¼ãƒ‰ã‚’ VCS ã§ç®¡ç†ã™ã‚‹ã“ã¨ã‚‚ã¾ã¾ãªã‚‰ãªã„çŠ¶æ³ã§ã—ãŸãŒã€Google
kuchitama 2018/09/11
typescript

google

GAS
ãƒªãƒ³ã‚¯
Google Apps Scriptã®ã‚³ãƒ¼ãƒ‰ã‚’Githubã§ç®¡ç†ã§ãã‚‹ã€ŒGoogle Apps Script Github ã‚¢ã‚·ã‚¹ã‚¿ãƒ³ãƒˆã€ãŒä¾¿åˆ©ã™ãŽã‚‹ - ã‚¿ãƒ€ã‚±ãƒ³ã®Enjoy Tech
ã“ã‚“ã«ã¡ã¯! ã‚¿ãƒ€ã‚±ãƒ³(@tadaken3)ã§ã™ã€‚ Google Apps Scriptã®ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã¦ã€ã¡ã‚‡ã£ã¨å›°ã‚‹ã®ãŒã‚³ãƒ¼ãƒ‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã§ã™ã€‚ Google Apps Scriptã¯ãƒ–ãƒ©ã‚¦ã‚¶ã§é–‹ç™ºã—ã¦ã„ãã“ã¨ã«ãªã‚Šã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ãŒã§ãã¾ã›ã‚“ã€‚ã¨ãã«è¤‡æ•°äººã§é–‹ç™ºã—ã¦ã„ã‚‹ã¨ããªã‚“ã‹ã¯ã€èª°ãŒã©ã®ã‚ˆã†ã«ç·¨é›†ã‚’ã—ãŸã®ã‹ã‚ã‹ã‚‰ãšã€ä½•ãŒæœ€æ–°ç‰ˆãªã®ã‹ã‚ã‹ã‚‰ãªããªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’ç®¡ç†ã§ããªã„ã¨å¿ƒç´°ã„ã§ã™ã€‚ ãã“ã§GASã®ã‚³ãƒ¼ãƒ‰ã‚’Githubä¸Šã§ç®¡ç†ã§ãã‚‹Chromeæ‹¡å¼µã®ã€ŒGoogle Apps Script Github ã‚¢ã‚·ã‚¹ã‚¿ãƒ³ãƒˆã€ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ã€ŒGoogle Apps Script Github ã‚¢ã‚·ã‚¹ã‚¿ãƒ³ãƒˆã€ã‚’ä½¿ã†ã¨GASã®ã‚³ãƒ¼ãƒ‰ã‚’æ‰‹è»½ã«Githubã§ç®¡ç†ã§ãã¾ã™ã€‚ ã€ŒGoogle Apps Script Github ã‚¢ã‚·ã‚¹ã‚¿ãƒ³ãƒˆã€ã‚’å°Žå…¥ã™ã‚‹ ãƒªãƒã‚¸ãƒˆ
kuchitama 2017/11/20
github

Google Apps Script

GAS
ãƒªãƒ³ã‚¯
DMMè‹±ä¼šè©±ã§ã‚‚Googleã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼é€£æº - æ‚ªã‚ãŒããƒ—ãƒã‚°ãƒ©ãƒžãƒ¼
æ¥æœˆã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã«è¡Œã£ã¦ãã¾ã™ é‹è‰¯ãWWDCã®æŠ½é¸ã«å½“ãŸã‚Šã¾ã—ã¦ã€æ¥æœˆã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã«1é€±é–“ã»ã©è¡Œãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã§ã™ãŒã€ä¸å®‰ãªã®ã¯åƒ•ã®è‹±èªžåŠ›ã€‚ã€‚ã‹ãªã‚Šæ®‹å¿µãªæ„Ÿã˜ãªã®ã§å°‘ã—ã§ã‚‚ã‚„ã£ã¦ãŠã“ã†ã¨æœ€è¿‘æµè¡Œã‚Šã®Skypeè‹±ä¼šè©±ã«ç™»éŒ²ã—ã¦ã¿ã¾ã—ãŸã€‚ å«ãŒæ—¢ã«ãƒ¬ã‚¢ã‚¸ãƒ§ãƒ–ã‚’ã‚„ã£ã¦ã„ã‚‹ã®ã§åƒ•ã¯ãã‚Œä»¥å¤–ã§æŽ¢ã—ã¦ã¿ã‚‹ã“ã¨ã«ã€‚ã¨æ€ã£ãŸã¾ã§ã¯è‰¯ã„ã®ã§ã™ãŒã€å°‘ã—èª¿ã¹ã¦ã¿ã‚‹ã¨100ç¤¾ä»¥ä¸Šå‡ºã¦ãã¦ã‚‚ã†ä½•ãŒãªã‚“ã ã‹ã€‚ã€‚ã“ã‚Œã¯ã„ã‹ã‚“ã¨æ€ã„ã€ãˆã„ã‚„ã£ã§ä¸€ç•ªäººæ°—ã®DMMè‹±ä¼šè©±ã«æ±ºã‚ã¾ã—ãŸã€‚ Skypeè‹±ä¼šè©±ã¯ä½•å¹´ã‹å‰ã«è©¦ã—ãŸã“ã¨ãŒã‚ã£ãŸã®ã¨ã€å«ãŒæ¯Žæ—¥ã‚„ã£ã¦ã‚‹ã®ã§ç‰¹ã«ã‚ã‹ã‚‰ãªã„ã“ã¨ã¯ãªãã€ã¨ã„ã†ã‹çµå±€ã¯ãŸã Skypeã§è©±ã™ã ã‘ã§ã™ã‹ã‚‰ãã€‚ã‚ã¨ã¯å…ˆç”Ÿã¨é›»æ³¢ã®è³ªã˜ã‚ƒãªã„ã‹ãªã¨ã€‚ DMMè‹±ä¼šè©±ã¸ã®å”¯ä¸€ã®ä¸æº€ ãªã®ã§ãã®ã¸ã‚“ã«å¯¾ã—ã¦ã¯ç‰¹ã«è¨€ã†ã“ã¨ã¯ãªã„ã®ã§ã™ãŒã€ãŸã ã²ã¨ã¤ä¸æº€ãªã®ãŒã€ŒGoogleã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼é€£æºã€ãŒãªã„ã“ã¨ï¼
kuchitama 2016/10/06
ãŠï¼ã„ã„ãƒãƒƒã‚¯ï¼ï¼

Google

GAS
ãƒªãƒ³ã‚¯
1