[B! Google Apps Script] akira_maruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

akira_maru id:akira_maru

Google Apps Scriptã«é–¢ã™ã‚‹akira_maruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

${{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}}

GASé«˜é€ŸåŒ–ã®ã‚¹ã‚¹ãƒ¡ - Nealle Developer's Blog
GASé«˜é€ŸåŒ–ã®ã‚¹ã‚¹ãƒ¡ ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚ã‚µã‚¯ã‚»ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒãƒ¼ãƒ ã®å¢—ç”°ã§ã™ã€‚ ä»Šå¹´ã®8æœˆã«å…¥ç¤¾ã—ã¦æ—©4ã‹æœˆãŒçµŒã¡ã¾ã—ãŸã€‚ å…¥ç¤¾ã‚¨ãƒ³ãƒˆãƒªã‚‚å…¬é–‹ã—ã¦ã„ã¾ã™ã®ã§è‰¯ã‘ã‚Œã°è¦‹ã¦ã„ã£ã¦ãã ã•ã„ note.nealle.com æœ€è¿‘é€±4ã§ã‚«ãƒ¬ãƒ¼ã°ã£ã‹é£Ÿã£ã¦ã¾ã™ã€‚ ç¾Žå‘³ã—ã„ã‚«ãƒ¬ãƒ¼ã®å¾ŒãŒã‘ã‚¹ãƒ‘ã‚¤ã‚¹ã‚„ã‚½ãƒ¼ã‚¹ãªã©ã‚ã‚Œã°ãœã²æ•™ãˆã¦ã„ãŸã ããŸã„...ï¼ GASã«ã¤ã„ã¦ ã¿ãªã•ã‚“æ™®æ®µã‹ã‚‰æ¥å‹™ã§GAS(Google Apps Script)åˆ©ç”¨ã•ã‚Œã¦ã¾ã™ã§ã—ã‚‡ã†ã‹ã€‚ GASã¯çŸ¥ã£ã¦ã®é€šã‚Šã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ä¸è¦ã§ä½¿ãˆã€Googleã‚µãƒ¼ãƒ“ã‚¹ï¼ˆGoogle Sheetsã€Gmailã€Driveãªã©ï¼‰ã¸ã®èªè¨¼ãŒæ¨™æº–ã§çµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã‚‹éžå¸¸ã«ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚æ‰±ã„ã‚„ã™ãã€æ¥å‹™åŠ¹çŽ‡åŒ–ã®æ‰‹æ®µã¨ã—ã¦åºƒãæ´»ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ GASã®ãƒ‡ãƒ¡ãƒªãƒƒãƒˆã¨èª²é¡Œ ãã‚“ãªä¾¿åˆ©ãªGASã§ã™ãŒå¤šãã®åˆ¶é™ãŒå˜åœ¨ã—ã¾ã™ã€‚ ãã®ä¸ã§ã‚‚ä»£è¡¨çš„ãªã‚‚
akira_maru 2024/12/24
Google Apps Script

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
ç¤¾å†…é–‹ç™ºç”¨EC2ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹æ–™é‡‘ã‚’ç¯€ç´„ã—ãŸã„ï½œBlogï½œæ ªå¼ä¼šç¤¾COLSISï¼ˆã‚³ãƒ«ã‚·ã‚¹ï¼‰
ç©ºå‰çµ¶å¾Œã®ã‚©ï¼è¶…çµ¶æ€’æ¶›ã®æ¸…æŽƒå“¡ï¼ GASã‚’æ„›ã—ã€GASã«æ„›ã•ã‚ŒãŸç”·ï¼ ãã†æˆ‘ã“ãã¯ã‚¢ã‚¡ï¼ï¼ï¼æœå¹Œã‚ªãƒ•ã‚£ã‚¹ã‚¥ã‚¥ï¼ï¼æ¸…ï¼æŽƒï¼å“¡ï¼ã‚¸ãƒ£ã‚¡ã‚¹ãƒ†ã‚£ã‚¹ï¼ï¼ ã€Œãƒ”ãƒ³èŠ¸äººã€ã¨ã€Œæ¸…æŽƒå“¡ã€ã®èªžæ„ŸãŒä¼¼ã¦ã„ãŸã›ã„ã§å–ã‚Šä¹±ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ã“ã‚“ã«ã¡ã‚ã‚µãƒ³ã‚·ãƒ£ã‚¤ãƒ³æœå¹Œã‚ªãƒ•ã‚£ã‚¹æ¸…æŽƒå“¡ã§ã™ã€‚ æœ¬æ—¥ã¯å¼Šç¤¾ç¤¾å†…é–‹ç™ºç’°å¢ƒã®ã‚³ã‚¹ãƒˆå‰Šæ¸›æ–½ç–ã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãˆãŒã ç¤¾å†…åˆ©ç”¨ã®EC2é–‹ç™ºç’°å¢ƒã®ç®¡ç†ã€ã¿ãªã•ã‚“ã©ã†ã•ã‚Œã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ ã€Œã›ã£ã‹ãEC2ãªã®ã§ã€ä½¿ã£ã¦ã„ãªã„æ™‚ã¯åœæ¢ã—ã¦ã‚³ã‚¹ãƒˆã‚’æŠ‘ãˆãŸã„ã€‚ã€ ã€Œã—ã‹ã—ãªãŒã‚‰å…¨å“¡ã§AWSã®rootã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’å…±æœ‰ã™ã‚‹ã®ã¯å±é™ºã™ãŽã‚‹ã€‚ã€ ã“ã®ã‚ˆã†ãªãŠæ‚©ã¿ãŒã‚ã‚‹æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ãã£ã¨ã€å…¨ç¤¾å“¡ã«é©åˆ‡ãªãƒãƒªã‚·ãƒ¼ã‚’ä»˜ä¸Žã—ã¦IAMã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ç™ºè¡Œã™ã‚‹ã®ãŒæœ€è‰¯ãªã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚ã‚‹ã®ã ã¨æ€ã„ã¾ã™ã€‚ ã—ã‹ã—ãã®æ–¹é‡ã«ã—ãŸå ´åˆã«ã‚‚â€AWSã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‚’ä½¿ã£ãŸã“ã¨ãŒãªã„ãƒ¡ãƒ³ãƒ
akira_maru 2021/06/25
Google Spreadsheet

AWS

Google Apps Script
ãƒªãƒ³ã‚¯
Google Analyticsã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§å–å¾—ã™ã‚‹ã€å…¥é–€ç·¨ã€‘ï½œand_a
ä¼æ¥ã®Webæ‹…å½“è€…ãªã‚‰æ¯Žæ—¥Google Analyticsã®ãƒ‡ãƒ¼ã‚¿ã‚’ç¢ºèªã—ã¦ã€æ¯Žæœˆãã®æ•°å€¤ã‚’ãƒ¬ãƒãƒ¼ãƒˆåŒ–ã—ã¦æå‡ºã™ã‚‹â€¦ã¨ã„ã£ãŸæ¥å‹™ãŒã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ æ„å¤–ã¨æ™‚é–“ãŒã¨ã‚‰ã‚Œã¦é¢å€’ã§ã™ã‚ˆãã€‚ ãã“ã§Google Apps Scriptã¨Google Analyticsã‚’é€£å‹•ã—ã¦ã€è‡ªå‹•ã§ã‚¢ã‚¯ã‚»ã‚¹è§£æžãƒ‡ãƒ¼ã‚¿ã‚’ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«åæ˜ ã—ã¦ç¢ºèªã‚’ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã¾ãšä»Šå›žã¯ã€ã‚³ãƒ¼ãƒ‰ãƒ¬ã‚¹ã§ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã‚‹åŸºæœ¬çš„ãªAPIé€£æºã®æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ Google Apps Scriptã¨ã¯ ä»Šå›žã¯ã‚³ãƒ¼ãƒ‰ã‚’è¨˜è¼‰ã—ãªã„ã§ãƒ‡ãƒ¼ã‚¿å–å¾—ã‚’ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ãŒã€ã¾ãšã¯Google Apps Scriptï¼ˆä»¥ä¸‹ã€GASï¼‰ã«ã¤ã„ã¦ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚ GASã¨ã¯GoogleãŒé–‹ç™ºã—ã¦ã„ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚Java Scriptã¨ã„ã†è¨€èªžã‚’ãƒ™ãƒ¼ã‚¹ã«ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ ç°¡å˜ã«è¨€ãˆã°ã€ã‚¨ã‚¯ã‚»ãƒ«VBAã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆç‰ˆã¨è€ƒ
akira_maru 2021/04/12
Google Analytics

Google Spreadsheet

Google Apps Script
ãƒªãƒ³ã‚¯
Google Apps Script ã¯ä½•ãŒå¼·ãã¦ã©ã‚“ãªã¨ãã«ä½¿ã†ã¹ãã‹ãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ã¾ã¨ã‚ã¦ã¿ãŸ
ã¯ã˜ã‚ã«Google Apps Script ã¯ç„¡æ–™ã§è‰²ã‚“ãªã“ã¨ãŒå®Ÿç¾ã§ãã‚‹ãŸã‚ã€ã¤ã„ã¤ã„ã€Œå…¨ã¦ GAS ã§ã‚„ã£ã¡ã‚ƒãŠã†ã€ã¿ãŸã„ãªè©±ã«ãªã‚ŠãŒã¡ã§ã™ã€‚Google Apps Script ã‚‚ä¸‡èƒ½ã§ã¯ãªã„ã®ã§ã€å¼·ã¿ãƒ»å¼±ã¿ã‚’ç†è§£ã—ãŸä¸Šã§ä»–ã®é¸æŠžè‚¢ã¨æ¯”è¼ƒã—ã¦ä½¿ã†ã®ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ Google Apps Script ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ 2â€“30 å€‹ä½œã£ã¦ããŸä¸ã§ã€è‡ªåˆ†ãªã‚Šã®ãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã“ã®å†…å®¹ã¯ Cloud Next â€™18 in Tokyo ã§ç™»å£‡ã—ãŸã¨ãã®å†…å®¹ã‚’å«ã‚“ã§ã„ã¾ã™ã€‚ã“ã®ç™»å£‡ã‹ã‚‰åŠå¹´ä»¥ä¸ŠçµŒã£ãŸã®ã§ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆéƒ¨åˆ†ã‚‚ä»¥ä¸‹ã«ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚ Google Apps Script ã®å¼·ã¿ãƒ»å¼±ã¿ã¾ãšã€å¼·ã¿ã¨å¼±ã¿ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ å¼·ã¿ 1. Google Apps ã® API ã‚’ç°¡å˜ã«å‘¼ã³å‡ºã™ã“ã¨ãŒã§ãã‚‹ä¸€ç•ªã®å¼·ã¿ã¯ã“ã‚Œã ã¨æ€ã„ã¾ã™ã€‚Google Apps Scrip
akira_maru 2019/06/20
Google Apps Script
ãƒªãƒ³ã‚¯
Google Apps Script ãƒãƒ³ã‚ºã‚ªãƒ³è³‡æ–™ #GoogleAppsScript
ã“ã®è³‡æ–™ã®èª¬æ˜Ž 2018/10/04 ã« ã‚°ãƒãƒ¼ãƒ“ã‚¹ ã§è¡Œã£ãŸ ç¬¬ 1 å›ž Google Apps Script (GAS) ãƒãƒ³ã‚ºã‚ªãƒ³ @éº¹ç”º ã®ãƒãƒ³ã‚ºã‚ªãƒ³ç”¨è³‡æ–™ã§ã™ã€‚ä»¥ä¸‹ã®æµã‚Œã«æ²¿ã£ã¦ãƒãƒ³ã‚ºã‚ªãƒ³ã‚’é€²ã‚ã¦ã„ãã¾ã™ã€‚ æ‰‹é †ã¯ç´°ã‹ãæ›¸ã„ã¦ã„ã¾ã™ã®ã§ã€ç¤¾å†…å¤–ã§æ˜¯éžæµç”¨ã—ã¦ãã ã•ã„ï¼ ãƒãƒ³ã‚ºã‚ªãƒ³ã¯ä»¥ä¸‹ã®è¨˜äº‹ã®æ„Ÿã˜ã§é€²ã‚ã¾ã—ãŸï¼ ãƒãƒ¥ãƒ¼ã‚¿ãƒ¼å°‘äººæ•°ã§ã‚‚å›žã›ã‚‹ï¼Slack ã‚’é§†ä½¿ã—ãŸãƒãƒ³ã‚ºã‚ªãƒ³å‹‰å¼·ä¼šã®ã‚„ã‚Šæ–¹ ãƒãƒ³ã‚ºã‚ªãƒ³ã‚’ã‚¹ãƒ ãƒ¼ã‚ºã«è¡Œã†ãŸã‚ã« Chrome æŽ¨å¥¨ Chrome æ‹¡å¼µã® JSONView å…¥ã‚Œã¦ãŠãã¨ Good! æ„å›³ã—ãªã„ã‚¨ãƒ©ãƒ¼å¯¾ç– GAS ã‚’ãƒãƒ¼ã‚«ãƒ«é–‹ç™ºã§é–‹ç™ºã—ãŸã„æ–¹ã¯ã“ã¡ã‚‰ã‚’å‚ç…§ ãƒãƒ³ã‚ºã‚ªãƒ³ç”¨ã® Slack ã« JOIN ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ Google Apps Script ã¨ã¯ å…¬å¼ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ« Your first script Gmail to Spreadsheet Form
akira_maru 2018/10/11
Google Apps Script
ãƒªãƒ³ã‚¯
Google Apps Script ã§ã§ãã‚‹ã“ã¨ã‚’5ã¤ã®ãƒ¡ã‚½ãƒƒãƒ‰ã¨é–¢æ•°ã‹ã‚‰è€ƒãˆãŸ
Google Apps Scriptï¼ˆGASï¼‰ã¯ã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆãƒ¬ãƒ™ãƒ«ã§Webé€šä¿¡ãªã©ãŒã§ãã€ãƒžãƒ¼ã‚±ãƒƒã‚¿ãƒ¼ã§ã‚‚ä½¿ã„ã“ãªã™ã¨ã¨ã¦ã‚‚ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã«ãªã‚Šã¾ã™ã‚ˆãã€‚ ã“ã‚“ã«ã¡ã¯ã€GASå¤§å¥½ãã‚«ã‚°ã‚¢ï¼ã§ã™ã€‚æœ€è¿‘ã¯ã‚‚ã£ã±ã‚‰ãƒ„ãƒ¼ãƒ«ã¯GASè£½ãŒå¤šããªã£ã¦ã„ã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€ãƒžãƒ¼ã‚±ã‚¿ãƒ¼å‘ã‘ã«2017å¹´12æœˆæ™‚ç‚¹ã®Google Apps Script ã§ã§ãã‚‹ã“ã¨ã‚’ã€ãƒ¡ã‚½ãƒƒãƒ‰ã‚„é–¢æ•°ã‹ã‚‰è€ƒãˆã¦ã¿ã¾ã—ãŸã€‚ é–¢é€£è¨˜äº‹ ï¼žï¼žURLä¸€è¦§ã‹ã‚‰ã‚¿ã‚¤ãƒˆãƒ«ã‚’ä¸€æ‹¬DLã™ã‚‹Google Apps Script ï¼žï¼žGoogle Apps Script ã¨APIã‚’ä½¿ã£ãŸè‡ªå‹•ãƒ¡ãƒ¼ãƒ«é…ä¿¡ã‚·ã‚¹ãƒ†ãƒ ä½œæˆ ï¼žï¼žç°¡å˜ã«Googleã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã‹ã‚‰æ•°å€¤ã‚’å–ã‚Šè¾¼ã‚ã‚‹Appsã‚¹ã‚¯ãƒªãƒ—ãƒˆï¼ˆä¿®æ£ç‰ˆï¼‰ Google Apps Scriptã¯æ¥å‹™ã«å½¹ç«‹ã¤ Google Apps Scriptï¼ˆGASï¼‰ã¨ã¯ GoogleãŒæä¾›ã—ã¾ã™ãƒ—ãƒã‚°ãƒ©ãƒ ç’°å¢ƒã§ã™ã€‚é–‹ç™ºã¨å®Ÿ
akira_maru 2018/04/16
Google Apps Script
ãƒªãƒ³ã‚¯
GAS ãƒ“ã‚®ãƒŠãƒ¼ãŒ GAS ã‚’ä½¿ã„ã“ãªã™ãŸã‚ã«çŸ¥ã‚‹ã¹ãã“ã¨ 10 é¸ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
akira_maru 2018/04/04
Google Apps Script
ãƒªãƒ³ã‚¯
Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§SEOã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã®æ¤œç´¢ã‚µã‚¸ã‚§ã‚¹ãƒˆã‚’ã•ãã£ã¨å–å¾—ã™ã‚‹æ–¹æ³•
Googleãªã©æ¤œç´¢ã‚µã‚¸ã‚§ã‚¹ãƒˆã‹ã‚‰ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã®ãƒ’ãƒ³ãƒˆã‚’å¾—ã‚‹ã“ã¨ã¯å¤šã„ã§ã™ã‚ˆãã€‚ãã®ã‚µã‚¸ã‚§ã‚¹ãƒˆã‚’Google Apps Scriptï¼ˆGASï¼‰ã§ã‚‚å–å¾—ã§ãã¾ã™ã€‚ Googleã‚µã‚¸ã‚§ã‚¹ãƒˆã‚’èª¿ã¹ã‚‹æ–¹æ³• Google Apps Scriptã§ã¯ã€æ¨™æº–ã§httpé€šä¿¡ã‚’ã™ã‚‹é–¢æ•°ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹ã®GIFã‚¢ãƒ‹ãƒ¡ã®ã‚ˆã†ã«ã€ã‚»ãƒ«ã«ãã®é–¢æ•°ã‚’è¨˜è¿°ã™ã‚‹ã ã‘ã§è‡ªå‹•çš„ã«æ¤œç´¢ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚’æ‹¾ã£ã¦ãã¦ãã‚Œã¾ã™ã€‚ IMPORTXML()é–¢æ•° IMPORTXML()ã¯ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‹ã‚‰XMLã‚’å–å¾—ã™ã‚‹é–¢æ•°ã§ã™ã€‚å…¬å¼ã®ãƒ˜ãƒ«ãƒ—ã«ã¯ã€Wikipediaã‹ã‚‰Aã‚¿ã‚°ã®ãƒªãƒ³ã‚¯ã‚’ã²ã£ã±ã£ã¦ãã‚‹ã‚³ãƒ¼ãƒ‰ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ IMPORTXML("https://en.wikipedia.org/wiki/Moon_landing", "//a/@href") Googleã‚µã‚¸ã‚§ã‚¹ãƒˆã®ä»•çµ„ã¿ Googleã‚µã‚¸ã‚§ã‚¹ãƒˆã¯ã€æ¤œç´¢çª“ã¸ã®å…¥åŠ›ã‚’æ¤œçŸ¥
akira_maru 2018/03/05
Google Apps Script
ãƒªãƒ³ã‚¯
https://cohki0305.com/programing/awesome-google-apps-script
akira_maru 2018/02/27
Google Apps Script
ãƒªãƒ³ã‚¯
Google Apps Scriptã®ç½ 7é¸ ï½ž2æ—¥ã§çµ‚ã‚ã‚‹ãŠï¼ã£ã¦ä»•äº‹ãŒ10æ—¥ä»¥ä¸Šã‹ã‹ã£ãŸãŠâ€¦ï½ž - Qiita
Ateam Hikkoshi Samurai Inc. Advent Calendar 2017ã€€19æ—¥ç›®ã§ã™ã€‚ æœ¬æ—¥ã¯ã‚¨ã‚¤ãƒãƒ¼ãƒ å¼•è¶Šã—ä¾ä¸é€”å…¥ç¤¾2å¹´ç›®ã€è‡ªç§°çˆ†é€ŸWebã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®åŠ è—¤ãŒæ‹…å½“ã—ã¾ã™ï¼ ã¿ãªã•ã‚“Google Apps Scriptæ›¸ã„ã¦ã„ã¾ã™ã‹ï¼Ÿ ã‚ã£ã¡ã‚ƒä¾¿åˆ©ã ã‚ˆããƒ¼ï¼ã‚¨ã‚¯ã‚»ãƒ«ã®ä¸Šä½äº’æ›ã˜ã‚ƒãªã„ï¼Ÿã£ã¦äººãŒè¦‹ãŒã¡ãªåœ°ç„ã®ã‚ˆã†ãªç½ ã‚’ å®Ÿä½“é¨“ã‚’ç”¨ã„ã¤ã¤ã€ã„ãã¤ã‹ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ã“ã‚Œã‹ã‚‰ã‚„ã£ã¦ã¿ã‚ˆãƒ¼ï¼ã£ã¦äººã‚‚å¿…èªã®å†…å®¹ã¨ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ ã‚¿ã‚¤ãƒˆãƒ«ã®æ„å‘³ã¯åƒ•ã®æ•¬æ„›ã™ã‚‹@keki ã•ã‚“ã‹ã‚‰ ã€Žã“ã®ä»•äº‹ãªã‚“ã ã‘ã©ã‚ã¨2æ—¥ãã‚‰ã„ã§çµ‚ã‚ã‚‹ã‹ã‚‰å¼•ãç¶™ã„ã§ãã‚Œãªã„ï¼Ÿã€ ã£ã¦è¨€ã‚ã‚Œã¦ç€æ‰‹ã—ãŸã‚“ã§ã™ãŒã€å®Ÿè³ª10æ—¥ä»¥ä¸Šã‹ã‹ã£ã¦ã€ã€ŽãããŒï¼ï¼ï¼ï¼ã€ã£ã¦æ€ã£ãŸã®ã§ ã¿ãªã•ã‚“ãŒGoogle Apps Scriptã®é¬¼ç•œã¨ã‚‚å‘¼ã¹ã‚‹ç½ ã«å¼•ã£ã‹ã‹ã£ã¦æ¬²ã—ããªã„ãªãã¨ã„ã†æ°—æŒã¡ã§ã™ã€‚ â€»ãããŒï¼ã£ã¦ã®ã¯@kekiã•ã‚“
akira_maru 2017/12/20
Google Apps Script
ãƒªãƒ³ã‚¯
Google ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ APIã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ã¦Slackã«ãƒã‚¹ãƒˆã™ã‚‹Botã‚’ä½œæˆ - Np-Urã®ãƒ‡ãƒ¼ã‚¿åˆ†æžæ•™å®¤
æœ¬è¨˜äº‹ã¯ã€Slack Advent Calendar 2017ã®6æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ä»¥å‰ã« www.randpy.tokyo ã«ã¦ã€Google Adsenseã®ãƒ‡ãƒ¼ã‚¿ã‚’Slackã«ãƒã‚¹ãƒˆã™ã‚‹Botã‚’ä½œæˆã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ãã®ç¶šç·¨ã¨ã„ã†ã“ã¨ã§ã€Google ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’Slackã«ãƒã‚¹ãƒˆã™ã‚‹Botä½œã‚Šã«æŒ‘æˆ¦ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ã¨ã„ã£ã¦ã‚‚æµã‚Œã¯ã»ã¼å‰å›žã¨åŒæ§˜ã§ã€ä»Šå›žã‚‚GASï¼ˆGoogle Apps Scriptï¼‰ã‚’ä½¿ã„ã¾ã™ã€‚ å®Œæˆå½¢ã¨ã—ã¦ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™ã€‚ Slackã‹ã‚‰GASã¸æƒ…å ±ã‚’ãƒã‚¹ãƒˆã™ã‚‹ GASå´ã§Slackã‹ã‚‰å—ã‘å–ã£ãŸæƒ…å ±ã‚’å…ƒã«ã€Google ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹ Slackã¸æƒ…å ±ã‚’è¿”ã™ ã¨ã„ã£ãŸæµã‚Œã«ãªã‚Šã¾ã™ã€‚ Slash Commandsã®è¨å®šã¾ãšã¯Slash Commandsã®è¨å®šã‚’è¡Œã„ã¾ã™ã€‚ https://slack.com/apps
akira_maru 2017/12/11
Google Analytics

slack

Google Apps Script
ãƒªãƒ³ã‚¯
1