ã客ããŸã®å£°
æ¥åå 容
ð¡PCæäœã®ç ©éããã解æŸãããŸãããïŒ
Google Apps Script(GAS)ãå©çšããŠãæ¥åãèªååããããŒã«ãéçºããããŸãã
Google Apps Scriptã¯ãGoogleã¹ãã¬ããã·ãŒããGoogleãã©ãŒã ãGoogleãã©ã€ããGmailãªã©ãæ§ã ãªGoogle補ã®ã¢ããªã±ãŒã·ã§ã³ã®èªååãæ¥åå¹çåãå©ããŠãããŸãã
Google Apps Scriptã®éçºçµéšã®ããç§ããã»ã³ãšããªãããã®çåã«ããçãããããŸãïŒãã¡ããã¯ãããŠã®æ¹ã®çåã«ãã©ãã©ãäžå¯§ã«ãçãïŒ
GASã®éçºãããŠã¿ããã©ãäžæããããªãã£ããªã©ãGASã®éçºå šè¬ã«é¢ããã質åããçžè«ã»ã¡ã³ã¿ãªã³ã°ã«ã€ããŠã¯ãŸãã¯ãåãåãããã ããã
ð¡ãçžè«ããçŽåãŸã§
ãŸãã¯ãåãåããã ãã§ã倧äžå€«ã§ãïŒ
ã©ã®ãã©ã³ãéžã¹ã°è¯ãããæ©ã¿ã§ããã°ããŸãã¯ãããŒã·ãã¯ããã©ã³ããã®ãäŸé Œããå§ãããŸãã
ããçžè«ãâãMTG/ã¡ãã»ãŒãžãâããèŠç©ãâããå¥çŽãâãçŽåã
ãã®ãããªæµãã«ãªããŸãã
ð¡ãããŸã§ã®å®çžŸã¯ïŒ
- GASãå©çšãã倧ææç§æžäŒç€Ÿæ§åãã®ããžã¿ã«ææé ä¿¡ã·ã¹ãã
- æ倧åŠã«ãããçåŸã®ããŒããã©ãªãªçæã·ã¹ãã ïŒGASã§æ§ç¯ïŒ
- Googleã¹ãã¬ããã·ãŒãããGoogleãã©ãŒã ã®äœæã»åæ ãè¡ãã·ã¹ãã
- Googleãã©ãŒã /GASãšSendgridãå©çšããã¡ãŒã«é ä¿¡ã·ã¹ãã
- ãã®ä»ãå€æ°
ð¡ä»ã«ã©ããªèªååãã§ããïŒ
- Googleãã©ãŒã ã®ããŒã¿ãéèšãããã®çµæãä»ã®ã¹ãã¬ããã·ãŒãã«è»¢èšïŒåæã«ã¡ãŒã«ãéç¥ïŒ
- GASã®ã¡ãŒã«å¶éãåé¿ããªããã¡ãŒã«éä¿¡
- GASã®å®è¡å¶é(6åé)ãåé¿ããªããPDFäœæ
- ããªã¬ãŒãçšããGASã®å®æå®è¡
- Googleãã©ã€ãã«CSVãã¡ã€ã«ãããŠã³ããŒãããã¹ãã¬ããã·ãŒãã«éèšãã
- Googleãã©ã€ãã«JSONãã¡ã€ã«ãæ ŒçŽãããŒã¿ãšããŠæŽ»çšãã
- Googleã¹ãã¬ããã·ãŒãã®æ
å ±ãAPIåãã
ãã®ä»ãçšéãåžæã«åãããã«ã¹ã¿ãã€ãºãå¯èœã§ãã
ð¡åçš®ãµãŒãã¹ãšã®çµã¿åãããOK
- Googleâã¹ãã¬ããã·ãŒã
- Googleâãã©ãŒã
- Googleâããã¥ã¡ã³ã
- Googleâã¹ã©ã€ã
- Gmail
- Googleâãã©ã€ã
- LINE/Slack/Chatworkçã®ãã£ããããŒã«
- åçš®Webã¢ããª
- ãã®ä»ãGASé£æºã§ãããã®ãªããªãã§ãçµã¿åããã§ããŸãã
ð¡åå¿è ã®æ¹ãæè¿ã§ãïŒ
äœãäžæç¹ãããã°ããµããŒãããããŸãïŒãæ°è»œã«ãåãåãããã ããã
ð¡ãŸãã¯ã質åãã
ã質åã¯ãèŠç©ããã»ã«ã¹ã¿ãã€ãºã®ãçžè«ãããŒãžãããã©ããïŒ
ååã®ãçžè«ã¯ç¡æã§ããè¿çã¯å¯èœãªéãè¿
éã«ããããŸãã
ã©ã®ãã©ã³ã«ãããããªïŒãšæã£ãããããŒã·ãã¯ãã§ïŒ
åºæ¬æé
ããŒã·ãã¯
éé¡ã¯ããšããå€æŽå¯èœã§ãïŒ
ïŒãçžè«å 容ã«å¿ããŠéé¡ãç°ãªããŸããïŒ
è¿·ã£ãããŸãã¯ãã¡ããããç³ã蟌ã¿ãã ããã
ã¹ã¿ã³ããŒã
éé¡ã¯ããšããå€æŽå¯èœã§ãïŒ
ïŒãçžè«å 容ã«å¿ããŠéé¡ãç°ãªããŸããïŒ
ãã¬ãã¢ã
éé¡ã¯ããšããå€æŽå¯èœã§ãïŒ
ïŒãçžè«å 容ã«å¿ããŠéé¡ãç°ãªããŸããïŒ
äºäŸ
-
â ãããžã§ã¯ãã®ç®ç
åŠç¿æå°èŠé æ¹èšã«äŒŽãå°äžåŠæ ¡ã®ããžã¿ã«ææåãé²ãäžã§ãæç§æžäŒç€Ÿæ§ããååŠæ ¡ãžããžã¿ã«ææãé ä¿¡ããã·ã¹ãã ã®æ§ç¯ãããããšã®ããäŸé ŒãåããŸããã
GoogleWorkspaceã®ã¢ããªïŒGoogleãã©ãŒã ãGoogleã¹ãã¬ããã·ãŒããªã©ïŒãGoogleãã©ã€ãã§é åž/管çããã·ã¹ãã ããGoogleAppsScriptãçšããŠWebã¢ããªã±ãŒã·ã§ã³åããŸããã
â äœå¶ã»äººæ°
å æ¹æ åœè 1å
éçºè ïŒç§ïŒ1å
â èªåã®ããžã·ã§ã³ã»åœ¹å²
éçºè ã¯ç§ã®ã¿ã§ãããããèŠä»¶å®çŸ©ãä¿å®éçšã«è³ããŸã§å šãŠäžäººã§å®æœããããŸããã
â ç®çãéæããäžã§ã®èª²é¡
Google Workspaceã®å ±æããªã·ãŒãå€éšãã¡ã€ã³äžå¯ã®å ŽåãGoogleãã©ã€ããååŠæ ¡æ§åãã«å ¬éããããšãçŽ çŽã«å®æœã§ããªããšãã課é¡ããããŸããã
â 課é¡ã«å¯ŸããŠåãçµãã ããš
Googleãã©ã€ãå ±æã®æ§ã ãªãã¿ãŒã³ãæ€èšŒããæçµçã«ã客æ§ã®æ±ããã·ã¹ãã ã®æ§ç¯ãè¡ããŸãããæè¡è³æã§ã¯èªæã§ãªãéšåãå€ãã£ããããæçŽã«äžã€ãã€å¯èœæ§ãæ€èšŒããŠãããŸããã
â ããžãã¹äžã®ææ
æç§æžäŒç€Ÿæ§ã¯ä»ã®ãã³ããŒæ§ãå«ããŠæ€èšãããŠããŸããããå æ¹ã®æå³ãçµãã ææ¡ãçŽ æ©ãã¬ã¹ãã³ã¹ãè¡ã£ãããšã«ãããããªãŒã©ã³ã¹ã§ãããªãããæ³äººãšã®ã³ã³ãã«åã¡å泚ããããšãã§ããŸããã
å®çžŸã»è©äŸ¡
18 件
æºè¶³
0
æ®å¿µ
äœå® ã»äžåç£ã®ãã®ä» (ã·ã¹ãã éçº)
2024幎12æ6æ¥è¿ éãªå¯Ÿå¿ãšãã®åŸã®ãã©ããŒã¢ããããã€ãå©ãã£ãŠãããŸããåŒãç¶ããäŸé ŒãããŠããã ããŸãã®ã§ã©ããå®ãããé¡ãèŽããŸãã
äœå® ã»äžåç£ã®ãã®ä» (ã·ã¹ãã éçº)
2024幎12æ2æ¥
ããŸã詳ããã¯ãªãã·ã¹ãã ã«é¢ããŠã調ã¹ãªããéçºã®å¯Ÿå¿ãããã ãã倧å€æºè¶³ããŠãããŸãã
åŒãç¶ãå®ãããé¡ãèŽããŸãã
äœå® ã»äžåç£ã®ãã®ä» (ã·ã¹ãã éçº)
2024幎11æ18æ¥ãã€ãéãä»åãã¿ã€ã ãªãŒã«ã察å¿ããã ããå®äºåŸã®ãã©ããŒã¢ããã倧å€æºè¶³ã§ãããŸãå®ãããé¡ãããããŸãã
åºåè
Google Apps Script/AWS/ChatGPT ã䜿ã£ãWebã¢ããªéçºãããŸã
-
18 件 æºè¶³0 æ®å¿µ
- èªå®ã©ã³ãµãŒ
- å人
- æ±äº¬éœ
KCompanyã®å
«æšæ
¶å€ªã§ãã
# èªå·±çŽ¹ä»
ã¢ãã€ã«ã»ã€ã³ã¿ãŒãããæ¥çã§15幎以äžã®çµå¶ã»äºæ¥éçºçµéšããããŸãã
2017幎ãããœãããŠã§ã¢ãšã³ãžãã¢ãšããŠèªãã³ãŒããæžããŠããŸããã
2021幎ãããçŸåšã¯ããªãŒã©ã³ã¹ãšããŠ10瀟以äžã«
Google Apps Script (GAS) éçºãäžå¿ãšããDXæšé²ã®ãµããŒããããŠããŸãã
2023幎ããã¯ãã客æ§ã®ãèŠæã«ãå¿ãããäžã§ã
AWSãåºç€ãšããWebã¢ããªã±ãŒã·ã§ã³éçºã
ChatGPT (OpenAI API)ã掻çšããçæAIå®è£
ãè¡ã£ãŠããŸãã
å
·äœçã«ã¯ã以äžã®ãããªæ¥åã®çµéšãã¹ãã«ãæã£ãŠãããŸãã
# ã¹ãã«ã»å®çžŸ
ãšã³ãžãã¢ãšããŠã¯ã以äžã®ã¹ãã«ã»å®çžŸããããŸãã
ïŒïŒ Google Apps Script(GAS)ã䜿çšããDXæšé²ã·ã¹ãã
ã»Google Workspace補åïŒGoogle ã¹ãã¬ããã·ãŒã/Googleãã©ãŒã )ã掻çšããã·ã¹ãã æ§ç¯
ã»AppSheet / AppSheet databaseãçšããã¢ããªæ§ç¯
ïŒïŒAWSãåºç€ãšããWebã¢ããªã±ãŒã·ã§ã³éçº
ã»AWSãçšããã€ã³ãã©æ§ç¯
ã»Vue/Vuetifyãçšããããã³ããšã³ãéçº
ã»Node.js/MySQLãçšããããã¯ãšã³ãéçº
ïŒïŒChatGPT (OpenAI API)ã掻çšããçæAIå®è£
ã»LINE BOTãGASãšé£æºãããã£ãããããéçº
ãã®ä»ãSendgridãçšããã¡ãŒã«é
ä¿¡ã·ã¹ãã ã
Firebase/superbaseã®éçºçµéšããããŸãã
ãŸããã¹ã¿ãŒãã¢ããäŒæ¥3瀟ã§10幎以äžçµå¶ãããŠããçµéšããã
çµå¶è
/äºæ¥éå¶è
ã®èŠç¹ã«ãããã£ãã·ã¹ãã ææ¡ãå¿ãããŠããŸãã
çŽè¿ã®ãããžã§ã¯ãã§ã¯ã以äžã®ãããªææãäžããŠããŸãã
ã»è£œé ã¡ãŒã«ãŒæ§åãWebã¢ããªã±ãŒã·ã§ã³æ§ç¯
ãïŒç°å¢è² è·ç©è³ããã¥ã¡ã³ã瀟å
å€å
±æã·ã¹ãã ïŒ
ã»åŠç¿å¡Ÿåãã®äŒå¡å¶ããã·ã¥ããŒãWebã¢ããª
ã»GASãå©çšãã倧ææç§æžäŒç€Ÿæ§åãã®ããžã¿ã«ææé
ä¿¡ã·ã¹ãã
# 察å¿å¯èœæéã»é£çµ¡æ¹æ³
ãã€ã§ããæ°è»œã«ãé£çµ¡ãã ããïŒ
MTGã¯å¹³æ¥ã®9-17æãåæ¥ç¥æ¥ã¯15-18æãå¯èœã§ãã
ã客æ§ã®ãéœåã«åãããŠæè»ã«å¯Ÿå¿ããããŸãã
ãããããé¡ãããããŸãã
泚ææã®ãé¡ã
- ã©ããªäºã§ãããŸããŸããã®ã§ããã£ãŠãããšãããŸã§ããªãã¹ã詳ãããäŒããã ããã
- é³ä¿¡äžéãæ°æ¥ç¶ããå Žåã¯å®äºãŸãã¯ãã£ã³ã»ã«ãšãããŠé ããŸãã
- äœæ¥é£æ床ã«å¿ããŠãè¿œå è²»çšã®ãææ¡ããããŠããã ãå ŽåãããããŸãã
- Google Apps Scriptã®äœæããè€éãªã·ãŒããäœæããå ŽåãçŽåãŸã§1é±éååŸã®ãæéãé æŽããå ŽåããããŸãã
- åœæ¥çŽååžæãªã©ããæ¥ãã®ãäŸé Œã¯ãè¿·æããæãããŠã¯ãããªãã®ã§åºæ¬çã«åŸ¡è«ãããŠãããŸããã
-
10,000å
GASéçºãããŸãã
éé¡ã¯ããšããå€æŽå¯èœã§ãïŒ
ïŒãçžè«å 容ã«å¿ããŠéé¡ãç°ãªããŸããïŒ
è¿·ã£ãããŸãã¯ãã¡ããããç³ã蟌ã¿ãã ãããçŽæ 3æ¥ä»çžè«ããã°æçïŒå¶æ¥æ¥ä»¥å ã§äŸé Œã§ããŸã
ãŸãã¯çžè«ããïŒç¡æïŒâ»éé¡ã»äŸé Œå 容ã®èª¿æŽãçžè«ã§ããŸã
ãæ°ã«å ¥ã 3件 -
30,000å
GASéçºãããŸãã
éé¡ã¯ããšããå€æŽå¯èœã§ãïŒ
ïŒãçžè«å 容ã«å¿ããŠéé¡ãç°ãªããŸããïŒçŽæ 5æ¥ä»çžè«ããã°æçïŒå¶æ¥æ¥ä»¥å ã§äŸé Œã§ããŸã
ãŸãã¯çžè«ããïŒç¡æïŒâ»éé¡ã»äŸé Œå 容ã®èª¿æŽãçžè«ã§ããŸã
ãæ°ã«å ¥ã 3件 -
50,000å
GASéçºãããŸãã
éé¡ã¯ããšããå€æŽå¯èœã§ãïŒ
ïŒãçžè«å 容ã«å¿ããŠéé¡ãç°ãªããŸããïŒçŽæ 7æ¥ä»çžè«ããã°æçïŒå¶æ¥æ¥ä»¥å ã§äŸé Œã§ããŸã
ãŸãã¯çžè«ããïŒç¡æïŒâ»éé¡ã»äŸé Œå 容ã®èª¿æŽãçžè«ã§ããŸã
ãæ°ã«å ¥ã 3件 -
ã«ã¹ã¿ãã€ãº
ãã©ã³ã決ãŸã£ãŠãªãæ¹ã¯ãŸãçžè«ããŸããã
ãŸãã¯çžè«ããïŒç¡æïŒ