Form Notifications: Google Forms⢠ã®ã¡ãŒã«éç¥ã»æ¯ãåãã»æ¿èªããŸãšããŠè¡ãã¢ããªã³ã§ããã¡ãŒã«ãSlackãDiscordãMicrosoft TeamsãWebhook ã®ã«ãŒã«ãšæ¿èªã¹ãããã 1 ãæã§ç®¡çã§ããŸãããã©ãŒã ã«åçãå±ããåŸã®æµããèªååã§ããŸããé©åãªã¡ãã»ãŒãžãéä¿¡ãããé©åãªæ
åœè
ãæ¿èªãããŸã§ãæäœæ¥ã¯äžåãããŸããã
ð èšå®ã§ã¯ãªãã«ãŒã«
ãã©ãŒã ã«ã¯ã«ãŒã«ã®äžèЧããããŸããåã«ãŒã«ã§ããã€éãããã©ã®åçã«äžèŽãããšãã ãéãããã©ã®ãã£ã³ãã«ã§ãã©ããžãã©ããªå
容ãéãããæ±ºããŸããã«ãŒã«ã¯å¿
èŠãªã ã远å ã§ãã1 ãæã ãå€ããããšãã¯è€è£œããåé€ããã«ãªãã«ããããšãã§ããŸããã+ æ°ããã«ãŒã«ããæŒããšãããã€ããã©ããžããã¡ãã»ãŒãžãã® 3 ã¹ãããã®ãŠã£ã¶ãŒããéããŸãã
ð éä¿¡çŽåŸã®ã¡ãŒã«éç¥ãšã¢ã©ãŒã
ãã©ãŒã ãéä¿¡ããããã®ç¬éã«ãèªåã«ããããŒã ã«ããåçè
æ¬äººã«ãã¡ãŒã«ãéããŸããéä¿¡æã«éãã¡ãŒã«ã®ã«ãŒã«ã¯ãè©ŠçšæéåŸãç¡æã§äœ¿ããŸãã
ð åçã«ããæ¯ãåã
ã«ãŒã«ã«ã次ã®å Žåã®ã¿ãã®æ¡ä»¶ã远å ãããšãäžéšã®åçã ãã«éä¿¡ã§ããŸããAND / OR ã®çµã¿åããã«ã察å¿ã1 ã€ã®ãã©ãŒã ããè€æ°ã®éãå
ãžãããããå°çšã®ã«ãŒã«ã§å±ããŸãã
âïž ã¡ãã»ãŒãžãšå·®ã蟌ã¿ãã£ãŒã«ã
ããžã¥ã¢ã«ãšãã£ã¿ã§æ¬æ Œç㪠HTML ã¡ãŒã«ãäœæã§ããŸãããã©ãŒã ã®èšåããå·®ã蟌ã¿ãã£ãŒã«ã ({{åå}}ã{{ã¡ãŒã«}}ã{{ä»¶å}}) ãæ¿å
¥ããã ãã§ãããã£ãããžã®æçš¿ããåãã¿ã°ã䜿ã£ã 1 ã€ã®ããã¹ãã§éããŸãã
â
ã«ãŒã«ã® 1 ã¹ããããšããŠã®æ¿èª
ä»»æã®ã«ãŒã«ã«æ¿èªã¹ãããã远å ã§ããŸããæ¿èªè
ã¯ã¡ãŒã«ã§åãåãæ
åœè
ããæ¿èªã»åŽäžãã¿ã³ä»ãã® SlackãDiscordãTeams ã®ãã£ã³ãã«ã§ããã«ãŒã«ã¯ãæ¿èªåŸã®ã¿ããŸãã¯ãåŽäžæãã«éä¿¡ãããã®å€æã«åŸã£ãŠåããŸããåãæ¿èªè
ãåŸ
ã€è€æ°ã®ã«ãŒã«ã¯ã1 ä»¶ã®åçã«ã€ãæ¿èªäŸé Œã 1 åã ãå
±æããŸãã(ä»ã® Forms éç¥ã¢ããªã³ã«ã¯ãªãæ©èœã§ãã)
ð¬ Slackã»Discordã»Microsoft Teams
ã«ãŒã«ãäœæãããšãã«ãã£ã³ãã«ãéžã³ãŸããåçãå±ããç¬éã«ãSlack ã®ãã£ã³ãã«ãDiscord ã®ãµãŒããŒãMicrosoft Teams ã®ãã£ã³ãã«ãžãå·®ã蟌ã¿ã¿ã°ã§æžããã¡ãã»ãŒãžãæçš¿ããŸãããã£ã³ãã«ããšã« 1 ã€ã®ã«ãŒã«ã§ãã
ð Zapierã»Makeã»èªåãšã³ããã€ã³ãåã Webhook
Webhook ã®ã«ãŒã«ã¯ãååçã JSON ãšããŠä»»æã® HTTPS ãšã³ããã€ã³ããžéä¿¡ããŸããZapier ã Make ã® Webhook ã§ããèªåã§éçšãããµãŒããŒã§ãæ§ããŸããããã¹ãŠã®ãã€ããŒãã¯çœ²åä»ããªã®ã§ããšã³ããã€ã³ãåŽã§ãã©ãŒã ããã®éä¿¡ã§ããããšãæ€èšŒã§ããŸãããšã³ããã€ã³ããæ¶ããå Žåã¯ã«ãŒã«ãäžæåæ¢ããã¡ãŒã«ã 1 åã ããç¥ããããŸãã
â±ïž éä¿¡ã¿ã€ãã³ã°: æ¯åã®åçã»æ¿èªåŸã»åŽäžæ
åã«ãŒã«ã¯ 1 ã€ã®ã€ãã³ãã§éä¿¡ããŸããæ¯åã®åçãæ¿èªåŸã®ã¿ãåŽäžæã®ããããã§ããæ¿èªã€ãã³ãã®ã¡ãŒã«ã¯ããªãã® Gmail ã§ã¯ãªããSkyfield ã®ã¡ãŒã«é
ä¿¡ãµãŒãã¹ããå±ããŸãã
â©ïž è¿ä¿¡å
ã®æå®ã»CCã»ç¢ºèªã¡ãŒã«
ã¡ãŒã«ã®ã«ãŒã«ã¯ããªãèªèº«ã® Gmail ã¢ãã¬ã¹ããéä¿¡ããããããè¿ä¿¡ã¯ãã®ãŸãŸããªãã«æ»ããŸããåçè
å®ãŠã«èšå®ããããšãã§ããã©ã®ã«ãŒã«ã«ã CC ãš BCC ã远å ã§ããŸãã
ð éä¿¡å±¥æŽãš Google Sheets ãžã®æžãåºã
éä¿¡ã»æ¿èªã»å€±æã®ãã¹ãŠããçµã¿èŸŒã¿ã®ãã°ã§åçè
åããæ€çŽ¢ã§ããŸããå±¥æŽã¯ãã€ã§ã Google Sheetâ¢ ã«æžãåºããŸãã
â¡ ããããèšå®
äžåºŠã€ã³ã¹ããŒã«ããã°ããã¹ãŠã®ãã©ãŒã ã§äœ¿ããŸããã³ãŒãäžèŠã3 ã€ã®ãã³ãã¬ãŒãã§ãæ°ãããã©ãŒã ãã¯ã³ã¯ãªãã¯ã§å§ããããŸããããã¹ãŠã®åçãã¡ãŒã«ã§åãåããããã¹ãŠã®åçã Slack ã«æçš¿ããããæ¿èªãåŸ
ã£ãŠããã¡ãŒã«ãããã§ãã
ââââââââââââââââââââ
ð¯ Form Notifications ã®äœ¿ããæ¹
ðš èªåã§æ¯ãåããããåãåãããã©ãŒã
ãå¶æ¥ããžã®åãåããã¯å¶æ¥æ
åœãžãããµããŒããã¯ãã«ããã¹ã¯ãžãåçå
容ã«ããšã¥ãæ¯ãåãã§ãæ¯åãµããããçžæã«éç¥ãå±ããŸããéãå
ããšã« 1 ã€ã®ã«ãŒã«ãäœããããããã«æ¡ä»¶ãä»ããããŸããéšçœ²ã®æ
åœè
ãå
±æã¡ãŒã«ããã¯ã¹ãããŒã ã®åä¿¡ç®±ãžã2 ã€ç®ã®ãã©ãŒã ãäœããã«æ¯ãåããããŸããæ°ããåçãå±ããã³ã«éç¥ããããããŒã å
šäœã«ç¥ãããããèšé²ã ãéãã«æ®ããããã©ãŒã ã«åãããŠéžã¹ãŸããåçã¿ããäœåºŠãéãçŽãå¿
èŠã¯ãããŸããã
𧟠決è£ãå¿
èŠãªç³è«
ã«ãŒã«ã«æ¿èªã¹ãããã远å ãããšãæ¡ä»¶ã«äžèŽããéä¿¡å
容ããŸãæ¿èªè
ã«å±ããŸãã賌買ç³è«ãäŒæç³è«ãå皮決è£ã«æé©ã§ããã¡ãŒã«ã®äžã«æ¿èªãªã³ã¯ãšåŽäžãªã³ã¯ããããã¯ã³ã¯ãªãã¯ã§å®äºããŸãããã°ã€ã³äžèŠãã¢ã«ãŠã³ãäœæãäžèŠãçžæåŽã«äœããå
¥ããŠãããå¿
èŠããããŸããããæ¿èªåŸã®ã¿ãã«éãã«ãŒã«ã¯æ¿èªãããç¬éã«ç³è«è
ãžã¡ãŒã«ãããåŽäžæãã«éãã«ãŒã«ã¯çç±ãäŒããŸããåãæ¿èªè
ãåŸ
ã€è€æ°ã®ã«ãŒã«ã¯ 1 ä»¶ã®æ¿èªäŸé Œãå
±æããã®ã§ã1 åã®å€æã§ãã¹ãŠãåããŸããåçããšã®æ¿èªç¶æ³ã远跡ã§ããã®ã§ãæªåŠçã®ãã®ãšæ±ºè£æžã¿ã®ãã®ãäžç®ã§åãããŸããå¥ã®ã¯ãŒã¯ãããŒããŒã«ãçšæããªããŠããæ¿èªãèªååã§ããŸããçµè²»ç²Ÿç®ãäŒæç³è«ããããŸã§æäœæ¥ã§åããŠããäžé·ã®ç¢ºèªæé ã«ããã®ãŸãŸäœ¿ããŸãã
ð åçè
ã«ãç¶æ³ãäŒãã
ãã©ãŒã ã«å
¥åãã人ãžã¯ãéä¿¡çŽåŸã«èªåè¿ä¿¡ãéããŸããéä¿¡å
å®¹ã®æ§ããå
Œãã確èªã¡ãŒã«ã§ããGoogle Forms⢠ã®èªåè¿ä¿¡ã¡ãŒã« (ãªãŒãã¬ã¹ãã³ããŒ) ãšããŠåããåçãå±ããç¬éã«ãããããžè¿ä¿¡ãéãããŸããå·®ã蟌ã¿ãã£ãŒã«ããåçãæ¬æã«èªåã§é
眮ããä»¶åã«ãåæ ã§ãããããåãåã人ããšã«å
容ãå€ããããã©ã³ãã«åãããããŒãœãã©ã€ãºãããã¡ãŒã«ã«ãªããŸããäžåžãå
±æã¡ãŒã«ããã¯ã¹ã«ãå±ããããšãã¯ãã©ã®ã«ãŒã«ã«ã CC ã BCC ã§å®å
ã远å ã§ããŸãã
ð¬ ãã£ããã§ä»äºãããããŒã
ããŒã ãæ®æ®µäœ¿ã£ãŠãããã£ã³ãã«ã«æ°ããåçãæçš¿ã§ããŸããå¶æ¥åãåãã㯠Slack ã®ãã£ã³ãã«ãžãã³ãã¥ããã£ç»é²ã¯ Discord ã®ãµãŒããŒãžã瀟å
ç³è«ã¯ Teams ã®ãã£ã³ãã«ãžããã£ã³ãã«ãæ¿èªè
ã«ããã°ãããŒã ã¯ãã®ã¡ãã»ãŒãžãã倿ã§ããçµæã¯ãã£ã³ãã«ã«æžãæ»ãããŸããåçãå¥ã®å Žæãžå±ããããšãã¯ãWebhook ã®ã«ãŒã«ã§ ZapierãMakeããŸãã¯èªç€Ÿã·ã¹ãã ãžæž¡ããŸãã
ðïž å®éã«äœãéãããããææ¡ãã
éä¿¡ã»æ¿èªã»å€±æã®ãã¹ãŠãéä¿¡å±¥æŽã«æ®ããããéä¿¡ã«å€±æããã¡ãã»ãŒãžãèŠéããã«ç¢ºèªã§ããŸããã¢ããªã³ã®å€ã§æ±ããããšãã¯ãå±¥æŽããŸãããš Google Sheetâ¢ ã«æžãåºããŸãããªãã©ã€ã³ã®éãã«ãŒã«ã¯éä¿¡ãç¶ããŸãã
â
ãããªçšéã«æé©:
ðš ãåãåãããã©ãŒã
ð¯ æ
åœè
ãžã®åŒãåãã®æ¯ãåã
ð ãã«ããã¹ã¯ãšãµããŒãåä»
𧟠賌買ã»çµè²»ã®æ¿èª
ðïž ã€ãã³ãç³èŸŒã®ç¢ºèªã¡ãŒã«
ð¢ 瀟å
ç³è«ãã©ãŒã
ð åºé¡ã»å
¥åŠã«é¢ããéç¥
ð¬ Slackã»Discordã»Teams ãžã®ããŒã éç¥
ð Zapierã»Makeã»èªç€Ÿã·ã¹ãã ãžã®åãæž¡ã
ð Form Notifications ã 7 æ¥éç¡æã§ã詊ããã ããããã¹ãŠã®æ©èœã䜿ããŸãããã®åŸãéä¿¡æã®ã¡ãŒã«ã®ã«ãŒã«ã¯ç¡æã§ãããã£ãããWebhookãæ¿èªã®ã«ãŒã«ã«ã¯æå¹ãªã©ã€ã»ã³ã¹ãå¿
èŠã§ãã
- ãã¹ãŠã® Google Forms⢠ã«å¯Ÿå¿ (å人ã»Workspace)
- åçæã®ã¡ãŒã«ã¯ããªãèªèº«ã® Gmail ã¢ãã¬ã¹ããéä¿¡ãããŸã
- ãã£ãããš Webhook ã® URL ã¯æå·åããŠä¿åãããŸã
- ãã¹ãŠã®ã«ãŒã«ã§ AND / OR ã®æ¡ä»¶ã«å¯Ÿå¿
- ã«ãŒã«ãšã¡ãã»ãŒãžã¯ Skyfield ã®ãµãŒããŒã«å®å
šã«ä¿åãããŸããåçã¯éä¿¡ã®ããã ãã«åŠçãããŸã
- ãã©ãŒã ããšã«ç¬èªã®ã«ãŒã«
Google Forms⢠㯠Google LLC ã®åæšã§ã