Googleãã©ãŒã ã«åçã®å ¥åããã£ããšããå ¥åçµæãããŒã ã¡ã³ããŒãã¡ãšãªã¢ã«ã¿ã€ã ã§å ±æããããšæããŸãããïŒ
ãã©ãŒã ã®æ©èœæ¡åŒµã«åœ¹ç«ã€GAS(Google Apps Script)ã§ãè€æ°äººã«åããã¡ãŒã«éç¥ãã§ããŸãã
ãã©ãŒã äœæè 以å€ã®ã¢ãã¬ã¹ãæå®ããã°ãå ¥åå 容ããªã¢ã«ã¿ã€ã ã§å ±æå¯èœã§ããã¹ããŒãæã®ãããåãåãã察å¿ãã§ãã顧客æºè¶³åºŠã®åäžãå³ããŸãã
ãã®èšäºã§ã¯ãäœæè æ¬äººãã¡ãŒã«éç¥ãåãåãæ¹æ³ãšãGASïŒGoogle Apps ScriptïŒã䜿ãè€æ°äººã®æå®ã¢ãã¬ã¹ã«ã¡ãŒã«éç¥ãéãæ¹æ³ã解説ããŸãã
âŒåãããŠèªã¿ããèšäº
ã2023幎å®å
šçãGoogleãã©ãŒã ã®äœ¿ãæ¹ã培åºè§£èª¬ïœäœãæ¹ããäœæäŸãŸã§è©³ãã玹ä»
âŒã¡ãŒã«ãã©ãŒã äœæããŒã«ãformrunããªããéç¥ãåãåãã¡ã³ããŒã®è¿œå ã»åé€ãæš©éèšå®ãªã©ã®æäœãèªç±èªåšïŒ
ã¡ãŒã«éç¥ä»¥å€ã«ãSlackéç¥ãChatworkéç¥ãªã©ã察å¿ããŠãããèªç€Ÿã®ã³ãã¥ãã±ãŒã·ã§ã³ããŒã«ã«åãããéç¥èšå®ãå¯èœã§ãã
ïŒïŒformrunããŸãã¯ç¡æã§å§ãã
ç®æ¬¡
- Googleãã©ãŒã ã®ã¡ãŒã«éç¥â Googleãã©ãŒã ããäœæè ã«
- Googleãã©ãŒã ã®ã¡ãŒã«éç¥â¢GASã䜿ã£ãŠè€æ°äººãž
- Googleãã©ãŒã ããã¡ãŒã«åçéç¥ãæ¥ãªãæã®å¯ŸåŠæ³
- åçè ãžGoogleãã©ãŒã åçå 容ãã¡ãŒã«éç¥ããæ¹æ³
- ãŸãšãïŒformrunïŒãã©ãŒã ã©ã³ïŒãªãããŒã ã®ã¡ãŒã«éç¥èšå®ãç°¡å
Googleãã©ãŒã ã®ã¡ãŒã«éç¥â Googleãã©ãŒã ããäœæè ã«
Googleãã©ãŒã ã§åçã®å ¥åã»éä¿¡ããã£ãéããã©ãŒã äœæè ã«åçãåãåã£ãæšãéç¥ããèšå®ãå¯èœã§ãã
以äžã®æé ã§ãåçéç¥ãèšå®ããŸãããã
ãã©ãŒã 管çç»é¢ã®ãåçããéžæâç»é¢å³(ã¹ãã¬ããã·ãŒãããŒã¯ã®å³æšª)ã®ãäžç¹ãªãŒããŒããã¯ãªãã¯
ãæ°ããåçã«ã€ããŠã®ã¡ãŒã«éç¥ãåãåãããã¯ãªãã¯ã§å®äº
ã¡ãŒã«ã®éç¥èšå®ãçµãããšããã©ãŒã äœæè ã®Googleã¢ã«ãŠã³ãã«ã¡ãŒã«éç¥ãå±ããŸãã
Googleãã©ãŒã ããå±ãã¡ãŒã«ã®éç¥ç»é¢ã¯ã以äžã®éãã§ãã
ãæŠèŠã衚瀺ããã¯ãªãã¯ãããšã管çç»é¢ã®åçããŒãžã«ç§»åããŸãã
Googleãã©ãŒã ã®åºæ¬çãªäœ¿ãæ¹ã¯ä»¥äžã®èšäºã§è§£èª¬ããŠããŸãã
Googleãã©ãŒã ã®ã¡ãŒã«éç¥â¡Googleã¹ãã¬ããã·ãŒãããäœæè ã«
Googleãã©ãŒã ããå ¥åãããåçå 容ã¯ãGoogleã¹ãã¬ããã·ãŒãã§ç®¡çã§ããŸããé£æºãæžãã§ããªãå Žåã¯ã以äžã®æé ã§èšå®ãããŸãããã
管çç»é¢ã®åçã§ã¹ãã¬ããã·ãŒãã®ã¢ã€ã³ã³ãã¯ãªãã¯âã¡ãã¥ãŒããŒã®ãããŒã«ããã¯ãªãã¯âãéç¥ã«ãŒã«ããã¯ãªãã¯
ããŠãŒã¶ãŒããã©ãŒã ãéä¿¡ãããšãããšãã¡ãŒã«-ãã®éœåºŠããéžæâãä¿åããã¯ãªãã¯
éç¥ã®ã¿ã€ãã³ã°ã¯1æ¥1åãéžã¹ãŸãããã¬ã¹ãã³ã¹ã®éããéèŠãããªããã®éœåºŠãããããã§ãã
Googleã¹ãã¬ããã·ãŒãããå±ãã¡ãŒã«ã®éç¥ç»é¢ã¯ã以äžã®ããã«è¡šç€ºãããŸãã
éå»ã®å ¥åå±¥æŽãåçç¶æ³ãäžèŠ§ã§ç¢ºèªããããšãã«äŸ¿å©ã§ãã
Googleãã©ãŒã ã®ã¡ãŒã«éç¥â¢GASã䜿ã£ãŠè€æ°äººãž
äœæè 以å€ã®ã¡ã³ããŒã«ãã©ãŒã åçã®éç¥ãå±ããã«ã¯ãGAS(Google Apps Script)ã䜿ããŸãã
GASã¯GoogleãéçºããŠããããã°ã©ãã³ã°èšèªã§ããGoogle Appsã®æ¡åŒµãé£æºã«åœ¹ç«ã¡ãŸãã
èªåã§éç¥ãåãåãããã©ãŒã åçã®ç®¡çã®è² æ ãæžãããŸãããã
GASã¯Gmail以å€ã§ãã¡ãŒã«éç¥ãåãããã
Googleãã©ãŒã ãæ¡åŒµã§ãããEmail Notifications for Google Formsããã€ã³ã¹ããŒã«ããã°ãèªåè¿ä¿¡ã¡ãŒã«ã®éç¥èšå®ãå¯èœã§ãã
Gmail以å€ã®ã¢ãã¬ã¹ããè€æ°ã®ã¢ãã¬ã¹ãžã®éç¥ãå±ãããããããGoogleã¢ã«ãŠã³ãææè ã代衚ã§ãã©ãŒã ãäœããããŒã å ã®ã¡ã³ããŒã§éç¥ãå ±æã§ããŸãã
ã¿ãã¬ãããã¹ããŒããã©ã³ã§éç¥ãåä¿¡å¯èœãªãããå¶æ¥æ åœè ãªã©ç€Ÿå€ã«åºãããæ©äŒãå€ãæ¹ã䜿ããããä»çµã¿ã§ãã
ç¡æãã©ã³ã䜿ãå Žåã1æ¥ã«å±ããããã¡ãŒã«ã®äžéæ°ã¯20éãŸã§ã§ãã
Gmail以å€ã§éç¥ãåãåãããå Žåã¯ããŸãç¡æãã©ã³ããè©ŠããŠææãã©ã³ãžç§»è¡ããããšãããããããŸãã
æé 1. Googleãã©ãŒã ã®åçéç¥ã«ãã§ãã¯ãå ¥ãã
GASã䜿ãè€æ°äººãžåçéç¥ãéãã«ã¯ã以äžã®æé ãèžã¿ãŸãããã
管çç»é¢ã®åçã®ã¹ãã¬ããã·ãŒãã¢ã€ã³ã³å³æšªã«ãããäžç¹ãªãŒããŒããã¯ãªãã¯âãæ°ããåçã«ã€ããŠã®ã¡ãŒã«éç¥ãåãåããã«ãã§ãã¯
ç»é¢å³äž(Googleã¢ã«ãŠã³ãã®ã¢ã€ã³ã³å·Šæšª)ã«ãããäžç¹ãªãŒããŒããã¯ãªãã¯âãïŒïŒã¹ã¯ãªãã ãšãã£ã¿ããéžæ
æé 2. ã¹ã¯ãªãããšãã£ã¿ãéããŠã³ãŒããæžã
ã¹ã¯ãªãããšãã£ã¿ã«ã³ãŒããæžã蟌ã¿ãŸãã
ããŒãžãéãããšãã«æžãããŠããã³ãŒãã¯ããã¹ãŠåé€ããŠã以äžã®GASã¹ã¯ãªãããã³ããŒ&ããŒã¹ãããŠãã ããã
———————————————————— function sendform(e){ var items = e.response.getItemResponses(); var msg = ”; for (var i = 0; i < items.length; i++) { var item = items[i]; var q = item.getItem().getTitle(); var a = item.getResponse(); msg += q + ‘: ‘ + a + ‘\n\n’; } GmailApp.sendEmail(‘æå®ã¡ãŒã«ã¢ãã¬ã¹’, ‘ã¡ãŒã«ã®ä»¶å’, msg); } ———————————————————— |
ã³ãŒãã®åç
§URLïŒ
Googleãã©ãŒã ã®ã¡ãŒã«éç¥ãæå®ããã¢ãã¬ã¹ã«éãæ¹æ³(Google Apps Script䜿çš)
èµ€åã®ãæå®ã¡ãŒã«ã¢ãã¬ã¹ãã¯ä»»æã®ã¢ãã¬ã¹ããã¡ãŒã«ã®ä»¶åãã¯å¥œããªãã®ã«æžãæããŠãã ãããè€æ°ã¢ãã¬ã¹ã«éããããšãã¯ãã¡ãŒã«ã¢ãã¬ã¹ãã,ïŒã«ã³ãïŒãã§åºåã£ãŠçŸ åããŸãã
ã³ãŒãã®å ¥åãçµãã£ãããããããžã§ã¯ãä¿åãã®ã¢ã€ã³ã³ãã¯ãªãã¯ããŠãããªã¬ãŒã®èšå®ã«ç§»ããŸãã
æé 3. ããªã¬ãŒã®èšå®
ç»é¢å·Šã®é ç®äžèŠ§ãããæèšããŒã¯ããéžæâå³äžã®éãã¿ã³ã+ããªã¬ãŒãè¿œå ããã¯ãªãã¯
ã€ãã³ãã®çš®é¡ãéžæã§ããã©ãŒã éä¿¡æããéžæâãšã©ãŒéç¥èšå®ã§ãä»ããéç¥ãåãåãããéžæâç»é¢ãäžã«ã¹ã¯ããŒã«ããŠãä¿åããã¯ãªãã¯
èšå®ããããªã¬ãŒã¯äžèŠ§ã«ãªã£ãŠè¡šç€ºãããŸããããªã¬ãŒã®èšå®ãŸã§å®äºãããªããšãéç¥ã¯å±ããŸããã®ã§æ³šæããŠãã ããã
以äžãéäžã§ãšã©ãŒãåºãå Žåã®å¯ŸåŠæ³ã§ãã
ãšã©ãŒ | 察åŠæ³ |
---|---|
ãããã¢ãããããã¯ã«ã€ããŠã®ãšã©ãŒ | ã䜿ãã®ããœã³ã³ãããããã¢ãããšãªãã€ã¬ã¯ããèš±å¯ããŠãã ããã |
ãã®ã¢ããªã¯ç¢ºèªãããŠããŸãã | ãšã©ãŒããŒãžå·Šäžã«ããã詳现ããéžæããèš±å¯ããã¯ãªãã¯ããŠæ¿èªäœæ¥ãå®äºãããŠãã ãããããã§ãæäœãå®äºã§ããªãå Žåã¯ãèªèº«ã®Gmailã¢ã«ãŠã³ãå®ã«ãšã©ãŒã¡ãŒã«ãå±ããŠããªãã確èªããã¡ãŒã«æ¬æãããèš±å¯ããå®äºãããŠãã ããã |
Googleãã©ãŒã ããã¡ãŒã«åçéç¥ãæ¥ãªãæã®å¯ŸåŠæ³
Googleãã©ãŒã ããã¡ãŒã«åçéç¥ãæ¥ãªãæã«èããããäž»ãªçç±ã¯ãäžèšã®3ã€ã§ãã
- ç»é²ããã¡ãŒã«ã¢ãã¬ã¹ã確èªãã
- ã¡ãŒã«ã®åä¿¡èšå®ã確èªãã
- è€æ°ã®æ¹æ³ã§éç¥ãåããããããã«ããŠãã
ããããã®å¯ŸåŠæ¹æ³ã説æããŸãã
ç»é²ããã¡ãŒã«ã¢ãã¬ã¹ã確èªãã
Googleãã©ãŒã ãã¹ãã¬ããã·ãŒãã§éç¥ãèšå®ããŠããŠåçéç¥ãåãåããªãå Žåã¯ãGoogleã¢ã«ãŠã³ã(ç»é²ããã¡ãŒã«ã¢ãã¬ã¹)ã®ç¢ºèªãããŠãã ããã
ã¡ãŒã«ã¢ãã¬ã¹ãç»é²ããéãå ¥åãã¹ãããŠããå¯èœæ§ãæ€èšããŸãããã
ãã©ã€ããŒãçšãããžãã¹çšãªã©è€æ°ã®ã¢ã«ãŠã³ããææããŠããå Žåã¯ãéç¥ãåãåãããã«ãããžãã¹çšã®ã¢ã«ãŠã³ããèšå®ããŠããããã§ãã¯ããŠãã ããã
å©çšã¢ã«ãŠã³ããã¢ãã¬ã¹ã®æã¡ééããä¿®æ£ããã°ãåçéç¥ãåãåããŸãã
ã¡ãŒã«ã®åä¿¡èšå®ã確èªãã
Gmail以å€ã§åçéç¥ãåãåããšãéç¥ãè¿·æã¡ãŒã«ã«æ¯ãåããããå¯èœæ§ããããŸãã
è¿·æã¡ãŒã«ã«åé¡ãããªãããã«ãGoogleãã©ãŒã ããã®åä¿¡èš±å¯ãã¡ãŒã«ãµãŒããŒåŽã§èšå®ããŠãããŸãããã
ç»é²ã¢ãã¬ã¹ã®å ¥åã«ééãããªãå Žåã¯ãæãå¯èœæ§ã®ããåå ã§ãã
è€æ°ã®æ¹æ³ã§éç¥ãåããããããã«ããŠãã
GmailãšGmail以å€ã®è€æ°ã¢ãã¬ã¹ãžåçéç¥ãéä¿¡ããèšå®ããããšãéç¥ãåãåããªããã¹ãé²æ¢ã§ããŸãã
äºéã«åããŠããã°ãçæ¹ã«ãã©ãã«ãèµ·ããŠãããäžæ¹ããéç¥ãå±ãä»çµã¿ãäœããŸãã
åçè ãžGoogleãã©ãŒã åçå 容ãã¡ãŒã«éç¥ããæ¹æ³
åçè ãžåçå 容ãèªåè¿ä¿¡ããã«ã¯ãã¡ãŒã«ã¢ãã¬ã¹ãåéããèšå®ãå¿ èŠã§ãã
以äžã®æé ã§èšå®ãå®æœããŠãã ããã
ç»é¢äžéšã®ãèšå®ããã¯ãªãã¯ããŸãã
ãåçãã®èšå®é ç®ãéããŸããâã¡ãŒã«ã¢ãã¬ã¹ãåéããã§åéæ¹æ³ãéžæããŸããâåçã®ã³ããŒãåçè ã«éä¿¡ããåžžã«è¡šç€ºãã«å€æŽããŠãã ããã
åçã®ç·šéãèš±å¯ãã ãããªã³ãã«ãããšãåçè ãåçéä¿¡åŸã«å 容修æ£ã§ããä»æ§ã«å€æŽå¯èœã§ãã
ãã©ãŒã ã®ãã¬ãã¥ãŒç»é¢ãžç§»ããç»é¢ãäžéšãžã¹ã¯ããŒã«ããŸããâéä¿¡ãã¿ã³ã®äžéšã«ãåçã®ã³ããŒãæå®ããã¢ãã¬ã¹ã«ã¡ãŒã«ã§éä¿¡ãããŸããããšè¡šç€ºãããŠããã°ãèšå®å®äºã§ãã
ãŸãšãïŒformrunïŒãã©ãŒã ã©ã³ïŒãªãããŒã ã®ã¡ãŒã«éç¥èšå®ãç°¡å
Googleãã©ãŒã ã䜿ã£ãã¡ãŒã«éç¥èšå®ã¯ãäœæããåãã©ãŒã ã§èšå®ããå¿ èŠããããŸãã
ããŒã äœå¶ã§ãåãåãã察å¿ãããŠããå Žåã¯ãã¡ã³ããŒãå ¥ãæ¿ããããšã«ã³ãŒããæžãæããªããã°ãããŸããã
ãã©ãŒã 管çããã£ãšç°¡åã«ããããšèããŠããæ¹ã«ãããããããã®ããåŒç€ŸãæäŸããŠããã¡ãŒã«ãã©ãŒã äœæããŒã«ãformrunãã§ãã
æäœæ§ã®é«ããšç¡æã§äœ¿ãããæé ããé åã§ãéç¥ãåãåãã¡ã³ããŒã®è¿œå ã»åé€ã»æš©éèšå®ãªã©ã®æäœãå¯èœã§ãã
Slackéç¥ãChatworkéç¥ãªã©ã®ãã£ããããŒã«ãšé£æºããã°ãæ å ±å ±æãã³ãã¥ãã±ãŒã·ã§ã³ãæéãªãåãåããŸãã
ãformrunãã掻çšããŠãç°¡åã§æŒãã®ãªããã©ãŒã 管çãç®æããŠãã ããã
formrunããã©ãŒã äœæã顧客管çã«é¢ããæ å ±ãçºä¿¡ããŠãããŸãã
EFOïŒãšã³ããªãŒãã©ãŒã æé©åïŒãåãåãã察å¿ãªã©ã
ãã©ãŒã ã«é¢ãããæ©ã¿ã解決ããŸãã