
Apps Script ãããžã§ã¯ããçµ±åããæé ãšæ³šæç¹ïŒåå¿è åããŸãšãïŒ
ã¯ããã«ïŒGASã®ã³ãŒããããŸãšãããïŒããšæã£ãã
Google ã¹ãã¬ããã·ãŒãããã©ãŒã ã«çŽã¥ãã Apps ScriptïŒGASïŒãéçšããŠãããšã
ãå¥ã®ãããžã§ã¯ãã§äœã£ãã³ãŒããçµ±åãããïŒããšããå Žé¢ãåºãŠããŸãã
ã§ãããã ã³ããããã°ããâŠãšããããã§ã¯ãããŸããã
èšå®ãã¡ã€ã«ã®ããŒãžãã颿°åã®ç«¶åãšãã£ãåå¿è
ãã€ãŸããããããã€ã³ãããããŸãã
ãã®èšäºã§ã¯ãç§èªèº«ãå®éã«çµ±åäœæ¥ããããšãã®æµããã
ãçå â 解決ã圢åŒã§ãŸãšããŸããã
ããããåãäœæ¥ãããæ¹ã®åèã«ãªãã°å¬ããã§ãã
æé â ãããžã§ã¯ãã®æºå
ãŸãã¯çµ±åå
ïŒæçµçã«äœ¿ãããã¹ãã¬ããã·ãŒãã«çŽã¥ããGASãããžã§ã¯ãïŒãéããŸãã
ããã«å¥ãããžã§ã¯ãããã³ãŒããã³ããŒããŠè¿œå ããŠãããŸãã
ð ãã€ã³ã
.gs ãã¡ã€ã«ã¯è€æ°OKã圹å²ããšã«ãã¡ã€ã«ãåãããšãããããã
appsscript.json ã¯1ã€ããååšã§ããªãã®ã§ãåŸã§ããŒãžãå¿ èŠ
æé â¡ appsscript.json ãçµ±åãã
ãããæåã®ããããã€ã³ãã
çæ¹ã® appsscript.json ãäžžããšè¿œå ããããšã¯ã§ããŸããã
çåãšè§£æ±º
timeZone ã Asia/Tokyo ãš America/New_York ã§éããã©ïŒ
ãâ å®éçšã«åãã㊠Asia/Tokyo ã«çµ±äžããŸãããoauthScopes ã¯ã©ãæ±ãïŒ
ãâ æ°ããã³ãŒãã§å¿ èŠãªæš©éã ãã远å ããŸããã
æé ⢠ã³ãŒããã³ããŒãã
å¥ãããžã§ã¯ãã«ãã£ã .gs ãã¡ã€ã«ïŒäŸïŒGemini.gs, Main.gs, Setup.gs, Sheet.gsïŒãçµ±åå
ã«è¿œå ã
äžèº«ãã³ããŒïŒããŒã¹ãããŸãã
çåãšè§£æ±º
ãã¡ã€ã«åã appsscript.gs ã«ããŠãããïŒ
ãâ NGã§ãããã®ååã¯äºçŽæžã¿ã
ãâ æ©èœããããååïŒäŸïŒGemini.gs, Setup.gsïŒã«ããŸããã
æé â£ é¢æ°åã®ç«¶åãã§ãã¯
è€æ°ã®ã³ãŒãããŸãšãããšãåã颿°åã被ã£ãŠãšã©ãŒã«ãªãããšããããŸãã
çåãšè§£æ±º
ã©ããã£ãŠé¢æ°åãäžæ¬æ€çŽ¢ããïŒ
ãâ Apps Scriptãšãã£ã¿ã¯ãã¡ã€ã«åäœã®æ€çŽ¢ããã§ããŸããã
ãâ ããã§ clasp ã§ããŒã«ã«ã« clone â VSCodeïŒCursorïŒã§ Ctrl+Shift+F æ€çŽ¢ãããŸããã
æé â€cmdã§æåã®ãã©ã«ããäœãïŒCursorã§éãããã®æºåïŒ
Apps Script ã clasp ã§ããŒã«ã«ã« clone ãããšããç§ã¯æåããã§ã€ãŸãããŸããã
ãããªã clasp clone <ã¹ã¯ãªããID> ãå®è¡ããããDev ãã©ã«ãçŽäžã«ãã¡ã€ã«ãæ£ãã°ã£ãŠããŸã£ããã§ãã
ããïŒ Dev ã®äžã«ãããžã§ã¯ãçšã®ãã©ã«ããã§ããããããªãã®ïŒããšåéãããŠããŸããã
çµæãappsscript.json ã .gs ãã¡ã€ã«ãå
šéš Dev ã®çŽäžã«åºãŠããŠãããããæŽçãããŠãªãâŠããšå°æããŸããã
æ£ããæé ïŒç§ã®ããçŽãæ¹æ³ïŒ
ãŸã cmd ãéã
Windows ãªããã¹ã¿ãŒã â cmdãã§OKãäœæ¥ãã©ã«ãã«ç§»å
ä»å㯠Dev ãšãããã©ã«ããäœæ¥å Žæã«ããŸããã以äžãå®è¡ïŒ
cd C:\Users\ç§ã®ãã©ã«ã\Dev
ãããžã§ã¯ãå°çšãã©ã«ããäœã
ããšãã° Highlighter ãšããååã«ããŸããã以äžãå®è¡ïŒ
mkdir Highlighter cd Highlighter
ãã®äžã§ã¯ããŒã³ãäœæããŸãã以äžãå®è¡ïŒ
clasp clone <ã¹ã¯ãªããID> 倱æããåŠãã ããš
clone ã¯ãä»ãããã©ã«ãçŽäžãã«ãã¡ã€ã«ãå±éãã
ã ãããclone ã®åã«å¿ ã èªåã§ãããžã§ã¯ãçšã®ãã©ã«ããäœã£ãŠããã®äžã«ç§»åããŠããããš ã倧äº
ããç§ãšåãããã«ãDevçŽäžã«ãã¡ã€ã«ãæ£ãã°ã£ããå Žåã¯ãæåã§ãŸãšããŠãOKã§ããã
æåãã mkdir ã§ãã©ã«ããäœã£ãŠããã°ã¹ããŒãã£ãã€ã¹ãããªããŸãã
ð ããã§ãCursor ã§éããšãã Highlighter ãã©ã«ãããŸãããšæå®ããã°OKã
ãæåã®äžæ©ãã§ã€ãŸãããªãããã«ãããã¯ãã²æŒãããŠãããããã€ã³ãã§ãã
æé ⥠éè€é¢æ°ã®è§£æ¶
å®éã«èª¿ã¹ãããSetup.gs ã«åãååã® setupMinimal() ã2ã€ã
1ã€ç® â ãã¹ãçšã«äœ¿ã£ãŠãã軜éç
2ã€ç® â æ¬çªã§äœ¿ã宿ç
ð 察å¿
ãã¹ãçã¯ã³ã¡ã³ãã¢ãŠãããŠæ®ããæ¬çªçãæ¡çšã
å°æ¥ã®åèè³æãå
ŒããŠåé€ã¯ããŸããã§ããã
æé ⥠clasp push ã§åæ
ããŒã«ã«ã§ä¿®æ£ããå 容ã Google Apps Script ã«åæ ããã«ã¯ãCtrlïŒSã§ä¿åããåŸã«ã以äžãå®è¡ïŒ
clasp push
æé ⊠åäœç¢ºèªãšããªã¬ãŒåèšå®
æåŸã«ãçµ±åããã³ãŒããå®éã«åãããŠç¢ºèªããŸãã
ãã©ãŠã¶ã®App ScriptããªããŒã
Apps Script ãšãã£ã¿ã§é¢æ°ãæåå®è¡ â ãšã©ãŒãåºãªãããã§ãã¯
å¿ èŠã«å¿ããŠããªã¬ãŒïŒæéããªã¬ãŒã onOpen ãªã©ïŒãåèšå®
ð ããªã¬ãŒã¯ã³ããŒãããªãã®ã§ãçµ±åå ã§æ°èŠèšå®ãå¿ é ã§ãã
ãŸãšãïŒçµ±åã®æµããšåŠã³
Apps Script ã®çµ±åã¯ããã ã®ã³ãããã§ã¯æžã¿ãŸããã
appsscript.json ã®ããŒãž
颿°åã®éè€ç¢ºèªãšè§£æ¶âCursorã䜿ããšãããã
clasp ã§ã®åæ ãšãã¹ã
ãã®3ã€ãã«ã®ã«ãªããŸãã
ç§èªèº«ãäœæ¥äžã«ã
ãappsscript.gs ãšããååã¯äœ¿ããïŒã
ãåã颿° ã2ã€ãããã©ã©ãããïŒã
ãDevçŽäžã«ãã¡ã€ã«ãå±éããããã©æåã§æŽçããŠããïŒã
ãšãã£ãçåã«ã¶ã€ãããŸããã
ãã®èšäºããåãããã«è¿·ã人ã®åèã«ãªãã°å¬ããã§ãã
ðæ¬¡åäºå
Obsidianãåæèšå®ã解説äºå®ã§ãïŒ
ð ãã©ããŒããŠãåŸ
ã¡ããã ãããšå¬ããã§ãïŒ
ä»åŸããçæAIããŒã«ã®äœ¿ãå§ãã®çåã解決ãããããªnoteãæŽæ°ããŠãããŸãã
ð€ çè
ã«ã€ããŠ
æ¥ã
ãçæAIã䜿ã£ãŠæ¥åããŒã«ãèªååã詊è¡é¯èª€äžã
ãæšæ¥ã®èªåãå©ããnoteããæžããŠãŸãã
ð§¡ ã¹ããã³ã¡ã³ãã§å¿æŽããã ãããšå±ã¿ã«ãªããŸãïŒ
ð Xã§ã·ã§ã¢ããŠãããããšæ³£ããŠåã³ãŸãïŒ