[B! gas] ikosinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ikosin id:ikosin

gasã«é–¢ã™ã‚‹ikosinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

${{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 (GAS) ã§ Slack é€£æºã‚’å®Ÿè£…ã™ã‚‹å‰ã«çŸ¥ã£ã¦ãŠãã¨ã‚ˆã„ 5 ã¤ã®ã“ã¨ - Qiita
Slack é€£æºã€ç‰¹ã«ã¡ã‚‡ã£ã¨ã—ãŸé€šçŸ¥ã‚’ Google Apps Script (GAS) ã‹ã‚‰ã‚„ã‚ŠãŸã„ã¨ã„ã†ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ã¯éžå¸¸ã«ã‚ˆãèžã‹ã‚Œã¾ã™ã€‚æœ¬æ ¼çš„ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å‹•ä½œç’°å¢ƒãªã©ã‚’ç”¨æ„ã™ã‚‹ã“ã¨ãªã Google Workspace (æ—§ G Suite) ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã ã‘ã§ã¡ã‚‡ã£ã¨ã—ãŸè‡ªå‹•åŒ–ã‚’ã§ãã‚‹ã®ã§ã€é‡å®ã—ã¾ã™ã‚ˆãã€‚ ã¡ãªã¿ã« GAS ã®æ£å¼åç§°ã¯ã€ŒGoogle App Scriptã€ã§ã¯ãªãã€ŒGoogle Apps Scriptã€ã§ã™ã€‚ãŸã¾ã«èª¤è¨˜ã‚’è¦‹ã‹ã‘ã¾ã™... Slack é€£æºã§çŸ¥ã£ã¦ãŠãã¨ã‚ˆã„ 5 ã¤ã®ã“ã¨ ã•ã¦ã€æœ¬é¡Œã§ã™ã€‚ Slack ã‚¢ãƒ—ãƒªã‚’ Google Apps Script (GAS) ã§å®Ÿè£…ã™ã‚‹å ´åˆã€ç‰¹ã«ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ãªæ©Ÿèƒ½ã®åˆ©ç”¨ã«ãŠã„ã¦çŸ¥ã£ã¦ãŠãã¹ãåˆ¶ç´„ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ã€ä»¥ä¸‹ã® 5 ã¤ã®ç•™æ„ç‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ãƒã‚°ã®æœ‰åŠ¹åŒ–ãªã© Slack ã‚¢ãƒ—ãƒªé–‹
ikosin 2021/03/16
gas

slack
ãƒªãƒ³ã‚¯
Google Apps Scriptã§ä½¿ã†æƒ…å ±ã¯ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚’åˆ©ç”¨ã—ã‚ˆã†ã€GASã€‘ - ðŸŒ´ officeã®æœ ðŸ¥¥
ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’é–‹ç™ºã—ã¦ã„ã‚‹ã¨ã€ä¸€æ™‚çš„ãªæƒ…å ±ã‚‚ã—ãã¯æ’ä¹…çš„ãªæƒ…å ±ã‚’ç”¨ã„ã¦æ§˜ã€…ãªå‡¦ç†ã®åˆ†å²ã‚„ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ç”¨ã„ã¦å‡¦ç†ã‚’ç¶šè¡Œã™ã‚‹ã¨ã„ã£ãŸå‡¦ç†ãŒå‡ºã¦ãã¾ã™ã€‚ä¾‹ãˆã°ã€ãƒ¦ãƒ¼ã‚¶æ¯Žã«ã€Œèªè¨¼ã‚’å®Ÿè¡Œã—ãŸçµæžœå¾—ãŸã€Access Tokenã‚’æ ¼ç´ã—ã¦ãŠãã€ã§ã‚ã£ãŸã‚Šã€ãƒ¦ãƒ¼ã‚¶ã®æ°åã‚„å€‹äººæƒ…å ±ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã§ä½¿ã†å›ºå®šçš„ãªå€¤ï¼ˆæ–½è¨åãƒªã‚¹ãƒˆãªã©ã‚’æ ¼ç´ã—ãŸã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®IDãªã©ï¼‰ãªã©ãªã©ã€‚ ã“ã‚Œã‚‰ã®æƒ…å ±ã‚’ã‚¹ã‚¯ãƒªãƒ—ãƒˆå†…ã«ç›´æ›¸ãã ã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£çš„ã«ã¾ãšã‹ã£ãŸã‚Šã€ã¾ãŸå¤‰æ›´ãŒç”Ÿã˜ã‚‹å ´åˆã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ãç›´ã™å¿…è¦ãŒã‚ã£ãŸã‚Šã€‚ã‹ã¨ã„ã£ã¦ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ã‚»ãƒ«ã«ä¿å˜ã¨ã„ã†ã®ã¯ã‚ã¾ã‚Šã«ã‚‚é›‘ã€‚ã¨ã„ã†ã“ã¨ã§ã‚ˆãä½¿ã†ã®ãŒãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚µãƒ¼ãƒ“ã‚¹ã€‚åœ°å‘³ãªæ©Ÿèƒ½ãªã®ã§ã™ãŒã€ã“ã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚’ä½¿ã†äº‹ã§ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ€§ã‚„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å‘ä¸Šãªã©æ§˜ã€…ãªåŠ¹ç”¨ã‚’ã‚‚ãŸã‚‰ã—ã¦ãã‚Œã¾ã™ã€‚ä»Šå›žã¯ã“ã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚µãƒ¼ãƒ“ã‚¹ã‚’è¦‹ã¦ã‚†ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žä½¿ç”¨ã™ã‚‹ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·
ikosin 2019/10/23
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
ikosin 2018/09/10
gas

TypeScript
ãƒªãƒ³ã‚¯
Google Apps Scriptã®æ–°ã—ã„3ã¤ã®æ©Ÿèƒ½ ãã®â‘¢ CLI Tool Clasp - Qiita
ã“ã®è¨˜äº‹ã¯2018/1/11ã«Google Apps Scriptã«æ–°ã—ãè¿½åŠ ã•ã‚ŒãŸ3æ©Ÿèƒ½ã®ç´¹ä»‹è¨˜äº‹ã®3ç•ªç›®ã§ã™ã€‚ https://gsuite-developers.google blog.com/2018/01/three-new-tools-to-help-improve-your.html?m=1 æ–°æ©Ÿèƒ½ Dashboard Apps Script API CLI Tool clasp (ã“ã®è¨˜äº‹ã§ã™) ä¸€ã¤ä¸€ã¤ãŒçµæ§‹ã—ã£ã‹ã‚Šã—ãŸæ©Ÿèƒ½ãªã®ã§è¨˜äº‹ã‚’åˆ†ã‘ã¦èª¬æ˜Žã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯3ã¤ç›®ã®CLI Tool claspã§ã™ã€‚ CLI Tool clasp claspã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®GASå‘ã‘CLIãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ https://github.com/google/clasp CLIä¸Šã‹ã‚‰GASãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«å¯¾ã—ã¦ä»¥ä¸‹ã®æ§˜ãªã“ã¨ãŒè¡Œãªãˆã¾ã™ã€‚ GASãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®æ–°è¦ä½œæˆ GASãƒ—ãƒã‚¸ã‚§
ikosin 2018/06/12
gas
ãƒªãƒ³ã‚¯
GitHub - google/clasp: ðŸ”— Develop Apps Script projects locally.
ðŸ—ºï¸ Develop Locally: clasp allows you to develop your Apps Script projects locally. That means you can check-in your code into source control, collaborate with other developers, and use your favorite tools to develop Apps Script. ðŸ”¢ Manage Deployment Versions: Create, update, and view your multiple deployments of your project. ðŸ“ Structure Code: clasp automatically converts your flat project on sc
ikosin 2018/06/12
gas
ãƒªãƒ³ã‚¯
æ‰‹è»½ã«Google Apps Scriptã®ã‚³ãƒ¼ãƒ‰ã‚’Githubã§ç®¡ç†ã™ã‚‹ | Recruit Jobs TECHBLOG
çµæžœã¨ã—ã¦ã€ã©ã‚Œã‚‚è¦ä»¶ã‚’100%æº€ãŸã™ã“ã¨ã¯ã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ node-google-apps-scriptã¾ã‚ã‚Šã¯Googleã‚‚æŽ¨å¥¨ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ä¸€åº¦IDEä¸Šã§ä¿®æ£ã™ã‚‹ã¨ã€Gitç®¡ç†ã‹ã‚‰å¤–ã‚Œã‚‹ã“ã¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ å…¨ã¦ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’ãƒãƒ¼ã‚«ãƒ«ã§é–‹ç™ºãƒ»ç®¡ç†ã™ã‚Œã°è‰¯ã„ã‘ã‚Œã©ã‚‚ã€WebIDEã®ä¾¿åˆ©ã•ã¯ã‚„ã¯ã‚Šæ¨ã¦ãŒãŸã„ã¨ã“ã‚â€¦ã€‚ ãã“ã§ä»¥å‰é–‹ç™ºã—ãŸLambdaã®GitHubåŒæœŸç”¨ã®Chromeæ‹¡å¼µã«ã€GASãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã‚ã‚‹ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’æŒã£ã¦æ¥ã‚Œã°ã€åŒæœŸå‘¨ã‚Šã¯ã™ãã§ãã‚‹ã®ã§ã¯ã¨æ€ã„ã€ãã®æ–¹é‡ã§Chromeæ‹¡å¼µã®é–‹ç™ºã‚’å§‹ã‚ã¾ã—ãŸã€‚ ãã—ã¦ã€ã§ããŸã‚‚ã®ã¯ã“ã¡ã‚‰ã«ãªã‚Šã¾ã™ï¼š Chromeæ‹¡å¼µï¼š Google Apps Script Github ã‚¢ã‚·ã‚¹ã‚¿ãƒ³ãƒˆ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰: GitHub åŸ·ç†æ™‚ç‚¹ã§ã¯ãƒªãƒªãƒ¼ã‚¹ã‹ã‚‰ï¼‘ãƒ¶æœˆã»ã©çµŒã£ã¦ã„ã¾ã—ã¦ã€ç‰¹ã«å®£ä¼ã—ã¦ã¯ã„ãªã„ã‚‚ã®ã®ã€ãƒ¦ãƒ¼ã‚¶ãŒç€å®Ÿã«å¢—ãˆã¦ã„ã¾ã™
ikosin 2018/06/12
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 ã‚¢ã‚·ã‚¹ã‚¿ãƒ³ãƒˆã€ã‚’å°Žå…¥ã™ã‚‹ ãƒªãƒã‚¸ãƒˆ
ikosin 2018/06/12
gas
ãƒªãƒ³ã‚¯
Google Spreadsheet ã‚’ç°¡æ˜“ Webã‚µãƒ¼ãƒãƒ¼ã¨ã—ã¦å‹•ã‹ã—ã¦ã€æ‰‹è»½ã«WebHookã‚’å—ã‘å–ã‚‹æ–¹æ³• - Qiita
å¤–éƒ¨ã®ã‚µãƒ¼ãƒ“ã‚¹ã‹ã‚‰ã®é€šçŸ¥ã‚’ WebHookã§å—ã‘å–ã£ã¦ã¡ã‚‡ã£ã¨ã—ãŸå‡¦ç†ã‚’ã—ãŸã„ã“ã¨ã£ã¦ãŸã¾ã«ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ ãŸã¨ãˆã°ã€ã‚¢ãƒ—ãƒªã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒã‚°ã‚’è§£æžã™ã‚‹Fabricã® Crashlytics ã«ã¯ã€æ–°ã—ã„ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãŒç™ºç”Ÿã—ãŸã‚Šç‰¹å®šã®é–¾å€¤ã‚’è¶…ãˆã‚‹ã¨ WebHookã§é€šçŸ¥ã—ã¦ãã‚Œã‚‹ã€ã¤ã¾ã‚Šç‰¹å®šã® URL ã«POSTã‚’ç™ºè¡Œã—ã¦ãã‚Œã‚‹æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã‚’ä¸Šæ‰‹ãä½¿ã†ã¨ã€ä¸‹ã®å›³ã®ã‚ˆã†ã«ã€Œæ–°ã—ã„ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãŒç™ºç”Ÿã—ãŸã‚‰ Backlogãªã©ã®ãƒã‚±ãƒƒãƒˆç®¡ç†ã‚µãƒ¼ãƒ“ã‚¹ã«è‡ªå‹•ç™»éŒ²ã€ã¨ã„ã£ãŸã“ã¨ãŒã§ããã†ã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“Crashlyticsã‹ã‚‰ Backlogã®APIã¯ç›´æŽ¥å©ã‘ãªã„ã®ã§ã€ã“ã®ã‚ˆã†ã« WebHookã‚’ä½¿ã£ã¦ã“ã¡ã‚‰ã®ã‚µãƒ¼ãƒã‚’å©ã„ã¦ã‚‚ã‚‰ã„ã€ãã®ã‚µãƒ¼ãƒãŒã‚ã‚‰ãŸã‚ã¦ Backlogã® APIã‚’ä½¿ã£ã¦ãƒã‚±ãƒƒãƒˆã‚’ç™»éŒ²ã™ã‚‹ã€ã¨ã„ã†ã‚ˆã†æ„Ÿã˜ã«ãªã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¯å®Ÿéš›ã®Clashlyticsã®ç®¡ç†ç”»é¢ã§ã™ã€‚WebHoo
ikosin 2018/03/07
å®šæœŸå®Ÿè¡Œã‚‚å‡ºæ¥ã‚‹ã‹ã‚‰ãƒãƒƒãƒã¨ã—ã¦ã‚‚ä½¿ãˆã‚‹

gas
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…ãŒGASã§Slack Botã‚’ã¤ãã£ã¦ã¿ãŸ - CAMPHOR- Tech Blog
ã“ã®è¨˜äº‹ã¯CAMPHOR- Advent Calendar 2015 12æ—¥ç›®ã®æŠ•ç¨¿ã§ã™ã€‚ ã”ã‚ã„ã•ã¤ åˆæŠ•ç¨¿ã«ãªã‚Šã¾ã™ã€‚è¦‹ç¿’ã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®@andoshin11ã§ã™ã€‚ æ™®æ®µã¯æ—…è¡Œä¼šç¤¾ã§åƒã„ã¦ã„ã‚‹ã®ã§ãã¡ã‚‰ã®ãƒªãƒ³ã‚¯ã‚‚è²¼ã£ã¨ãã¾ã™(å®£ä¼) http://meetuskyoto.com ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°åˆå¿ƒè€…ãªã®ã§é–‹ç™ºæ–¹é¢ã®ãƒ¡ã‚¤ãƒ³æ¥å‹™ã«ã¯è²¢çŒ®ã§ããªã„ã®ã§ã™ãŒã€ã¿ã‚“ãªãŒã„ã¤ã‚‚åˆ©ç”¨ã™ã‚‹Slackã‚’æ´»ç”¨ã—ã¦æ¥å‹™ã®åŠ¹çŽ‡åŒ–ãƒ»æ½¤æ»‘åŒ–ã‚’å›³ã‚ŠãŸã„ãªãã¨æ€ã†æ¬¡ç¬¬ã§ã™ã€‚ CAMPHOR- Advent Calendar 2015 6æ—¥ç›®ã®è¨˜äº‹ã§ã‚‚@kakennãŒSlackã®Tipsè¨˜äº‹ã‚’æ›¸ã„ã¦ãã‚Œã¾ã—ãŸãŒã€ä»Šå›žã¯è‡ªåˆ†ã®ã‚ˆã†ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°åˆå¿ƒè€…ã§ã‚‚ã‚µã‚¯ãƒƒã¨å®Ÿè£…ã§ãã‚‹ç°¡æ˜“botã‚’Google Apps Scriptã‚’åˆ©ç”¨ã—ã¦å®Ÿç¾ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Botã‚’æ´»ç”¨ã™ã‚‹æ„ç¾©ã¨ã—ã¦ã¯ æ¥å‹™ã®è‡ªå‹•åŒ– ãã—ã¦ä½•ã‚ˆã‚Šã‚‚ Botã¯ç™’
ikosin 2017/07/13
gas

slack
ãƒªãƒ³ã‚¯
ä»•äº‹ãŒ10å€æ—ã‚‹ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆç¥žé–¢æ•°10 | Tokyo Otaku Mode Blog
ã“ã‚“ã«ã¡ã¯ã€‚Tokyo Otaku Modeã®å®‰å®…ã§ã™ã€‚å…ˆæ—¥ã‹ã‚‰ã€ã¨ã‚ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã‚¸ãƒ§ã‚¤ãƒ³ã—ã¦ã€ä¹…ã€…ã«Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ã‚´ãƒªã‚´ãƒªæ´»ç”¨ã—ã¦ä»•äº‹ã‚’ã—ã¦ã„ã¾ã™ã€‚ãã‚“ãªä¸ã€ã“ã‚Œã¯æƒšã‚ŒãŸï¼ã¨ã„ã†ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ç¥žé–¢æ•°ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ARRAYFORMULAé–¢æ•° ã“ã‚Œã‚’æ´»ç”¨ã—å§‹ã‚ã¦ã‹ã‚‰ã€é–¢æ•°ã‚’ã„ã¡ã„ã¡å…¨éƒ¨ã®è¡Œã«åŸ‹ã‚è¾¼ã‚“ã§ã„ãã“ã¨ãŒã€ãªã‚“ã ã‹ã‚«ãƒƒã‚³æ‚ªãæ„Ÿã˜ã‚‹ãã‚‰ã„ã€ã‚¹ãƒžãƒ¼ãƒˆã§ã‚ªã‚·ãƒ£ãƒ¬ãªé–¢æ•°ã§ã™ã€‚ä¾‹ãˆã°ã€100è¡Œã®VLOOKUPé–¢æ•°ã‚’è¡Œã†ã¨ãã«ã¯ã€ã“ã‚Œã¾ã§ã¯VLOOKUPé–¢æ•°ã‚’1ã¤ä½œã£ã¦ã€ãã‚Œã‚’æ®‹ã‚Š99å€‹ã®è¡Œã«VLOOKUPé–¢æ•°ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã„ãŸã¨æ€ã„ã¾ã™ãŒã€ARRAYFORMULAé–¢æ•°ã‚’ä½¿ã†ã¨ã€ãªã‚“ã¨1å€‹ã®é–¢æ•°ã§100è¡Œåˆ†ã®å€¤ãŒå‡ºåŠ›ã•ã‚Œã¾ã™ã€‚å®Ÿéš›ã«å‹•ä½œã‚‚è»½ããªã‚‹ã®ã§ã‚«ãƒƒã‚³ã‚ˆã•ã¨å®Ÿç”¨æ€§ã‚’å…¼ãå‚™ãˆãŸé–¢æ•°ã§ã™ã€‚é…åˆ—ã«å¯¾å¿œã™ã‚‹é–¢æ•°ã§ã‚ã‚Œã°ã€ã»ã¼ãªã‚“ã§ã‚‚åˆ©ç”¨ã§ãã‚‹ã®ã‚‚å¥½æ„Ÿåº¦ãŒé«˜ã„ã§ã™ã€‚
ikosin 2017/07/04
gas
ãƒªãƒ³ã‚¯
Google Sheets ã®ãƒ‡ãƒ¼ã‚¿ã‚’ JSON å½¢å¼ã§å–å¾—ã™ã‚‹ Web API ã‚’ã‚µã‚¯ãƒƒã¨ä½œã‚‹ - Qiita
ï¼ˆãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã™ã‚‹ Web API ã¯ Google Sheets ã«ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã™ã‚‹ Web API ã‚’ã‚µã‚¯ãƒƒã¨ä½œã‚‹ ã‚’ã”è¦§ãã ã•ã„ï¼‰ Google Sheets ã®ãƒ‡ãƒ¼ã‚¿ã‚’JSON å½¢å¼ã§å–å¾—ã™ã‚‹ Web API ã‚’ã€10åˆ†ãã‚‰ã„ã§ã‚µã‚¯ãƒƒã¨ä½œã‚Šã¾ã™ã€‚ ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ãŒé•·ã„ã®ã§ã€ã‚ãã¾ã§è©¦ä½œç”¨ã¨ã—ã¦ã”åˆ©ç”¨ãã ã•ã„ã€‚ ã‚·ãƒ¼ãƒˆã«ã‚ã‚‹å…¨ã¦ã®æƒ…å ±ã‚’å–å¾—ã™ã‚‹ ã ã£ãŸã‚‰ã€ [ { "title": "TechCrunch Japan", "feed_url": "http://jp.techcrunch.com/feed/" }, { "title": "Engadget Japanese", "feed_url": "http://japanese.engadget.com/rss.xml" } ] ãŒå–å¾—ã§ãã¾ã™ã€‚ æ–°ã—ã„ã‚·ãƒ¼ãƒˆã‚’ä½œã‚‹ https://docs.google.com/sprea
ikosin 2017/05/23
gas
ãƒªãƒ³ã‚¯
LINE Botã‚’ã‚µãƒ¼ãƒãƒ¼ãƒ¬ã‚¹ã§é–‹ç™ºï¼Google Apps Scriptã¨LINE Messaging APIã‚’ä½¿ã£ã¦ãƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆã‚’ä½œã£ã¦ã¿ãŸ - pixiv inside [archive]
ã“ã‚“ã«ã¡ã¯ã€ä»Šå¹´4æœˆã«å…¥ç¤¾ã—ãŸæ–°å’ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®yasuã§ã™ã€‚pixivã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãƒãƒ¼ãƒ ã§PHPã‚’æ›¸ã„ã¦ã„ã¾ã™ã€‚å¥½ããªè¨€èªžã¯Lispã§ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€æœ€è¿‘å¤§æµè¡Œä¸ã®äººå·¥çŸ¥èƒ½ã‚’åˆ©ç”¨ã—ãŸãƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆã®é–‹ç™ºã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆãŒä½œã‚Œã‚‹APIã‚’LINEãŒæä¾› é–‹ç™ºã—ãŸç°¡å˜ãªãƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆã¨ã®ä¼šè©± LINE Botã‚’ä½œã‚‹ãŸã‚ã«å¿…è¦ãªã‚‚ã® Google Apps Script(GAS)ã§ã‚µãƒ¼ãƒãƒ¼ãƒ¬ã‚¹ãªé–‹ç™º è¶…ç°¡å˜ãªã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒã‚’ä½œã£ã¦ã¿ã‚‹ ã•ã£ãããƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆã‚’ä½œã£ã¦ã¿ã‚‹ LINE Messaging APIã¨GASã®é€£æº ãƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆã®åŸºç¤Žï¼šã‚ªã‚¦ãƒ è¿”ã—ã‚’ã•ã›ã¦ã¿ã‚‹ ãƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆã¨ã‚ªã‚¦ãƒ è¿”ã—ã‚’æ¥½ã—ã‚“ã§ã¿ã‚‹ ãƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆã¨ã‚‚ã£ã¨æ¥½ã—ãä¼šè©±ã™ã‚‹ãŸã‚ã«ã€ã„ã‚ã‚“ãªæ©Ÿèƒ½ã‚’è¿½åŠ ã—ã¦ã¿ã‚‹ ç°¡å˜ã«æ‰±ãˆã‚‹å…¨è‡ªå‹•ä¼šè©±APIã‚’ä½¿ã£ã¦é›‘è«‡ã—ã¦ã¿ã‚‹ ãƒãƒ£ãƒƒãƒˆãƒœãƒƒãƒˆã‚’å°‘ã—ä¾¿åˆ©ã«ï¼Wikpediaæ¤œç´¢
ikosin 2016/11/15
gas

Line

bot
ãƒªãƒ³ã‚¯
How to access or call "Send this form to others"?
ikosin 2016/05/24
gas
ãƒªãƒ³ã‚¯
1