
ããŒãããæžãã³ãŒãã¯ãæ¬åœã«å®ãã®ãã忥ããããã°ã§æœ°ã人ãèšç®ããé€å€ããŠãããèªåã®äººçã®æçµŠã
ãããã°ã©ãã³ã°ãåŠãã§èªåã§æžãã°ãéçºè²»ã¯å®è³ªãŒãåã«ãªãã
ç¬åŠã§PythonãGASïŒGoogle Apps ScriptïŒãåŠã³å§ããæ¥ã
ã®æ¥åèªååã«æãããšãã人ããã»ãŒäŸå€ãªãæåã«åãããçãé¯èŠã§ãã
æ¢åã®SaaSããŒã«ãå°å
¥ããã«ã¯æé¡è²»çšããããã
ãšã³ãžãã¢ã«å€æ³šéçºãé Œãã°æ°åäžåããçŸäžååäœã®è«æ±ãæ¥ãã
ã ãããèªåã§èª¿ã¹ãŠã³ãŒããæžãã°ããéã1åããããã«æ¥åãå¹çåã§ããã
äžèŠãããšã極ããŠè³¢ãã³ã¹ãæèã®é«ãéžæã®ããã«æããŸãã
ãããããšã³ãžãã¢ã®èŠç¹ã§ãæéçè³æ¬ã®ROIïŒæè³å¯Ÿå¹æïŒããå·åŸ¹ã«èšç®ãããšããããã»ã©äžçµæžã§é«ãã€ãè²·ãç©ã¯ãããŸããã
ãªããªãããã®èšç®åŒã®äžããã¯ãèªåèªèº«ã®æéããšããã人çã§äºåºŠãšè²·ãæ»ããªãæéã®è³ç£ãå®å šã«æãèœã¡ãŠããããã§ãã
â ãç¡æããšããçãèšèã®è£ã§æº¶ããŠããæé
æ¥åã§äœ¿ãã¹ã¯ãªããããŒãããæžãããšãããšããå®éã«äœãèµ·ãããã
æ§æã®åºç€ã調ã¹ãAPIã®å
¬åŒããã¥ã¡ã³ããèªã¿è§£ããQiitaãããã°ã®æççãªã³ãŒããã³ããããŠæå
ã®ç°å¢ã«åãããŠæçŽãããããã®æ®µéãŸã§ã¯ãããã°ã©ãã³ã°åŠç¿ã®å»¶é·ãšããŠç¥çè奮ããèŠãããããããŸããã
ããããæ¬çªã®æ³¥æ²Œã¯ãã³ãŒããæžãçµããŠåããããšããç¬éãããå§ãŸããŸãã
ã»æå
ã®ããœã³ã³ã§ã¯åããã®ã«ããµãŒããŒãã¯ã©ãŠãã«èŒããé端ã«åããªããªã
ã»æåã³ãŒãã®éãã§CSVãåããåå äžæã®ãšã©ãŒã§åŠçãäžæ£çµäºãã
ã»APIã®èªèšŒããŒã¯ã³ãæ°æéã§å€±å¹ããå€éã®å®æå®è¡ãæ¯ææ¢ãŸã£ãŠãã
ã»Googleã®å®è¡æéå¶éïŒ6åã®å£ïŒã«åŒã£ãããã倧éããŒã¿ãéäžã§æ¶ãã
ç»é¢ã«åãåºãããèµ€æåã®ãšã©ãŒãã°ãæ€çŽ¢çªã«ãšã©ãŒã¡ãã»ãŒãžã貌ãä»ããæµ·å€ã®éçºãã©ãŒã©ã ãè¡ãæ¥ãã倿°ãæžãæããŠã¯åå®è¡ããã
ãããš1ç®æçŽãã°åãã¯ãã ããšæããªãã詊è¡é¯èª€ãç¹°ãè¿ãããµãšé¡ãäžãããšãã«ã¯ãäŒæ¥ã®è²Žéãªåææ¥ãšæ¥ææ¥ãäžžã
2æ¥ãæåéãç»é¢ã®åã«æº¶ããŠæ¶ããŠããŸãã
ããã§ã鱿ãã«ç¡äºåãã°ãŸã æãããããŸãããå®åç°å¢ã®äŸå€çãªããŒã¿ïŒç©ºæ¬ãå šè§æåãäºæãã¬æ¹è¡ïŒãäžåºŠèžãã ã ãã§ãã¹ã¯ãªããã¯å®¹èµŠãªãåã³æ²é»ããŸãã
ãŒãããæžããã³ãŒãã¯ã決ããŠç¡æã§ã¯ãããŸããã
ããªãã®ã貎éãªäŒæ¥ããšãã代åããééãªãé£ãã€ã¶ãç¶ããŠããã®ã§ãã
â ã人çã®æçµŠãã§æç®ãããšãããã®ã³ãŒãã¯ãããã«ãªãã®ã
ããã§ã極ããŠå·é
·ãªç®å®ãããŠã¿ãŸãã
ä»®ã«ãããªãã®æ¬æ¥ã«ãããã¹ãã«ãçç£æ§ãéã¿ãŠã1æéã®äŸ¡å€ïŒæéå䟡ïŒãæ§ããã«ã4,000åããšèšå®ããŠã¿ãŸãããã
ã»æ§æã調ã¹ãåæã³ãŒããçµã¿äžãããŸã§ã®æéïŒ10æé
ã»API飿ºãèªèšŒèšå®ã®è©°ãŸããè§£æ¶ããæéïŒ8æé
ã»äŒæ¥ã«ãšã©ãŒãã°ãšæ Œéãããããã°æéïŒ12æé
ã»é±æãã«çŸå Žã®äŸå€ããŒã¿ã§æ¢ãŸããåæ¹ä¿®ã«è²»ãããæéïŒ6æé
åèšãããšããã£ã1æ¬ã®å°ããªèªååã¹ã¯ãªãããããšããããåãç¶æ ãã«ãããŸã§ã«ã36æéãšããèšå€§ãªãªãœãŒã¹ãèªãæäžããŠããŸãã
4,000å à 36æé ïŒ 144,000å
ãèªåã§äœã£ãããã¿ããã ãšæã蟌ãã§ãããã®ããŒã«ã®è£åŽã«ã¯ãå®ã«14äžå以äžã®ããªãèªèº«ã®äººä»¶è²»ãåæ²¡ããŠããŸãã
ããã«æãããã®ã¯ããã®14äžåãæããŠæã«å
¥ããèªäœã³ãŒãããæ¬çªç°å¢ã®é·æéçšã«èããããå
ç¢ãªã¢ãŒããã¯ãã£ãã«ãªã£ãŠããä¿èšŒã¯ã©ãã«ããªããšããç¹ã§ãã
ãšã©ãŒéç¥ã®ä»çµã¿ããéä¿¡éçµ¶æã®èªåãªãã©ã€ããç§å¯æ
å ±ã®ç°å¢å€æ°åé¢ãçµã¿èŸŒãŸããŠããªããããä»åŸã仿§å€æŽããšã©ãŒãèµ·ãããã³ã«ãããªãã®äººçã®æçµŠã¯ééãªãåžãåããç¶ããŸãã
ããéãç¯çŽããã€ããã§ããã£ãšãé«äŸ¡ãªèªåã®å¯åŠåæéãããã«æšãŠãŠããããšããäºå®ã«æ°ã¥ãããšããå€ãã®äººãæ·±ãåŸåŽæã«è¥²ãããŸãã
â ãããäœåæéããããŠçµã¿äžãããè£åŽã®æ³¥èãã
ãªããåå¿è
ãæžãã¹ã¯ãªããã¯ããã»ã©ãŸã§ã«æéã奪ãã®ãã
ããã¯ãããã®ãšã³ãžãã¢ãå®åã§åããããã°ã©ã ã®ãèŠããªã9å²ããåçŸããããšããŠããããã§ãã
ããã°ã©ã ã®ãäž»åŠçïŒããŒã¿ãåã£ãŠããŠæžãåºãïŒãèªäœã¯ãå
šäœã®ã»ãã®1å²ã«éããŸããã
æ®ãã®9å²ã¯ã以äžã®ãããªæ¥µããŠæ³¥èãé²å£èšèšã«è²»ããããŠããŸãã
ã»å€éšãµãŒããŒã®ã¿ã€ã ã¢ãŠãã«åãããšã¯ã¹ããã³ã·ã£ã«ã»ããã¯ãªãïŒå詊è¡å¶åŸ¡ïŒ
ã»äººéãå
¥åãããã©ãã©ãªããŒã¿åœ¢åŒãæ©æ¢°å¯èªãªæ§é ãžæ£èŠåããååŠç
ã»ç§å¯éµãAPIããŒãã³ãŒãããå®å
šã«åãé¢ããæŒæŽ©ãç©ççã«é²ãç°å¢å€æ°ç®¡ç
ã»ã·ã¹ãã ã忢ããéãåå ãããªç§åäœã§ç¹å®ã§ããããã«ãã詳现ãªãã®ã³ã°
ããããå
ç¢ãªããžãã¯ã¯ãæç§æžãæ°ããŒãžèªãã çšåºŠã§çµãããã®ã§ã¯ãããŸããã
çŸå Žã§æ°ã
ã®é害ã仿§å€æŽãæ³å®ããäœåæéãã®å®åæ€èšŒãšãã¹ããçµãŠåããŠåãåºããããã®ã§ãã
åå¿è ããŒããããã®ã¬ãã«ã®åºç€ãçµã¿äžããããšããããšèªäœãç¡è¬ã§ãããããã«åæ¥ãè²»ããã®ã¯ãæè¡ã®ç¿åŸãã§ã¯ãªããåãªããè»èŒªã®åçºæã«ããæ¶èãã«éããŸããã
ãããŠäœãããçŸå Žã®å®åæ åœè ãæ¬åœã«æã«å ¥ãããã®ã¯ããšã©ãŒãã°ãšæŠãèŠè¡ãã§ã¯ãªãããæ¥ã ã®æäœæ¥ãå®å šã«æ¶ãå»ã£ãå¿«é©ãªç°å¢ãã®ã¯ãã§ãã
â è€éããè£ã«éã蟌ããã䜿ãåŽãã¯ã³ããã§çµãããã
çã«æŽç·Žãããèªåååºç€ãšã¯ãè£åŽããè€éæªå¥ãªäŸå€åŠçã§ã¬ãã¬ãã«åºããããŠããŸããã衚åŽã®ã€ã³ã¿ãŒãã§ãŒã¹ã¯æ¥µéãŸã§ç°¡æœã«åãèœãšãããŠããŸãã
èªèšŒèšå®ã®IDãæå®ã®å Žæã«è²Œãä»ããã ãã
ã¹ã¯ãªãããã¡ã€ã«ããã©ã€ãã«é
眮ããŠå®è¡ã1åæŒãã ãã
ã¹ãã¬ããã·ãŒãã®æå®åã«å¿
èŠãªããŒãå
¥åããã ãã
è£åŽã§ãããäœåæéãã®ãããã°ãšæ€èšŒãæžãŸããŠãããããããåãåãåŽã¯è€éãªã¢ã«ãŽãªãºã ãããã°ã©ãã³ã°èšèªã®ä»æ§ã«æ©ãŸãããå¿
èŠããããŸããã
ãããæ°åã®ã»ããã¢ããã ãã§ãæ¬æ¥äœåæéããããã¯ãã ã£ãèªååã®æ©æµãã忥ãã100%享åããããšãã§ããŸãã
ããéãæãããšããè¡çºã®æ¬åœã®æå³ã¯ãåãªãããã¹ããã³ãŒãã®æååãè²·ãããšã§ã¯ãããŸããã
ãããéå»ã«è²»ãããèšå€§ãªè©Šè¡é¯èª€ãæ€èšŒããããã°ã®æéãäžžããšè©ä»£ããããããæ¬æ¥å€±ãã¯ãã ã£ãèªåã®äœåæéãã®èªç±ãè²·ãæ»ãããšãã«ä»ãªããŸããã
â ããªãã®ç®ã®åã«ããã2ã€ã®æªæ¥ã
ä»ãããªãã®æå ã«ã¯2ã€ã®æªæ¥ãåºãã£ãŠããŸãã
1ã€ã¯ããèªåã§äœãã°ç¡æã ããããšä¿¡ã蟌ã¿ã次ã®é±æ«ãç»é¢ã®åã§èµ€æåã®ãšã©ãŒãã°ãšçšã¿åãéã§ãã
äœåæéãã®äººçã®æçµŠãæº¶ãããå®¶æãè¶£å³ãšéããã¯ãã ã£ãäŒæ¥ãåããåããªãããã°ã©ã ã«ããæ¯ãã€ãç¶ããæªæ¥ã§ãã
ãã1ã€ã¯ãè£åŽã®æ³¥èãæ€èšŒãšèšèšããã§ã«å®äºããŠããã宿ãããè³ç£ããè¿·ããæã«åãããããæ°åã®é çœ®äœæ¥ã§æ¥åãèªååããŠããŸãéã§ãã
æµ®ããäœåæéãã®æéããæ¬æ¥ã®ã¯ãªãšã€ãã£ããªæŠç¥ç«æ¡ã«å
ãŠãã®ãã
æ°ããããžãã¹ã®ç«ã¡äžãã«äœ¿ãã®ãã
ãããã¯ãããœã³ã³ãéããŠå€§åãªäººãšéããè±ããªäŒæ¥ã«å€ããã®ãã
èªåã®äººçã®æçµŠãå®å£²ãããŠæ¶èãç¶ããããã¹ããŒãã«æéãè²·ã£ãŠåã«é²ããã
ãã®å€æã®åºæºã¯ããã¹ãŠããªãèªèº«ã®æã®äžã«ãããŸãã
ããããïœå®åç¹åã®èªååæŠç¥ã©ãããã®ãæ¡å ã
åœã©ãã§ã¯ãGASïŒGoogle Apps ScriptïŒãPythonã«ããèªååã¹ã¯ãªãããã¯ãããGoogleã¹ãã¬ããã·ãŒããExcelã§ãã®ãŸãŸäœ¿ãã管çã·ãŒãããã£ãã飿ºAPIãåçš®ãã¹ã¿ãŒããŒã¿ãªã©ãå®åã§å³çšŒåããããžã¿ã«è³ç£ããçšæããŠããŸãã
ãŒãããæ§æã調ã¹ãçµããã®èŠããªããããã°ã«äŒæ¥ã溶ããå¿
èŠã¯ãããŸããã
å®åã®çŸå Žãæ³å®ããŠèšèšã»æ€èšŒããã£ãå
ç¢ãªããžãã¯ããããªãã®ç°å¢ãžãã®ãŸãŸé
眮ã»é©çšããŠãã ããã
ç¡é§ãªè©Šè¡é¯èª€ãäžåæé€ããæ¥ã ã®ã«ãŒãã£ã³ã¯ãŒã¯ãæéã§èªååã»ã·ã¹ãã åãããæ¹ã«ã¯ãç ©éãªæ¥åãæ ¹çµ¶ããã¹ã¯ãªãããšå®çšããŒã«çŸ€ãããã±ãŒãžåããð¢ð èªååã»å®åå¹çåç¹åãã©ã³ããŸãã¯å šè³ç£ãžãã€ã¬ã¯ãã«ã¢ã¯ã»ã¹ã§ããå šããžã¿ã«è³ç£ã»ãã¹ã¿ãŒã€ã³ããã¯ã¹ã®ç¢ºèªãããããããŸãã
èªåã§æéãæµªè²»ããåŽãããæéãè²·ã£ãŠè»œããã«ææãåºãåŽãžã
ããªãã®å®åç°å¢ãã仿¥ããã¢ããããŒãããŠã¿ãŠãã ããã
âŒ å šããžã¿ã«è³ç£ã»ãã¹ã¿ãŒã€ã³ããã¯ã¹ã¯ãã¡ã
⌠ã¡ã³ããŒã·ããã®è©³çްã»ãåå ã¯ãã¡ã
#ããã #èªååæŠç¥ #æ¥åå¹çå #ããã°ã©ãã³ã° #Python #GAS #ã·ã¹ãã éçº #æ¥åæ¹å #DXæšé² #æè³å¯Ÿå¹æ #æé管ç #note #ã¡ã³ããŒã·ãã