[B! googleAppsScript] cyokodogã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

cyokodog id:cyokodog

googleAppsScriptã«é–¢ã™ã‚‹cyokodogã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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+S3ã‚’ä½¿ã£ã¦ã‚µãƒ¼ãƒ“ã‚¹é‹å–¶å‘ã‘è¨å®šãƒ„ãƒ¼ãƒ«ã‚’è¶…çµ¶ç°¡å˜ã«ä½œæˆã™ã‚‹æ–¹æ³• - Qiita
ä¸€è¡Œç›®ã‚’Fieldåã¨ã—ã¦ã€JSONã‚’ç”Ÿæˆã—ã¾ã™ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§ã¯ã€ä¸€å®šã‚µã‚¤ã‚¯ãƒ«ã§S3ä¸Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’åŒæœŸã™ã‚‹ã‚ˆã†ã«ã—ã¦ã€ãã®JSONã‚’ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«çµ„ã¿è¾¼ã¿ã¾ã™ã€‚ ã‚ã‚‹ã„ã¯ã€S3ã®ä»£ã‚ã‚Šã«DynamoDBã«ä¿å˜ã™ã‚‹ã¨ã„ã†ã®ã‚‚ã„ã„ã§ã—ã‚‡ã†ã€‚ã„ãšã‚Œã«ã›ã‚ˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚¹ã‚±ãƒ¼ãƒ«ã—ã¦ã‚‚ã‚ã¾ã‚Šãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å½±éŸ¿ã®å‡ºãªã„æ–¹æ³•ã§ã€ã“ã®JSONã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ æ¨©é™ç®¡ç† ç®¡ç†ãƒ„ãƒ¼ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹äººã‚’ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã‚±ãƒ¼ã‚¹ã®å ´åˆã€IAMã§ãƒªã‚½ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ¨©ã®ç®¡ç†ã¨Google Docsã®å…±æœ‰è¨å®šã®ç®¡ç†ã‚’ã—ã¦ãŠã‘ã°ã€è‡ªç”±ã«ä¼šç¤¾å†…ã§ã®æ¨©é™ä»˜ä¸Žã‚’è¡Œã†ã“ã¨ãŒã§ãã‚‹ã¾ã™ã€‚ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ ãã®ã†ã¡ã€Add-onã¨ã—ã¦å…¬é–‹ã—ãŸã„ã€‚Add-onã®å…¬é–‹ã«ã¯æ‰‹é–“ãŒã‹ã‹ã‚Šãã†ã ã£ãŸã®ã§ã€ä¸€æ—¦ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¨æ‰‹é †ã‚’ã“ã“ã«æ›¸ã„ã¦ãŠãã¾ã™ã€‚ ç®¡ç†ãƒ„ãƒ¼ãƒ«ã«ã—ãŸã„Sp
cyokodog 2014/12/05
aws

googleAppsScript
ãƒªãƒ³ã‚¯
å®šæœŸçš„ã«è²·ã†å¿…è¦ãŒã‚ã‚‹ã‚‚ã®ã‚’ã‚¢ãƒ©ãƒ¼ãƒˆã™ã‚‹ä»•çµ„ã¿ã‚’ä½œã£ãŸ #å®¶åºã‚’æ”¯ãˆã‚‹æŠ€è¡“ - kei-s@ãƒ–ãƒã‚°è‹¦æ‰‹
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯ã€å®¶åºã‚’æ”¯ãˆã‚‹æŠ€è¡“ Advent Calendar 2014 ã®ä¸€æ—¥ç›®ã§ã™ã€‚ ã€Œå®¶åºã‚’æ”¯ãˆã‚‹æŠ€è¡“ Advent Calendarã€ã¨ã¯ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å‹äººãŸã¡ã¨ãŠã—ã‚ƒã¹ã‚Šã—ã¦ã„ã‚‹ã†ã¡ã«ã€å„ã”å®¶åºã®ç”Ÿæ´»ã‚’è±Šã‹ã«ã™ã‚‹ãŸã‚ã«ã—ã¦ã„ã‚‹æŠ€è¡“çš„ãªå·¥å¤«ã‚„ã€ã“ã‚Œã‹ã‚‰ã‚„ã‚ŠãŸã„ã‚¢ã‚¤ãƒ‡ã‚¢ãŒè©±é¡Œã«ä¸ŠãŒã‚‹ã“ã¨ãŒå¤šãã‚ã‚Šã¾ã—ãŸã€‚ãã‚“ãªãªã‹ã€èª°ãŒè¨€ã„å‡ºã—ãŸã‹ã€Žå®¶åºã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰*1ãŒå‡ºã¦ãã¦ã„ã¾ã—ãŸï¼ˆã‚‚ã¡ã‚ã‚“å…ƒãƒã‚¿ã¯ WEB+DB PRESS plusã‚·ãƒªãƒ¼ã‚º ã®ã€Œã€œã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ã§ã™ï¼‰ã€‚ ä»²é–“ã†ã¡ã ã‘ã§ã‚‚é¢ç™½ã„è©±ãŒå‡ºã¦ãã‚‹ã®ã§ã€ã„ã‚ã‚“ãªå®¶åºã®è©±ã‚’èžã„ã¦ã¿ãŸã„ã¨ãŠã‚‚ã„ã€ã›ã£ã‹ã12æœˆãªã®ã§ã€Œå®¶åºã‚’æ”¯ãˆã‚‹æŠ€è¡“ Advent Calendarã€ã¨ã—ã¦ä¸–ã«å•ã†ã¦ã¿ãŸæ¬¡ç¬¬ã§ã™*2ã€‚ ã‚ã‚ŠãŒãŸã„ã“ã¨ã«å…¬é–‹ã‹ã‚‰æ•°æ—¥ã§å…¨æ—¥ç¨‹ãŒåŸ‹ã¾ã‚Šã€ã€Œå®¶åºã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ã¸ã®é–¢å¿ƒã®é«˜ã¾ã‚Šã‚’æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ å®šæœŸçš„ã«è²·ã†å¿…è¦ãŒ
cyokodog 2014/12/02
googleAppsScript
ãƒªãƒ³ã‚¯
Googleãƒ•ã‚©ãƒ¼ãƒ ã§è‡ªå‹•è¿”ä¿¡ã‚·ã‚¹ãƒ†ãƒ ã‚’ã‚µã‚¯ãƒƒã¨ã¤ãã‚‹ (1/4)
Google Apps Scriptï¼ˆä»¥ä¸‹ã€GASï¼‰ã‚’ä½¿ãˆã°ã€Googleã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¡ã‚‡ã£ã¨ã—ãŸæ©Ÿèƒ½ã‚’åŠ ãˆã¦å®Ÿç”¨çš„ãªã‚µãƒ¼ãƒ“ã‚¹ã«ä»•ç«‹ã¦ã‚‰ã‚Œã¾ã™ã€‚ä»Šå›žã¯ã€å•ã„åˆã‚ã›ãƒ•ã‚©ãƒ¼ãƒ ã‚’ç°¡å˜ã«ä½œæˆã§ãã‚‹ã€ŒGoogleãƒ•ã‚©ãƒ¼ãƒ ã€ã‚’ä½¿ã£ã¦ã€å•ã„åˆã‚ã›ãƒ¡ãƒ¼ãƒ«ã¸è‡ªå‹•ã§è¿”ä¿¡ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã‚Šã¾ã™ã€‚ ã€ãƒ•ã‚©ãƒ¼ãƒ ä½œæˆã€‘å•ã„åˆã‚ã›ãƒ•ã‚©ãƒ¼ãƒ ã‚’ä½œã‚‹ Googleãƒ•ã‚©ãƒ¼ãƒ ã¯ã€å•ã„åˆã‚ã›ã‚„ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆãªã©ã®ãƒ•ã‚©ãƒ¼ãƒ ã‚’ç°¡å˜ãªæ“ä½œã§ä½œæˆã§ãã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã™ã€‚ã¾ãšã¯ä¼æ¥ã‚µã‚¤ãƒˆã‚’æƒ³å®šã—ãŸã€ã‚·ãƒ³ãƒ—ãƒ«ãªå•ã„åˆã‚ã›ãƒ•ã‚©ãƒ¼ãƒ ã‚’ä½œæˆã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ 1. https://drive.google.comã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦Googleãƒ‰ãƒ©ã‚¤ãƒ–ã‚’é–‹ãã¾ã™ã€‚ã€Œä½œæˆã€ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã€ã€Œãƒ•ã‚©ãƒ¼ãƒ ã€ã‚’é¸ã‚“ã§ãã ã•ã„ã€‚
cyokodog 2014/04/02
googleDrive

googleAppsScript
ãƒªãƒ³ã‚¯
ä½œæ¥åŠ¹çŽ‡åŒ–ï¼Googleã‚¢ãƒ—ãƒªã‚’1000%æ´»ã‹ã›ã‚‹ã€ŒGoogle Apps Scriptã€ã®å§‹ã‚æ–¹ | æ ªå¼ä¼šç¤¾LIG(ãƒªã‚°)ï½œDXæ”¯æ´ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ»Webåˆ¶ä½œ
ãã—ã¦ä¸€æ—¥ãŒçµ‚ã‚ã£ãŸâ€¦ã€€ä»Šæ—¥ã‚‚ã‚¢ãƒ‹ãƒ¡è¦‹é€ƒã—ãŸâ€¦ ã“ã‚“ã«ã¡ã¯ã€ãƒ¡ãƒ‡ã‚£ã‚¢äº‹æ¥éƒ¨ã®çŽ‹ã§ã™( Ìãƒ»_ãƒ» )ã€ã‚¢ãƒ‹ãƒ¡ã®è¦–è´æ™‚é–“ã‚’å¢—ã‚„ã™ãŸã‚ã«ã€å¸¸æ—¥é ƒã‹ã‚‰ä»•äº‹ã®åŠ¹çŽ‡åŒ–ã‚’å¿ƒãŒã‘ã¦ãŠã‚Šã¾ã™ã€‚ä»Šå›žã¯ä½œæ¥åŠ¹çŽ‡åŒ–ã®å¼·ã„æ¦å™¨ã«ãªã‚‹ã€ŒGoogle Apps Scriptã€ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã¯åˆè€³ã®æ–¹ã«Q&Aå½¢å¼ã§ã”èª¬æ˜Žã—ã¾ã™ã€‚ Q&A Q:ã€ŒGoogle Apps Scriptã€ã£ã¦ï¼Ÿ A:ã€€GoogleãŒæä¾›ã—ã¦ã„ã‚‹æ§˜ã€…ãªã‚µãƒ¼ãƒ“ã‚¹ã€ä¾‹ãˆã°ã€ŒGmailã€ã€ã€Œã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã€ã€ã€Œãƒžãƒƒãƒ—ã€ã€ã€Œãƒ‰ãƒ©ã‚¤ãƒ–ã€ã€ã€Œã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã€ã€ã€ŒAnalyticsã€ã€ã€ŒAdsenseã€ç‰ã®APIã‚’Javascriptã§åˆ©ç”¨ã™ã‚‹ã‚¯ãƒ©ã‚¦ãƒ‰åž‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆï¼ˆè¦ã¯å®Ÿè¡Œã¯ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã§ã¯ãªãã€ã‚µãƒ¼ãƒãƒ¼ã«ã¦è¡Œã†ï¼‰ã§ã™ã€‚ Q:Google Apps Scriptã§ä½•ãŒã§ãã‚‹ã®ï¼Ÿ A:ã€€Googleã‚¢ãƒ—ãƒªã‚’è‡ªåˆ†ã®å¥½ã¿ã‚„å¿…è¦ã«å¿œã˜ã¦æ©Ÿèƒ½ã‚’è‡ªç”±ã«æ‹¡å¼µ
cyokodog 2013/09/25
googleAppsScript
ãƒªãƒ³ã‚¯
Google Apps Scriptã§ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã™ã‚‹æ–¹æ³• - Qiita
function myFunction() { var response = UrlFetchApp.fetch("http://www.google.co.jp/search?q=qiita"); var myRegexp = /<h3 class=\"r\">([\s\S]*?)<\/h3>/gi; var elems = response.getContentText().match(myRegexp); for(var i in elems) { var title = elems[i] title = title.replace(/(^\s+)|(\s+$)/g, ""); title = title.replace(/<\/?[^>]+>/gi, ""); Logger.log(title); } } [13-09-10 00:08:56:438 JST] Qiita [ã‚ãƒ¼ã‚¿
cyokodog 2013/09/10
googleAppsScript

googleDrive
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
cyokodog 2012/11/20
googleAppsScript

****ã‚ã¨ã§ã¿ã‚‹
ãƒªãƒ³ã‚¯
Google Apps Script ã¨APIã‚’ä½¿ã£ãŸè‡ªå‹•ãƒ¡ãƒ¼ãƒ«é…ä¿¡ã‚·ã‚¹ãƒ†ãƒ ä½œæˆ
Google Apps Script ã¨ã¯ Google Apps Script ï¼ˆGASï¼‰ã¨ã¯ã€Googleãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆå†…ã«è¨˜è¿°ã§ãã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ã€‚Googleãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆå†…ã¨è¨€ã£ã¦ã‚‚ã€åˆ©ç”¨ã§ãã¾ã™ã®ã¯Googleã‚µãƒ¼ãƒ“ã‚¹å…¨èˆ¬ã«ã‚ãŸã‚Šã¾ã™ã€‚ã¤ã¾ã‚Šã€ãƒ¡ãƒ¼ãƒ«é…ä¿¡ã—ãŸã‚Šã€ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã«äºˆå®šã‚’è¿½åŠ ã—ãŸã‚Šã€å‹¿è«–ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’åŠ å·¥ã—ãŸã‚Šã¨ã€æ§˜ã€…ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ Google Apps Script ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æ–¹æ³• Googleãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ã€ã¾ãšã¯ä½œæˆï¼žã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã€ã¨ã—è¡¨è¨ˆç®—ã‚’é–‹ãã¾ã™ã€‚ ãã—ã¦ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ãƒ„ãƒ¼ãƒ«ï¼žã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã€ã§ã™ã€‚è¡¨è¨ˆç®—ã®ä¸ã«ã¯ä½•ã‚‚æ›¸ã‹ãªãã¦å¤§ä¸ˆå¤«ã§ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒ ã®ç”»é¢ãŒè¡¨ç¤ºã•ã‚Œã¾ã—ãŸã‚‰ã€ãã“ã§å…¥åŠ›ã—ãŸã‚Šã€ä¿å˜ã—ãŸã‚Šã€å®Ÿè¡Œã—ãŸã‚Šã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ã«ã—ã¦ã€Google Apps Script ã§ã¯ã€Googleãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®æ–‡æ›¸å†…ã®ã‚¹ã‚¯ãƒªãƒ—
cyokodog 2012/03/07
*google

googleAppsScript

****ã‚ã¨ã§ã¿ã‚‹
ãƒªãƒ³ã‚¯
1