Google Apps Scriptãå§ããããåºæ¥ãããšä»£è¡šäŸ
æ¥ãäœããå§ããã®ã«ã¯è¯ãåºåãã§ããå£ç¯ãæ°å ¥ç€Ÿå¡ãšããŠã®æŠåšãäœããç±ããªã¹ããªã³ã°ãšããŠä¿®è¡ãããç±ãäŒç€Ÿã®çºã§ã¯ãªãå·±ã®å®ãšããã¹ã身ã«ã€ããæè¡ã¯ç¶ç¶åãéèŠã§ãã
ããäœã身ã«ã€ããã°è¯ãã®ãïŒè¿·ã£ãŠããã®ã§ãããªãã°ãäœã³ã¹ãã§ä»ããåããããGoogle Apps ScriptïŒä»¥äžãGASïŒãæãæé©ã§ããä»åã¯èªåã®çµéšããGoogle Apps Scriptã§åºæ¥ãããšããŸãšããŠã¿ãŸããã
ç®æ¬¡
ä»åå©çšãããµãŒãã¹
Google Apps Scriptã¯ç¡åã®Googleã¢ã«ãŠã³ããããã°çŽãã«ã§ãå§ããããšãå¯èœã§ããå©çšèªäœãç¡åã§ãããç¡åã®Googleã¢ã«ãŠã³ããšæåãµãŒãã¹ã®Google Workspaceã§ã¯å·®ããããŸããããããéåžžã®ç¯å²ã§ããã°ãããæèããããšã¯ãªãã§ããããããèžã¿èŸŒãã§ããã«é«ã¿ãç®æããªãã°ãBusiness Starterãå¥çŽããŠãããå€ãã®æ©èœã管çæ©èœãŸã§æã䌞ã°ããŠãã¹ã¿ãŒãç®æããšè¯ãã§ãããã
GASãšã¯äœè ãªã®ãïŒ
æŠèŠ
Google Apps Scriptãšã¯ãJavaScriptãããŒã¹ã«Google Docsãªã©ã®åçš®ã¢ããªãæäœã§ããæ©èœãè¿œå ããããã°ã©ãã³ã°èšèªã§ãããã§ã«ãã10幎以äžã®æŽå²ããããŸããèªåã®å Žåã2013幎ã®Google Apps for Workæ代ãã䜿ãå§ããŠããŸãã
JavaScriptããŒã¹ã§ãã®ã§æ§ã ãªJSã®ç¥èŠãã»ãŒãã®ãŸãŸæµçšã§ãããšãã倧ããªãã€ã³ãããããMicrosoft Officeã®VBAã®ããžã·ã§ã³ã§ãããªãããVBAã§ã¯å°åºåºæ¥ãªãããŠã§ãã¢ããªãäœæãããäºãåºæ¥ãããèªåå®è¡ã§ããããšéåžžã«é«æ©èœãªãµãŒãã¹ã§ããJavaScriptã§ãããšããããšã¯æŽã«éããã°ãNode.jsãšãã£ããµãŒããµã€ãJavaScriptã«ææŠãããChromeã®æ¡åŒµæ©èœãäœã£ãŠã¿ãããšããã®å ã«ææŠããããšãå¯èœã§ãã
ããã°ã©ãã³ã°èšèªãšèããšãããŒãã«é«ããŠé£ãããããšããå å ¥èŠ³ãã€ããŸãšããŸããã§ãããVBAãæ¬æ¥ã¯ãšã³ãžãã¢ã§ã¯ãªããã¹ã¯ã¯ãŒã«ãŒãèªåã®æ¥åãå¹çåããçºã«çãŸãããã®ã§ãä»ã®ããã°ã©ãã³ã°èšèªã¯ããŒãã«ãé«ããããããŸããããVBAãGASã¯ãšã³ãžãã¢ã§ãªããã°äœ¿ããªããã®ã§ã¯ç¡ãã®ã§ãã
以äžã®åç»ã¯äºåè·ãããããã®è§£èª¬åç»ã§ãããäºåã®çŸå Žè·ã®äººã§ãã¬ãããªåããŠæžç±ãŸã§åºãã«è³ã£ãŠããŸãããããããæ¬åœã®DXã§ããåžæ°éçºè ããããå®çŸã§ããïŒã€ãGoogle Apps Scriptãªã®ã§ãã
Microsoft365ãšã®éã
Google Workspaceã®ã©ã€ãã«ãšããŠMicrosoft365ããããŸããããŒã«ã«ã®Officeã¯ãããŸã§ãé·ãæŽå²ã®ããVBAã䜿ã£ãŠãGASã®ããã«æ§ã ãªæ¥åæ¹åã«å€å€§ãªè²¢ç®ãããŠããŸããã
ããããæšä»ã¯ã»ãã¥ãªãã£åé¡ã§VBAã®å©çšãããã©ã«ãã§çŠæ¢ã«ããäŒæ¥ãåºå§ããŠããïŒãšãããMSèªäœãããã©ã«ãã§å®è¡äžå¯ã«ããŸããïŒãããªã·ãŒã§å®å šã«çŠæ¢ã«ãããã³ãã¬ãŒããªã©ããã£ããããŸãïŒæ¬æ¥ã¯èšŒææžã§å¶åŸ¡ããã°è¯ãã ããªã®ã§ãããã¯ããéãã ãšæããŸããïŒã
äžæ¹ã§Webçã®Excel Onlineãªã©ã§ã¯VBAã«å€ãããOffice Scriptããªããã®ãåºãŠããŠããŸããVBAåŸç¶ãšããããžã·ã§ã³ã§ãããçŸæç¹ã§ã¯ãã¯ãçãªæ©èœã«ãšã©ãŸã£ãŠãããVBAã®ããã«æŽŸæã«ãªãã§ãåºæ¥ãããã§ã¯ãããŸããããããããèšèªäœç³»ãTypeScriptã«å€æŽãããŠããŸãã
GASåæ§ã«Graph APIãçšããã°Microsoft365ã®åçš®ãŠã§ããµãŒãã¹ãæäœã§ããŸãããããã¯WebAPIãªã®ã§å®è¡ããçºã®ç°å¢ã¯èªèº«ã§çšæããå¿ èŠããããŸãïŒGASã¯ç°å¢èªäœçšæãããŠããŸãïŒã
æ ã«çŸæç¹ã§ã¯ãMicrosoft365ã®DXããæ¥åæ¹åã¯ãèªååã«ãã©ãŒã«ã¹ããããPower Automate Desktopãªã©ã®RPAã§ãããGoogleãšã¯ã ãã¶æ¹åæ§ãç°ãªããŸããPower Automateã¯ãããŒã³ãŒãããŒã«ããšåŒã°ããåºæ¬ããã°ã©ãã³ã°ãããªãã§äœæ¥ã®èªååããããã®ã§ãããGASã¯ãããŒã³ãŒãããŒã«ããšåŒã°ããèªååãå«ããŠã¢ããªãäœæããç°å¢ã«ãªããŸãã
VBAãã¯ããæ¢å®ã§ãããã¯ãããçºã®å¯Ÿçæ¹æ³
ããŒã³ãŒãããŒã«ã§ãã
åè¿°ã®éããGoogle Apps Scriptã¯ãããŒã³ãŒãããŒã«ãã§ããç«æŽŸãªããã°ã©ãã³ã°èšèªã§ãããããããŒã³ãŒãããŒã«ãšã¯å€§ããããšãªããããæ ã«ç¢ºãã«é£æ床ã¯äžã§ãã
äœããã¬ãã¢ã³ã®ããã°ã©ãã³ã°èšèªïŒäŸãã°ãC#ãObjective-Cãªã©ãªã©ïŒãšã¯ç°ãªããå°ãªãã³ãŒãã§ç®çãå®çŸã§ããããçµãŸããèšèªã§ãããç¿åŸé£æ床ã¯äœãã§ããçŽ æ©ããäœã³ã¹ãã§ãæ軜ã«éæãç®çãšããŠãã®ã§ãå°èŠæš¡ãäžèŠæš¡ãŸã§ãã«ããŒããååšã§ãã
Microsoft365ã®Power Automate Desktopã®ãããªããŒã³ãŒãããŒã«ãšã¯ç°ãªããèªååã ãã«ãã©ãŒã«ã¹ããããã®ã§ã¯ãªããããèªåå以å€ã®ãžã£ã³ã«ã«ãŸã§æã䌞ã°ãããšãå¯èœã§ããæ ã«ã¢ããªã±ãŒã·ã§ã³ãäœæããããšãåºæ¥ãçºãããã°ã©ãã³ã°çãªã»ã³ã¹ãéããããšãå¯èœã§ãã
ããŒã³ãŒãããŒã«å°å ¥ããããã©ãçµå±ããŸããããªãã£ããšããäºäŸã¯å±±çšãããŸããããã¯kintoneãäŸå€ã§ã¯ãããŸããïŒèªåã®çµéšã ãšããã ã®ãã©ãŒã ã¢ããªã«æãæãŠãŠãŸããïŒãäžçªã®å€§ããªé»å®³èŠå ã¯ãçµå±ã¯ããã°ã©ãã³ã°çã»ã³ã¹ãå¿ èŠããšããããšã«ãªãããšæããŸããRPAå°å ¥ããŠã³ã±ãŠãèŠå ã¯ä»ã«ããããããããŸãã
ã§ãããªãã°ãæåããããã°ã©ãã³ã°çã»ã³ã¹ãéãããããGoogle Apps Scriptãã®ã»ãããæã¡éã³ã§ãå¿çšã®ã§ããã¹ãã«ããšããŠãªã¹ããªã³ã°ãšããŠã¯å€§ãããã©ã¹ã«ãªããŸãïŒJSã§ããã»ã»ã»ïŒã
â»ã¡ãªã¿ã«Googleã«ãããŒã³ãŒãããŒã«ãšããŠAppSheetããããŸãããã UIãããŒã«ã©ã€ãºãããŠããªãã®ãçã«çã
AppSheetã§Googleã¹ãã¬ããã·ãŒãçšã¢ããªãäœããGASã
GASã§åºæ¥ãããš
äœæ¥ã®èªåå
ãã¯ãã§èªåå
Excelãªã©ã«ãåãã£ãŠããã¯ãã®èšé²æ©èœãGoogle Spreadsheetã«ãåãã£ãŠããã人éãæäœããå 容ãGoogle Apps Scriptã§åºåããåçãããšãã®éãå®çŸããŠãããã¹ã°ã¬ã¢ãã2018幎ããæèŒãããæ©èœã§ãããèªåãè¡ã£ãäœæ¥ãã©ãããã³ãŒããšããŠçæãããã®ãïŒãåŠã¶æåã®äžæ©ãšããŠã¯è¯ãææã§ãïŒãã¡ããæ¥åèªååã«ãè²¢ç®ããŸãïŒã
äœããã®æ©èœã¯èªååã«ç¹åããŠãç¹ãšãæ¬åœã«çŽ çŽã«äººéã®åäœã®äžææäžæ足ãã³ãŒãã«ããŠãã ããªã®ã§ãæ¯æ¥åãäœæ¥ã®ç¹°ãè¿ããããã±ãŒã¹ã§ã¯æçšãªã®ã§ãããè€éãªåäœãæ¡ä»¶å€å®ãGASã«çšæãããŠããªãåäœïŒå°å·ãªã©ïŒã¯èšé²ããããšãåºæ¥ãŸããããŸããVBAã®ãã¯ãã§ãããã§ãããé·ãåŠçãèšé²ããéã«æã£ããããªçµæã«ãªããæ¢ãŸã£ããšããããšãããããŸãïŒããŒããŒãã®ã·ã§ãŒãã«ããæ©èœã䜵çšããå¿ èŠãããã·ãŒã³ãïŒã
â»ãã¯ãã®èšé²ã§åºåãããã³ãŒãã¯åè¿°ã®éãçŽ çŽã«èšé²ãããŠããŸãã®ã§ãããã°ã©ãã³ã°çã«ã¯ãã£ããããã³ãŒããšã¯èšããªãã®ã§æåãé ãããšããŸãŸãããŸãã
Googleã¹ãã¬ããã·ãŒãã®ãã¯ãæ©èœã䜿ã£ãŠã¿ã
è€éãªäœæ¥ã®èªåå
ããŒã³ãŒããšã¯èšããJavaScriptã¯ç«æŽŸãªããã°ã©ãã³ã°èšèªã§ããGASã¯ããã«GoogleãµãŒãã¹ãæäœããã¡ãœãããè¿œå ãããã®ãåè¿°ã®ãã¯ãã¯æäœãåçŸããèªååã ãããåºæ¥ãŸããããèªèº«ã§ããã°ã©ãã³ã°ããã°ã«ãããªãšããããã°ã©ã ãäœæããäºãå¯èœã§ãã
ãã¯ãã§åºæ¥ãªããæ¡ä»¶å€å®ã§å¥ã®åŠçãããã§ãã£ãããã«ãŒãã§ç¹°ãè¿ãåŠçãåŸè¿°ã®ä»ã®ã¢ããªã®æäœããããŠãããäžé£ã®æµããçµæ¶åãããŠãGASãæ±ããªã人ãæ¥åãäžæ £ããªäººã§ãé«éã«æ£ç¢ºã«åŠçãåºæ¥ãããã«ãªãããã®ããã®æ©èœã§ãã
äŒæ¥åŽããããããããã®ãã®ãéèŠãªè³ç£ã«ãªãç¶ç¶çã«ã³ã¹ãåæžã«è²¢ç®ããã ããããªãããã£ããå°å ¥ããGoogle Workspaceã®ããã³ã·ã£ã«ã120%åŒãåºãããšãåºæ¥ãã®ã§ããæ¬ç©ã®DXããå®çŸããããšãåºæ¥ãŸãããã®ããã«ã¯GASãæžãã人æã®è²æãšãããè©äŸ¡ãç¶æããŠããäœå¶ãå¿ èŠã§ãã
倧èŠæš¡ã«ãªã£ãŠãããããã®æç¹ã§ããå å®ãªã·ã¹ãã ã«ç§»æ€ããã°ããã®ã§ããããªã倧éãæããŠã·ã¹ãã å°å ¥ããŠãããããšãã£ãããšãé²ãå段éãå®çŸããæŠå¿µæ€èšŒïŒPoCïŒãšããé¢ã§ãGASãã¯éåžžã«è¯ãç°å¢ã§ãã
GoogleãµãŒãã¹ã暪æããŠæäœ
Google Apps Scriptã¯åçŽã«ã¹ãã¬ããã·ãŒãäžã§åŠçããããšããã ããããªããããã¥ã¡ã³ããã¹ã©ã€ããã°ã«ãŒããã¡ãŒã«ããã©ã€ããšå¥ã®ã¢ããªã±ãŒã·ã§ã³ãæäœããŠäžé£ã®æ¥åã®äœæ¥ã®æµãã暪æããŠè¡ãããšãå¯èœã§ãã
åçš®ã¢ããªã±ãŒã·ã§ã³ã ããããªã管çè æš©éãããã°Google Workspaceã®èšå®ãã®ãã®ãå€æŽãããšãã£ãããšãå¯èœã«ãªãã誰ããå ¥ç€Ÿãããèªåã§ã¢ã«ãŠã³ãäœæâã¡ãŒã«ã§éç¥âå¥ã®ãµãŒãã¹ã®ã¢ã«ãŠã³ããèªåã§äœæã§ãã£ãããçµç¹å€æŽã«äŒŽã£ãŠã¹ãã·ã®ããŒã¿ãå ã«ã°ã«ãŒãã®ã¡ã³ããŒãäžæ¬ã§å ¥ãæ¿ãâãã©ã€ãã®ã¢ã¯ã»ã¹æš©éç·å ¥ãæ¿ãé£åã¿ãããªèžåœãå¯èœã§ãã人éããã£ããäºåºŠæéããã¹å€çºãªäžã«èšå€§ãªäœæ¥éã«ãªããŸãã
ã€ãŸããäºåè·ã®çŸå Žã®äººã ããããªã管çããæ ã·ã¹åŽã«ãšã£ãŠãéåžžã«å©ã®ããããŒã«ãªã®ã§ãã
Google Apps Scriptã®Admin SDKã§ãŠãŒã¶äœæãã©ãŒã ãäœããGASã
ããªã¬ãŒã䜿ã£ãŠèªåçºå
Google Apps Scriptã«ã¯ããªã¬ãŒãšåŒã°ããæ©èœããããVBAã«ã¯ç¡ãç¹åŸŽã§ããããœã³ã³ãéããŠããå¿ èŠæ§ãããããŸããã
- ã¹ãã¬ããã·ãŒãäžã§ã®ãŠãŒã¶ã®æäœã«ããèªåçºåããã·ã³ãã«ããªã¬ãŒ
- Googleãã©ãŒã ã«æŒããããŠãŒã¶ããã©ãŒã ãéä¿¡ããæã«çºåããéä¿¡æããªã¬ãŒ
- ç¹å®ã®æå»ãæ¥ä»ééã§èªåå®è¡ããæéé§ååããªã¬ãŒ
ãã®äžã§ãã£ãšãããå©çšããã®ãæåŸã®æéé§ååããªã¬ãŒã1æéããã«å®è¡ã§ãã£ãããæ¯æ©0æã«èªåå®è¡ã§ãã£ãããæ¥ä»ãæå»ãåºæºã«äººéãæäœããªããŠãèªåçã«äœåããŠãããŸããå€éã®ãã¡ã«ããŒã¿ã®éèšãæžãŸããŠãããšããæå®ã®ééã§ã¹ãã¬ããã·ãŒãã®å€ãå ã«ãªãã€ã³ããŒãéã£ãŠããããªã©ãªã©ã
Google Apps Scriptã§ããªã¬ãŒã掻çšããããGASã
æ©èœã®æ¡åŒµ
Googleãã©ãŒã ã«èªåå¿çæ©èœãã€ãã
çŸåšã®Googleãã©ãŒã ã¯ãŠãŒã¶ãéä¿¡æã«èªåçã«ãããããšãã¡ãŒã«ãã®ãããªéä¿¡ããå 容ãèªåå¿çã§è¿ãæ©èœãåãã£ãŠããŸãããããæ¢å®ã®ã¡ãã»ãŒãžãè¿ãã ãã®æ©èœã§ãããããããã¡ããšç¶ºçŸ ã³ããã«ãŠãŒã¶ããšã«ãã¡ããšããã¡ãã»ãŒãžãéãããã§ãã£ãããç³è«ããå 容ã«åºã¥ãPDFãçæããŠè¿ããŠããããªã©ãåºæ¥ãŸããã
ãã®éšåãå¯èœã«ããã®ãGoogle Apps Scriptã§ãã
ãã®ä»ã«ãGoogleãã©ãŒã ã®è³ªåå 容èªäœãã©ã³ãã ã«æžãæãããšãã£ããã©ãŒã ãã®ãã®ãæäœããäºãå¯èœã§ã䜿ãæãçµæ§å€ãã®ã§ã¯ãªãããšæããŸãã
ã¹ãã¬ããã·ãŒãã®é¢æ°ãäœãã
Excelã§ãå®ã¯èªåãªãªãžãã«ã®é¢æ°ã§ããããŠãŒã¶å®çŸ©é¢æ°ããäœããããšã¯ããŸãç¥ãããŠããŸãããGASã§ãåæ§ã«ã¹ãã¬ããã·ãŒãçšã®é¢æ°ãèªåã§äœæããããšãå¯èœã§ãã
äž»ã«äœãçç±ã¯ãé¢æ°ã®å ¥ãåãããéããŠIFé¢æ°ãäœéã«ãå ¥ã£ãŠããŠãã¯ãäœãããŠããã®ãããããããšãã£ããããªã±ãŒã¹ã®è§£æ±ºã§ãã£ãããæšæºé¢æ°ã§ã¯åãã£ãŠããªããã®ãèªäœããããšã«ããå©çšãããŠããŸããåŸè¿°ã®ã¢ããªã³åããããšã§ãã®ã¹ãã¬ããã·ãŒã以å€ã§ãèªäœé¢æ°ã䜿ããããã«ãªãã®ã§ãèªåã®é¢æ°ãä»äººã«ç°¡åã«äœ¿ã£ãŠããããç¹åŸŽããããŸãã
ããã°ã©ãã³ã°éãéåžžã«å°ããã®ã§ãGASã®åŠç¿ãããæåã®äžæ©ãšããŠéåžžã«è¯ããã®ã§ãããã§ããŠæ¥åžžã®æ¥åã§å³åœ¹ã«ç«ã€ãããæå¿ããå®æã§ããŸãã
Google Apps Scriptã§ãŠãŒã¶å®çŸ©é¢æ°ãäœããGASã
åçš®ã¢ããªã®ã¢ããªã³ãäœãã
GASã«ã¯ããã§äœãäžããæ©èœãäžžããšå¡ã«ããŠä»äººã«é åžããããšã®åºæ¥ããã¢ããªã³ããšããæ©èœãåãã£ãŠããŸããMarketplaceã«ãŠæ§ã ãªã¢ããªåãããã¢ããªã³ãé åžãããŠããŸãã
ããããã±ãã¬ã§ã¯æ¥æ¬äººåãã®ã¢ããªã³ã¯ããŸãèŠåœãããŸãããããã§GASã§èªèº«ã§äœã£ãŠãçµç¹å éå®ã§é åžããããšãã£ãããšãå¯èœã«ãªã£ãŠããŸããèªåã®äœãäžããæ¥åæ¹åã®æé ãæ©èœãä»ã®éšçœ²ãã°ã«ãŒãäŒç€Ÿã§äœ¿ã£ãŠããããããã§ãã
ã¢ããªã³ãšããŠèãããããŠãŒã¹ã±ãŒã¹ã¯ä»¥äžã®ãããªãã®ãæããããŸãã
- Googleã¹ãã¬ããã·ãŒãåãïŒãŠãŒã¶å®çŸ©é¢æ°ãè©°ã蟌ãã ãã®ããäžå®ã®åŠçãè£ åããèªååãå®çŸãªã©ïŒ
- GmailåãïŒã¡ãŒã«ããBacklogãžã¿ã¹ã¯ç»é²ããããéå»ã¡ãŒã«ãäžæ¬ã¢ãŒã«ã€ãããããæ·»ä»ãã¡ã€ã«ããã©ã€ãã«èªåä¿åãªã©ïŒ
- Googleããã¥ã¡ã³ãåãïŒAIãµãŒãã¹ã«æããŠæç« æ ¡æ£ã翻蚳ãå·®ã蟌ã¿PDFçæãªã©ïŒ
- Googleã¹ã©ã€ãåãïŒAIãµãŒãã¹ã«æããŠç»åèªåçæãããã³ãã¬ãå ã«ãã¬ãŒã³è³æèªåäœæãªã©ïŒ
- Googleãã©ãŒã åãïŒãã©ãŒã éä¿¡æã®æ§ã ãªèªååŠçãªã©ïŒ
ãªã©ãªã©ãã¢ã€ãã¢æ¬¡ç¬¬ã§æ§ã ãªãã®ãäœããã ããããªããåå¥ã«ã³ãŒããæžãå¿ èŠããªããªãã®ã§ãæ±çšã§éçšãããããªæ©èœã¯ã©ãã©ãã¢ããªã³åããŠãããšè»èŒªã®åçºæãããå¿ èŠããªããªããŸãã
Google Spreadsheetçšã®çµç¹å ã¢ããªã³ãäœæãããGASã
ã©ã€ãã©ãªã䜿ã
ããã°ã©ã ãäœæãããšãã£ãŠãèªåã«ã¯é«åºŠãªæè¡åããªãã»ã»ã»æ¯åæ¥ä»ã®åŠçãããŠãããã©æ¯åæ±ããé¢åã§å€±æããã»ã»ã»ãããªäººã¯å€ãã§ããèªåã決ããŠããããæè¡ããããããããããŸããã
ãããªããã°ã©ãã³ã°ãå©ããŠããããã®ãã©ã€ãã©ãªãäžçäžã®å€ãã®åè ããã°ã©ããªäººãäœã£ãŠç¡åå ¬éããŠãããŠããã®ã§ãåè¿°ã®ã¢ããªã³ã«äŒŒãŠããããã§ããããã¡ãã¯ã³ãŒããæäŸã§æäŸãããŠããã®ã§ãããåäœã§ã¯ã©ãã«ããªããŸããããã®ã©ã€ãã©ãªã䜿ã£ãŠèªåã§ã¢ããªãç°¡åã«æ§ç¯ããããšãå¯èœã«ãªããŸãã
æ¥ä»æå»ã®æ±ãã楜ã«ãªã£ããããŠã§ããµãŒãã¹ãç°¡åã«æ±ããããã«ãªã£ãããèªåã«è¶³ããªãèœåããå©ãããŠãããŸãã
Google Apps Scriptã¯ã©ã€ãã©ãªã掻çšãã¹ããGASã
ã¢ããªã±ãŒã·ã§ã³äœæ
ãŠã§ãã¢ããªãäœãããšãåºæ¥ãŸã
GASã¯åçš®ãµãŒãã¹äžã§åããããèªååããã ãã®ãã®ã§ã¯ãããŸããããŠã§ãã¢ããªã±ãŒã·ã§ã³ãäœã£ãŠå ¬éããããšãå¯èœã§ããVBAãªã©ã§ã¯å°åºã§ããªãæ©èœã®ïŒã€ã§ãMicrosoft365ã«ãç¡ãæ©èœïŒMicrosoft365ã®å Žåã¯Azureäžã§ãAppServiceçã®ãµãŒãã¹ãå¥éå¥çŽããäžã§ãèªåèªèº«ã§Graph APIãªã©ãããã°ã©ãã³ã°èšèªã§æ§ç¯ããå¿ èŠããããŸãïŒã
èªåãäœæããŠå¥œè©ã ã£ããã®ãäŸã«ããããš
- ããªãŒã¢ãã¬ã¹å¯Ÿå¿ã®åº§åžè¡šã¢ããª
- Googleãã©ãŒã ã§ã¯åºæ¥ãªãé«åºŠãªãã©ãŒã ãå®çŸããç³è«ãã©ãŒã ã¢ããª
- æšæºã§ã¯çšæãããŠããªã瀟å æ²ç€ºæ¿ã¢ããª
- Googleãµã€ãçšã®ã¡ãã£ãšããæ©èœãå®çŸããã¬ãžã§ããã¢ããª
- ã¬ãããªæ¥åå°çšã§äœã蟌ãããŒã¿ããŒã¹ã¢ããª
ã¢ã€ãã¢æ¬¡ç¬¬ã§ããªãªãžãã«ã®ç€Ÿå çšã®ãŠã§ãã¢ããªãæ§ç¯ããããšãã§ããã®ã§ã瀟å ã®èª²é¡ããã床ã«å€éšãµãŒãã¹ãå¥çŽãããœãªã¥ãŒã·ã§ã³å°çïŒã³ã¹ãã®åºå®åãšå¢å€§ã管çæéã®å¢å€§ãèŸããããšãã§ããªããªããã³ããŒããã¯ã€ã³ãªã©ïŒã«é¥ãåã«ãŸãèªåãã¡ã§ãã£ãŠã¿ãããšãå¯èœã§ãããã®èª²é¡ãGASã§ãã£ã¬ã³ãžããŠã¿ãŸãããïŒ
å€éšãµãŒãã¹ã¯äŸ¿å©ã§ãããã£ãã·ã¥ãå€ã«æŒãåºãŠãäžæ¹ã§ç€Ÿå ã«ã¯ããŠããŠãæºãŸããªãåå ã§ãïŒããšãã£ãŠãçµçã人äºã®ã·ã¹ãã ãäœãã®ã¯æè¡ã§ããïŒã
Google Apps Scriptã§ãŠã§ãã¢ããªã±ãŒã·ã§ã³äœæå ¥éãGASã
ãã£ããããããäœãããšãåºæ¥ãŸã
Google Chatã¯ã³ãã¥ãã±ãŒã·ã§ã³ã®ããŒã«ãšããŠã ãã§ã¯ãªããäœæ¥çµæã®éç¥å ãšããŠå©çšããããšçµæ§å©çšé »åºŠãé«ãã§ãïŒTeamsã«æ¯ã¹ããšå šç¶äœæ©èœã ããã©ïŒã
ããããããã«èªåèªèº«ã§æ©èœãè¿œå ããŠãè²ã ãšè§£çããŠããããã£ãããããããäœãããšãããïŒãããGASã§å®çŸå¯èœã§ããGCPåŽã«ãå€å°ã®æºåã¯å¿ èŠã§ããããããããã®ãã£ããããããå€æ³šã§å°å ¥ãããšãããªãããéé¡ã«ãªãäžã«é©ãã»ã©ãããŒãããšããããšããããŸã§äœåºŠããããŸãããçµæã䜿ãããªããªãæã¡æšãŠããããã
ãããGoogle GeminiãChatGPTãšãã£ãå€éšãµãŒãã¹ãçµã¿åãããããšã§ãäœã³ã¹ãã§é«æ©èœãªãã£ããããããèªåãã¡ã§æ§ç¯å¯èœã«ãªããŸãã
Google Apps Scriptã§Google Chatã«ã¡ãã»ãŒãžãéããGASã
Google Chatã®Botã«OpenAIã®chatGPTãç¹ããŠã¿ããGASã
å€éšé£æº
å€éšãµãŒãã¹ãšé£æºãã
äžã®äžã«ã¯ããããã®ãŠã§ããµãŒãã¹ã溢ããŠããŸããäŒèšãœããã®Freeeã§ãã£ããã人äºç®¡çãœããã§ããSmartHRããããžã§ã¯ã管çã®Backlogã§ãã£ãããäŒè°ããŒã«ã®Zoomãªã©ãªã©ã
ãããæåã©ããã®ãŠã§ããµãŒãã¹ã¯äººãæäœããã®ã§ã¯ãªãããã°ã©ã ããæäœããçºã®ãREST APIïŒWebAPIïŒããšåŒã°ããä»çµã¿ãåããŠããŸãã人éããã¡ãã¡ç»é¢ã§ããããããã®ã§ã¯ãªãã³ãŒãã§ã¬ãããªé«éã§æ£ç¢ºã«æäœãå¯èœã«ãªãããããããå€éšé£æºããšèšãããŠããŸãã
人éãè¡ããªãã®ã§äœæ¥æŒãããªããªã£ããã人éã§ã¯å°åºåºæ¥ãªãèžåœãå¯èœãšãªããããåã«ãŠã§ããµãŒãã¹ãå°å ¥ããã ãã ãšæ¥åè² è·ãé«ãŸããŸãããREST APIãæäœããé£æºãå ããããšã§å€§å¹ ã«æ¥åè² è·ãäžããããšãå¯èœã«ãªããŸãã
GASããããããã®APIãå©ããŠåœä»€ããããäžæ¬åŠçããããèªåé£åããããæ§ã ãªããšãåºæ¥ãããã«ãªã£ãŠããŸãïŒVBAã§ã³ã¬ãããã®ã¯ãªããªãã«å€§å€ã§ãïŒã
â»éå»èªåãåãçµãã äºäŸãšããŠã¯ãå šç€Ÿå¡1äžäººå®ãŠã«ããããã®ãŠãŒã¶æ¯ã«ç°ãªãå€æ ã®éäžè¶³ã«é¢ããéç¥ã¡ãŒã«ãREST APIã䜿ã£ãŠäžæé ä¿¡ãªã©ãªã©ããããªã®äººéæ¥ãããšãŠãåºæ¥ãŸããã
Google Apps Scriptã§Claude APIãæ¥æ¬èªã§å©ããŠã¿ã
ç¬èªã®ãŠã§ãAPIãäœãããšãåºæ¥ã
éã«Google Apps ScriptåŽã§ãŠã§ãAPIãæ§ç¯ããŠä»ã®ããã°ã©ã ããå©çšãããšãã£ãããšãå¯èœã«ãªããŸããåãåãããŠããå 容ã«å¿ããŠçããè¿ããŠã¿ãããããããã£ããã«èªååŠçãå®è¡ãããã
éå»èªåãäœã£ãäºäŸã§ããšãGoogle Earthãæäœããçµæã®ç·¯åºŠçµåºŠãéã£ãŠããã®ç·¯åºŠçµåºŠã®ç¯å²å ã«ãããåºãè¿ããšããAPIã移åãã床ã«åãåãããè¡ããããœã¬ã«åºã¥ããŠæ€çŽ¢ãKMLãçæããŠGoogle Earthã«è¿ããšããä»çµã¿ã§ãã
Apps Script APIãå©çšããããšã§çŽæ¥çã«GASã®é¢æ°ãå©ããšãã£ãããšãåºæ¥ãã®ã§ã瀟å ã«æ¢ã«ããããã°ã©ã ã«ãGASãå©ããŠGoogleãµãŒãã¹ãæäœããæ©èœãè¿œå ããããšãå¯èœã«ãªããŸãã
Google Apps Scriptãè²ã ãªã¢ããªããå®è¡ãããGASã
VBAãã䜿ã£ãŠã¿ã
åè¿°ã®èªäœã®APIãGASã§çšæããããGoogleãçšæããŠãREST APIã䜿ã£ãŠGoogleãµãŒãã¹ãæäœãVBAåŽããè¡ããšããããšãå¯èœã§ããããŒã«ã«ã®Excelãšã¯ã©ãŠãã®ã¹ãã¬ããã·ãŒããšãé£æºããããããã¡ã€ã«ãããåããããã
äœãããªãããŒãã«ãé«ãã®ã§å®è£ ããã®ã¯ãªããªãã«æéãæãããŸããã§ãå®çŸã§ãããšGASãšéã£ãŠãå®è¡æéå¶éãç¡ãã®ã§ããŒã«ã«ç°å¢ãVBAã¯æ åœã§ããã®ã§GASã ãã§ã¯åºæ¥ãªãèžåœãå¯èœã«ãªããŸãã
VBAããGoogle Driveã«ãã¡ã€ã«ãã¢ããããŒããã