<\/span><\/h2>\n\u5f0a\u793e\u306f\u3001\u8a33100\u500b\u306eIT\u30c4\u30fc\u30eb\u3092\u8ca9\u58f2\u3057\u3066\u3044\u3066\u3001\u5404\u793e\u5024\u4e0a\u3052\u304c\u6700\u8fd1\u306f\u6fc0\u3057\u3044\u3067\u3059\u3002<\/p>\n
\u6bce\u5e74\u3069\u3053\u304b\u304c\u3001\u5024\u4e0a\u3052\u3092\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u304c\u3001\u305d\u308c\u3092\u4ee3\u7406\u5e97\u306b\u304d\u3061\u3093\u3068\u914d\u4fe1\u3057\u3066\u304f\u308c\u306a\u3044\u30d9\u30f3\u30c0\u30fc\u3055\u3093\u304c\u3044\u305f\u308a\u3057\u307e\u3059\u3002<\/p>\n
\u3053\u308c\u3092\u81ea\u52d5\u5316\u3067\u304d\u306a\u3044\u304b\u3068\u8003\u3048\u307e\u3057\u3066\u3001<\/p>\n
chatGPT\u3068GAS\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u5b9f\u73fe\u3057\u307e\u3057\u305f\u306e\u3067\u3001<\/p>\n
\u305d\u306e\u3084\u308a\u65b9\u3092\u5171\u6709\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\uff01<\/p>\n
<\/span>\u69cb\u6210\u56f3<\/span><\/h2>\n![\"\u4ed5\u7d44\u307f\u306e\u69cb\u6210\u56f3\"](\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\")
<\/p>\n
\u4eca\u56de\u306e\u4ed5\u7d44\u307f\u306f\u4e0a\u8a184\u30b9\u30c6\u30c3\u30d7\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
\u5b9f\u969b\u306eGAS\u30b9\u30af\u30ea\u30d7\u30c8\u306f\u3053\u3061\u3089<\/p>\n
\n\n
const<\/span> <\/span>CONF<\/span> = {<\/span><\/div>\n\u00a0 <\/span>TZ<\/span>: <\/span>‘Asia\/Tokyo’<\/span>,<\/span><\/div>\n\u00a0 <\/span>DAYS<\/span>: <\/span>7<\/span>,<\/span><\/div>\n\u00a0 <\/span>TO<\/span>: <\/span>PropertiesService<\/span>.<\/span>getScriptProperties<\/span>().<\/span>getProperty<\/span>(<\/span>‘TO’<\/span>) || <\/span>‘\u3053\u3053\u306b\u30e1\u30fc\u30eb\u3092\u3044\u308c\u308b’<\/span>,<\/span><\/div>\n\u00a0 <\/span>SUBJECT_PREFIX<\/span>: <\/span>‘\u3010\u9031\u6b21\u3011IT\u30c4\u30fc\u30eb\u6700\u65b0\u60c5\u5831\uff08\u81ea\u52d5\u53ce\u96c6\uff09’<\/span>,<\/span><\/div>\n\u00a0 <\/span>SHEET_NAME<\/span>: <\/span>‘Tools’<\/span>, <\/span>\/\/ 1\u5217\u76ee\u306b\u30c4\u30fc\u30eb\u540d<\/span><\/div>\n\u00a0 <\/span>MAX_PER_TOOL<\/span>: <\/span>5<\/span>, \u00a0 \u00a0 <\/span>\/\/ \u30c4\u30fc\u30eb\u3054\u3068\u306e\u6700\u5927\u5019\u88dc<\/span><\/div>\n};<\/span><\/div>\n\/\/ A\u5217=\u30c4\u30fc\u30eb\u540d\u3001B\u5217=\u30e1\u30fc\u30ab\u30fc\u540d \u307e\u305f\u306f \u516c\u5f0f\u30c9\u30e1\u30a4\u30f3\uff08\u3069\u3061\u3089\u3067\u3082\u53ef\uff09<\/span><\/div>\nfunction<\/span> <\/span>getToolsAndMakers<\/span>(<\/span>name<\/span>) {<\/span><\/div>\n\u00a0 <\/span>const<\/span> <\/span>ss<\/span> = <\/span>SpreadsheetApp<\/span>.<\/span>getActiveSpreadsheet<\/span>();<\/span><\/div>\n\u00a0 <\/span>const<\/span> <\/span>sh<\/span> = <\/span>ss<\/span>.<\/span>getSheetByName<\/span>(<\/span>name<\/span>) || <\/span>ss<\/span>.<\/span>insertSheet<\/span>(<\/span>name<\/span>);<\/span><\/div>\n\u00a0 <\/span>const<\/span> <\/span>last<\/span> = <\/span>Math<\/span>.<\/span>max<\/span>(<\/span>1<\/span>, <\/span>sh<\/span>.<\/span>getLastRow<\/span>());<\/span><\/div>\n\u00a0 <\/span>const<\/span> <\/span>values<\/span> = <\/span>sh<\/span>.<\/span>getRange<\/span>(<\/span>1<\/span>, <\/span>1<\/span>, <\/span>last<\/span>, <\/span>2<\/span>).<\/span>getValues<\/span>(); <\/span>\/\/ 2\u5217\u53d6\u5f97<\/span><\/div>\n\u00a0 <\/span><\/span><\/span><\/div>\n}<\/span><\/div>\nfunction<\/span> <\/span>isDomainLike<\/span>(<\/span>s<\/span>){ <\/span>return<\/span> <\/span>\/\\.\/<\/span>.<\/span>test<\/span>(<\/span>s<\/span>) && !<\/span>\/\\s\/<\/span>.<\/span>test<\/span>(<\/span>s<\/span>); }<\/span><\/div>\n\/\/ \u4fa1\u683c\u7cfb\u30ad\u30fc\u30ef\u30fc\u30c9\uff08\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u8ffd\u52a0\u53ef\uff09<\/span><\/div>\nconst<\/span> <\/span>PRICE_TERMS<\/span> = <\/span>‘(\u4fa1\u683c OR \u6599\u91d1 OR \u5024\u4e0a\u3052 OR \u5024\u4e0b\u3052 OR \u4fa1\u683c\u6539\u5b9a OR price OR pricing OR cost)’<\/span>;<\/span><\/div>\n\/\/ \u66f4\u65b0\/\u30d7\u30e9\u30f3\u7cfb\uff08\u53b3\u3057\u3081\u691c\u7d22\u3067\u4f7f\u7528\uff09<\/span><\/div>\nconst<\/span> <\/span>UPDATE_TERMS<\/span> = <\/span>‘(release notes OR changelog OR “what\\\\\\’s new” OR \u66f4\u65b0\u60c5\u5831 OR \u5909\u66f4\u70b9 OR \u30d7\u30e9\u30f3 OR plan)’<\/span>;<\/span><\/div>\nfunction<\/span> <\/span>buildQueryStrict<\/span>(<\/span>tool<\/span>, <\/span>maker<\/span>) {<\/span><\/div>\n\u00a0 <\/span>const<\/span> <\/span>toolQ<\/span> \u00a0= <\/span>`”<\/span>${<\/span>tool<\/span>}<\/span>“`<\/span>;<\/span><\/div>\n\u00a0 <\/span>const<\/span> <\/span>makerQ<\/span> = <\/span>maker<\/span> ? (<\/span>isDomainLike<\/span>(<\/span>maker<\/span>) ? <\/span>`site:<\/span>${<\/span>maker<\/span>}<\/span>`<\/span> : <\/span>`”<\/span>${<\/span>maker<\/span>}<\/span>