ã客ããŸã®å£°
æ¥åå 容
ð¡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é£æºã§ãããã®ãªããªãã§ãçµã¿åããã§ããŸãã
ð¡åå¿è ã®æ¹ãæè¿ã§ãïŒ
äœãäžæç¹ãããã°ããµããŒãããããŸãïŒãæ°è»œã«ãåãåãããã ããã
ð¡ãŸãã¯ã質åãã
ã質åã¯ãèŠç©ããã»ã«ã¹ã¿ãã€ãºã®ãçžè«ãããŒãžãããã©ããïŒ
ååã®ãçžè«ã¯ç¡æã§ããè¿çã¯å¯èœãªéãè¿
éã«ããããŸãã
ã©ã®ãã©ã³ã«ãããããªïŒãšæã£ãããããŒã·ãã¯ãã§ïŒ
åºæ¬æé
ããŒã·ãã¯
ã¹ã¿ã³ããŒã
ãã¬ãã¢ã
å®çžŸã»è©äŸ¡
8 件
æºè¶³
0
æ®å¿µ
ãšã©ãŒã§åããªãGoogle Apps ScriptãçŽããŸã
2024幎3æ29æ¥è³Œå ¥ããããã±ãŒãž
æºè¶³ã ã£ãç¹â¡äŸé Œå 容ãã¹ãããããããèæ¯ãè€éãªéšåãããäžã§ãæ å ±ãæ±²ã¿åã£ãŠæŽçããŠããã ããŸãããã¹ããŒããéãããŸãåŒãç¶ãäŸé ŒãããŠããã ããããšæã£ãŠããŸãã
äžå¯§ãªã³ãã¥ãã±ãŒã·ã§ã³ãã¿ã€ã ãªãŒã«å®æœããã ããçå®ã«èŠæ±éãã®ãã®ãä»äžããŠããã ããŸããã
ãšã©ãŒã§åããªãGoogle Apps ScriptãçŽããŸã
2023幎12æ2æ¥è³Œå ¥ããããã±ãŒãž
ãè¿·æããããããŸãã
åºåè
Google Apps Script/AWS/ChatGPT ã䜿ã£ãWebã¢ããªéçºãããŸã
-
8 件 æºè¶³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æ¥ä»çžè«ããã°æçïŒå¶æ¥æ¥ä»¥å ã§äŸé Œã§ããŸã
ãŸãã¯çžè«ããïŒç¡æïŒâ»éé¡ã»äŸé Œå 容ã®èª¿æŽãçžè«ã§ããŸã
çŸåšã2åããã®ã©ã³ãµãŒã«çžè«äž
ãæ°ã«å ¥ã 1件 -
30,000å
GASéçºãããŸãã éé¡ã¯ããšããå€æŽå¯èœã§ãïŒ ïŒãçžè«å 容ã«å¿ããŠéé¡ãç°ãªããŸããïŒ
çŽæ 5æ¥ä»çžè«ããã°æçïŒå¶æ¥æ¥ä»¥å ã§äŸé Œã§ããŸã
ãŸãã¯çžè«ããïŒç¡æïŒâ»éé¡ã»äŸé Œå 容ã®èª¿æŽãçžè«ã§ããŸã
çŸåšã2åããã®ã©ã³ãµãŒã«çžè«äž
ãæ°ã«å ¥ã 1件 -
50,000å
GASéçºãããŸãã éé¡ã¯ããšããå€æŽå¯èœã§ãïŒ ïŒãçžè«å 容ã«å¿ããŠéé¡ãç°ãªããŸããïŒ
çŽæ 7æ¥ä»çžè«ããã°æçïŒå¶æ¥æ¥ä»¥å ã§äŸé Œã§ããŸã
ãŸãã¯çžè«ããïŒç¡æïŒâ»éé¡ã»äŸé Œå 容ã®èª¿æŽãçžè«ã§ããŸã
çŸåšã2åããã®ã©ã³ãµãŒã«çžè«äž
ãæ°ã«å ¥ã 1件 -
ã«ã¹ã¿ãã€ãº
ãã©ã³ã決ãŸã£ãŠãªãæ¹ã¯ãŸãçžè«ããŸããã
ãŸãã¯çžè«ããïŒç¡æïŒ