GWS\u306e\u5916\u90e8\u30a2\u30d7\u30ea\u63a5\u7d9a\u3092\u5236\u5fa1\u3057\u3066Slack\u901a\u77e5\uff0bClaude\u5206\u6790\u307e\u3067\u81ea\u52d5\u5316\u3057\u305f\u8a71\u3010GAS\u5b9f\u88c5\u3011<\/title>\n<style>\n body { font-family: 'Hiragino Sans', 'Meiryo', sans-serif; padding: 24px; color: #333; line-height: 1.8; }\n h2 { font-size: 1.3em; border-left: 4px solid #3b5bdb; padding-left: 12px; margin-top: 48px; }\n h3 { font-size: 1.1em; margin-top: 32px; color: #1e3a8a; }\n .intro-box { background: #f7f8ff; border: 1px solid #c5cff5; border-radius: 6px; padding: 16px 20px; margin: 20px 0; }\n .intro-box ul { padding-left: 20px !important; }\n .intro-box ul li { list-style: disc !important; }\n .point { background: #fff8e1; border-left: 4px solid #ffc107; padding: 12px 16px; margin: 16px 0; border-radius: 0 4px 4px 0; }\n .warn { background: #fff1f2; border-left: 4px solid #e11d48; padding: 12px 16px; margin: 16px 0; border-radius: 0 4px 4px 0; }\n .good { background: #f0fdf4; border-left: 4px solid #22c55e; padding: 12px 16px; margin: 16px 0; border-radius: 0 4px 4px 0; }\n .cta-box { background-color: #f0f4ff; border-left: 4px solid #3b5bdb; padding: 24px; margin: 40px 0; border-radius: 4px; }\n .cta-button { display: inline-block; background-color: #3b5bdb; color: white; padding: 12px 24px; border-radius: 4px; text-decoration: none; font-weight: bold; margin-top: 12px; }\n .internal-link { background: #f0f4ff; border: 1px solid #c5cff5; border-radius: 4px; padding: 12px 16px; margin: 16px 0; font-size: 0.95em; }\n .code-block { background: #1e293b; color: #e2e8f0; border-radius: 8px; padding: 16px 20px; margin: 16px 0; font-size: 13px; line-height: 1.8; font-family: 'Courier New', monospace; white-space: pre-wrap; overflow-x: auto; }\n .flow { display: flex; flex-direction: column; gap: 0; margin: 20px 0; }\n .flow-step { background: #f8fafc; border: 1px solid #e2e8f0; border-radius: 8px; padding: 12px 16px; margin-bottom: 4px; font-size: 14px; }\n .flow-arrow { text-align: center; color: #94a3b8; font-size: 18px; line-height: 1.2; }\n table { width: 100%; border-collapse: collapse; margin: 20px 0; font-size: 14px; }\n th { background: #1e3a8a !important; color: white !important; padding: 10px 12px !important; text-align: left !important; }\n td { padding: 10px 12px; border-bottom: 1px solid #e2e8f0; vertical-align: top; }\n tr:nth-child(even) td { background: #f7f8ff; }\n<\/style>\n<\/head>\n<body>\n\n<div class=\"intro-box\">\n <strong>\u3053\u306e\u8a18\u4e8b\u3067\u308f\u304b\u308b\u3053\u3068<\/strong>\n <ul>\n <li>Google Workspace\u3067\u5916\u90e8\u30a2\u30d7\u30ea\u3078\u306e\u63a5\u7d9a\u3092\u5236\u5fa1\u3059\u308b\u8a2d\u8a08\u306e\u8003\u3048\u65b9<\/li>\n <li>OU\u3054\u3068\u306b\u7570\u306a\u308b\u5236\u5fa1\u65b9\u91dd\u3092\u9069\u7528\u3059\u308b\u65b9\u6cd5<\/li>\n <li>GAS\u3067OAuth\u7533\u8acb\u3092Slack\u306b\u81ea\u52d5\u901a\u77e5\u3059\u308b\u4ed5\u7d44\u307f\u306e\u4f5c\u308a\u65b9<\/li>\n <li>Claude\u306eAPI\u3092GAS\u304b\u3089\u547c\u3073\u51fa\u3057\u3066\u627f\u8a8d\u5224\u65ad\u3092\u81ea\u52d5\u5206\u6790\u3055\u305b\u308b\u5b9f\u88c5<\/li>\n <\/ul>\n<\/div>\n\n<p>\u3042\u308b\u4f1a\u793e\u3067GWS\u306eAPI\u5236\u5fa1\u2014\u2014\u3064\u307e\u308a\u3001\u793e\u54e1\u304c\u5916\u90e8\u30a2\u30d7\u30ea\u306bGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u9023\u643a\u3055\u305b\u308b\u3053\u3068\u3078\u306e\u5236\u5fa1\u2014\u2014\u3092\u6574\u5099\u3059\u308b\u3053\u3068\u306b\u306a\u3063\u305f\u3002<\/p>\n\n<p>\u76ee\u7684\u306f\u30b7\u30f3\u30d7\u30eb\u3067\u3001<strong>\u91ce\u826fSaaS\u3078\u306e\u60c5\u5831\u6d41\u51fa\u30fb\u610f\u56f3\u3057\u306a\u3044\u30c7\u30fc\u30bf\u9023\u643a\u3092\u9632\u3050<\/strong>\u3053\u3068\u3060\u3002\u305f\u3060\u5358\u306b\u300c\u5168\u90e8\u7981\u6b62\u300d\u306b\u3059\u308c\u3070\u696d\u52d9\u304c\u6b62\u307e\u308b\u3057\u3001\u300c\u5168\u90e8\u8a31\u53ef\u300d\u3067\u306f\u7ba1\u7406\u306b\u306a\u3089\u306a\u3044\u3002\u305d\u3053\u3067\u5236\u5fa1\u65b9\u91dd\u3092\u8a2d\u8a08\u3057\u3001\u7533\u8acb\u304c\u6765\u305f\u3089\u81ea\u52d5\u3067Slack\u306b\u901a\u77e5\uff0bClaude\u306eAPI\u3067\u5b89\u5168\u6027\u3092\u5206\u6790\u3059\u308b\u4ed5\u7d44\u307f\u307e\u3067\u5b9f\u88c5\u3057\u305f\u3002\u3053\u306e\u8a18\u4e8b\u306f\u305d\u306e\u8a2d\u8a08\u3068\u5b9f\u88c5\u306e\u8a71\u3060\u3002<\/p>\n\n<h2>\u25bc\u80cc\u666f\uff1aGWS\u306eAPI\u63a5\u7d9a\u304c\u91ce\u826f\u72b6\u614b\u306b\u306a\u3063\u3066\u3044\u305f<\/h2>\n\n<p>Google Admin\u306eAPI\u5236\u5fa1\u753b\u9762\u3092\u958b\u304f\u3068\u3001\u793e\u54e1\u304c\u81ea\u7531\u306b\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u3078\u306eOAuth\u9023\u643a\u3092\u884c\u3063\u3066\u3044\u305f\u72b6\u614b\u304c\u53ef\u8996\u5316\u3055\u308c\u305f\u3002Zoom\u304cGmail\u3068Drive\u306b\u30d5\u30eb\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3044\u305f\u308a\u3001\u7528\u9014\u4e0d\u660e\u306e\u30b5\u30fc\u30c9\u30d1\u30fc\u30c6\u30a3GAS\u304c\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u8aad\u307f\u66f8\u304d\u3057\u3066\u3044\u305f\u308a\u3068\u3001\u300c\u8ab0\u304c\u4f55\u3092\u8a31\u53ef\u3057\u305f\u304b\u300d\u304c\u8ab0\u306b\u3082\u628a\u63e1\u3067\u304d\u3066\u3044\u306a\u3044\u72b6\u614b\u3060\u3063\u305f\u3002<\/p>\n\n<div class=\"warn\">\n \u26a0\ufe0f <strong>\u653e\u7f6e\u3059\u308b\u3068\u4f55\u304c\u8d77\u304d\u308b\u304b<\/strong><br>\n \u30fb\u9000\u8077\u8005\u304c\u4f7f\u3063\u3066\u3044\u305f\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u304cGmail\u3084Drive\u306b\u63a5\u7d9a\u3057\u305f\u307e\u307e\u306b\u306a\u308b<br>\n \u30fb\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5be9\u67fb\u3067\u300c\u5916\u90e8\u30a2\u30d7\u30ea\u3078\u306e\u30a2\u30af\u30bb\u30b9\u7ba1\u7406\u72b6\u6cc1\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u300d\u3068\u554f\u308f\u308c\u3066\u3082\u7b54\u3048\u3089\u308c\u306a\u3044<br>\n \u30fb\u91ce\u826fGAS\uff08\u500b\u4ebaGmail\u3067\u4f5c\u6210\u3055\u308c\u305f\u30b9\u30af\u30ea\u30d7\u30c8\uff09\u304c\u793e\u5185\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u8aad\u307f\u66f8\u304d\u3057\u7d9a\u3051\u308b\n<\/div>\n\n<h2>\u25bc\u5236\u5fa1\u65b9\u91dd\u306e\u8a2d\u8a08<\/h2>\n\n<h3>\u2460 \u6700\u4f4e\u8981\u4ef6\u3092\u6c7a\u3081\u308b\uff1a\u30ed\u30b0\u30a4\u30f3\u60c5\u5831\u306e\u307fOK<\/h3>\n\n<p>\u5916\u90e8\u30a2\u30d7\u30ea\u304cGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u8981\u6c42\u3059\u308b\u30b9\u30b3\u30fc\u30d7\u306f\u5927\u304d\u304f2\u7a2e\u985e\u306b\u5206\u3051\u3089\u308c\u308b\u3002<\/p>\n\n<table>\n <tr>\n <th>\u7a2e\u5225<\/th>\n <th>\u30b9\u30b3\u30fc\u30d7\u4f8b<\/th>\n <th>\u65b9\u91dd<\/th>\n <\/tr>\n <tr>\n <td><strong>\u57fa\u672c\u30b9\u30b3\u30fc\u30d7<\/strong><\/td>\n <td>openid \/ email \/ profile \/ userinfo.email \/ userinfo.profile<\/td>\n <td>\u2705 \u539f\u5247\u8a31\u53ef\uff08Google\u30ed\u30b0\u30a4\u30f3\u306e\u307f\uff09<\/td>\n <\/tr>\n <tr>\n <td><strong>\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7<\/strong><\/td>\n <td>Gmail \/ Drive \/ Calendar \/ Contacts \u306a\u3069<\/td>\n <td>\u26a0\ufe0f \u7533\u8acb\u5236\u30fb\u500b\u5225\u5be9\u67fb<\/td>\n <\/tr>\n<\/table>\n\n<p>\u300cGoogle\u3067\u30ed\u30b0\u30a4\u30f3\u300d\u3059\u308b\u3060\u3051\u306a\u3089\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u3067\u5b8c\u7d50\u3059\u308b\u3002\u554f\u984c\u306b\u306a\u308b\u306e\u306f\u3001\u30a2\u30d7\u30ea\u304cGmail\u3092\u8aad\u3093\u3060\u308aDrive\u3092\u66f8\u304d\u63db\u3048\u305f\u308a\u3067\u304d\u308b\u30b9\u30b3\u30fc\u30d7\u3092\u8981\u6c42\u3057\u3066\u304f\u308b\u30b1\u30fc\u30b9\u3060\u3002\u3053\u308c\u3092<strong>\u7533\u8acb\u5236\u306b\u3057\u3066\u30011\u4ef6\u305a\u3064\u5be9\u67fb\u3059\u308b<\/strong>\u3068\u3044\u3046\u65b9\u91dd\u306b\u3057\u305f\u3002<\/p>\n\n<h3>\u2461 OU\u3054\u3068\u306b\u5236\u5fa1\u3092\u5206\u3051\u308b<\/h3>\n\n<p>\u5168\u793e\u54e1\u306b\u540c\u3058\u5236\u5fa1\u3092\u304b\u3051\u308b\u306e\u3067\u306f\u306a\u304f\u3001OU\u306e\u6027\u8cea\u306b\u5fdc\u3058\u3066\u9069\u7528\u30eb\u30fc\u30eb\u3092\u5909\u3048\u305f\u3002<\/p>\n\n<table>\n <tr>\n <th>\u5bfe\u8c61OU<\/th>\n <th>\u5236\u5fa1\u65b9\u91dd<\/th>\n <\/tr>\n <tr>\n <td>\u6b63\u793e\u54e1\u30fb\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u7b49<\/td>\n <td>\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306f\u81ea\u7531\u306b\u8a31\u53ef\u3002\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u306f\u7533\u8acb\u5236<\/td>\n <\/tr>\n <tr>\n <td>\u696d\u52d9\u59d4\u8a17\u30fb\u30a4\u30f3\u30bf\u30fc\u30f3\u30fb\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8<\/td>\n <td>\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u3092\u542b\u3080\u5168\u30a2\u30af\u30bb\u30b9\u3092\u7533\u8acb\u5236\uff08\u3088\u308a\u53b3\u683c\u306b\u7ba1\u7406\uff09<\/td>\n <\/tr>\n<\/table>\n\n<p>\u696d\u52d9\u59d4\u8a17\u3084\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306f\u7279\u306b\u7ba1\u7406\u304c\u629c\u3051\u3084\u3059\u3044\u306e\u3067\u3001\u3053\u3061\u3089\u306f\u5168\u30b9\u30b3\u30fc\u30d7\u7533\u8acb\u5236\u306b\u3057\u305f\u3002<\/p>\n\n<h3>\u2462 \u7533\u8acb\u304c\u6765\u305f\u3089Slack\u306b\u901a\u77e5\uff0bClaude\u5206\u6790<\/h3>\n\n<p>\u5236\u5fa1\u8a2d\u5b9a\u3092\u5165\u308c\u308b\u3060\u3051\u3067\u306f\u300c\u7533\u8acb\u304c\u6765\u3066\u3082\u8ab0\u3082\u6c17\u3065\u304b\u306a\u3044\u300d\u554f\u984c\u304c\u8d77\u304d\u308b\u3002\u306a\u306e\u3067\u7533\u8acb\u304c\u3042\u3063\u305f\u77ac\u9593\u306bSlack\u3078\u901a\u77e5\u3057\u3001\u305d\u306e\u30b9\u30ec\u30c3\u30c9\u306bClaude\u304c\u81ea\u52d5\u3067\u30a2\u30d7\u30ea\u306e\u6982\u8981\u30fb\u30ea\u30b9\u30af\u30fb\u627f\u8a8d\u5224\u65ad\u3092\u6295\u7a3f\u3059\u308b\u4ed5\u7d44\u307f\u3092\u4f5c\u3063\u305f\u3002<\/p>\n\n<h2>\u25bc\u4ed5\u7d44\u307f\u306e\u5168\u4f53\u50cf<\/h2>\n\n<div class=\"flow\">\n <div class=\"flow-step\">\u2460 \u793e\u54e1\u304cGWS\u4e0a\u3067\u5916\u90e8\u30a2\u30d7\u30ea\u306e\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u63a5\u7d9a\u3092\u8a66\u307f\u308b<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2461 Google Admin\u306eAPI\u5236\u5fa1\u3067\u30ea\u30af\u30a8\u30b9\u30c8\u3068\u3057\u3066\u8a18\u9332\u3055\u308c\u308b<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2462 GAS\u304c5\u5206\u304a\u304d\u306bAdmin Reports API\u3092\u30dd\u30fc\u30ea\u30f3\u30b0\u3057\u3066\u7533\u8acb\u3092\u691c\u77e5<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2463 \u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306e\u307f\u306e\u7533\u8acb\u306f\u30b9\u30ad\u30c3\u30d7\u3002\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u304c\u3042\u308b\u7533\u8acb\u3060\u3051Slack\u306b\u901a\u77e5<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2464 \u540c\u3058\u901a\u77e5\u306e\u30b9\u30ec\u30c3\u30c9\u306bClaude\u304c\u30a2\u30d7\u30ea\u6982\u8981\u30fb\u30ea\u30b9\u30af\u30fb\u5224\u65ad\u3092\u81ea\u52d5\u6295\u7a3f<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2465 \u7ba1\u7406\u8005\u304cSlack\u3092\u898b\u3066Google Admin Console\u3067\u627f\u8a8d\/\u5374\u4e0b<\/div>\n<\/div>\n\n<div class=\"point\">\n \ud83d\udca1 <strong>\u306a\u305c\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u306f\u306a\u304f\u30dd\u30fc\u30ea\u30f3\u30b0\u304b<\/strong><br>\n Google Admin Reports API\u306fPush\u901a\u77e5\uff08Webhook\uff09\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u3002\u305d\u306e\u305f\u3081GAS\u306e\u30c8\u30ea\u30ac\u30fc\u30675\u5206\u304a\u304d\u306b\u7533\u8acb\u3092\u53d6\u5f97\u3059\u308b\u30dd\u30fc\u30ea\u30f3\u30b0\u65b9\u5f0f\u3092\u63a1\u7528\u3057\u3066\u3044\u308b\u3002\u6700\u59275\u5206\u306e\u30bf\u30a4\u30e0\u30e9\u30b0\u304c\u751f\u3058\u308b\u304c\u3001\u5b9f\u52d9\u4e0a\u306f\u554f\u984c\u306a\u3044\u3002\n<\/div>\n\n<h2>\u25bc\u5b9f\u88c5\uff1aGAS\u306e\u30b3\u30fc\u30c9\u89e3\u8aac<\/h2>\n\n<h3>\u8a2d\u5b9a\u5024<\/h3>\n\n<div class=\"code-block\">const SLACK_BOT_TOKEN = ‘xoxb-XXXX-XXXX-XXXX’; \/\/ Slack Bot Token\nconst SLACK_CHANNEL_ID = ‘CXXXXXXXXX’; \/\/ \u901a\u77e5\u5148\u30c1\u30e3\u30f3\u30cd\u30ebID\nconst ANTHROPIC_API_KEY = ‘sk-ant-XXXXXXXXXXXX’; \/\/ Anthropic API\u30ad\u30fc\nconst SPREADSHEET_ID = ‘XXXXXXXXXXXXXXXXXXXX’; \/\/ \u51e6\u7406\u6e08\u307f\u7ba1\u7406\u7528\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8ID\n\n\/\/ \u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306e\u5b9a\u7fa9\uff08\u3053\u308c\u3060\u3051\u306a\u3089\u7533\u8acb\u4e0d\u8981\uff09\nconst BASIC_SCOPES = new Set([\n ‘openid’,\n ‘email’,\n ‘profile’,\n ‘https:\/\/www.googleapis.com\/auth\/userinfo.email’,\n ‘https:\/\/www.googleapis.com\/auth\/userinfo.profile’\n]);<\/div>\n\n<h3>\u30e1\u30a4\u30f3\u51e6\u7406\uff1a\u7533\u8acb\u306e\u691c\u77e5\u3068\u632f\u308a\u5206\u3051<\/h3>\n\n<div class=\"code-block\">function checkPendingRequests() {\n const token = ScriptApp.getOAuthToken();\n \/\/ \u76f4\u8fd172\u6642\u9593\u306e\u7533\u8acb\u3092\u53d6\u5f97\n const startTime = new Date(Date.now() – 72 * 60 * 60 * 1000).toISOString();\n\n const url = ‘https:\/\/admin.googleapis.com\/admin\/reports\/v1\/activity’\n + ‘\/users\/all\/applications\/token’\n + ‘?eventName=request&maxResults=50&startTime=’ + encodeURIComponent(startTime);\n\n const response = UrlFetchApp.fetch(url, {\n headers: { Authorization: ‘Bearer ‘ + token },\n muteHttpExceptions: true\n });\n const data = JSON.parse(response.getContentText());\n\n if (!data.items || data.items.length === 0) return;\n\n const sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getActiveSheet();\n const processed = getProcessedKeys(sheet); \/\/ \u51e6\u7406\u6e08\u307f\u30ad\u30fc\u306eSet\n\n data.items.forEach(item => {\n if (!item.actor?.email || !item.events?.[0]?.parameters) return;\n\n const params = item.events[0].parameters;\n const userEmail = item.actor.email;\n const appName = params.find(p => p.name === ‘app_name’)?.value || ‘\u4e0d\u660e\u306a\u30a2\u30d7\u30ea’;\n const clientId = params.find(p => p.name === ‘client_id’)?.value || ”;\n const scope = (params.find(p => p.name === ‘scope’)?.multiValue || []).join(‘ ‘);\n\n \/\/ \u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306e\u307f \u2192 \u30b9\u30ad\u30c3\u30d7\n if (!hasNonBasicScope(scope)) return;\n\n \/\/ \u91cd\u8907\u30c1\u30a7\u30c3\u30af\uff08\u540c\u3058\u7533\u8acb\u30922\u56de\u901a\u77e5\u3057\u306a\u3044\uff09\n const uniqueKey = userEmail + ‘_’ + appName + ‘_’ + item.id.time;\n if (processed.has(uniqueKey)) return;\n\n const jstTime = formatJst(new Date(item.id.time));\n\n \/\/ Slack\u901a\u77e5 \u2192 \u30b9\u30ec\u30c3\u30c9ts\u3092\u53d6\u5f97\n const ts = postSlackNotification(userEmail, appName, jstTime, clientId, scope);\n if (!ts) return;\n\n \/\/ Claude\u306b\u3088\u308b\u5206\u6790\u3092\u30b9\u30ec\u30c3\u30c9\u306b\u6295\u7a3f\n postClaudeAnalysis(appName, clientId, scope, ts);\n\n \/\/ \u51e6\u7406\u6e08\u307f\u3068\u3057\u3066\u8a18\u9332\n sheet.appendRow([uniqueKey, userEmail, appName, scope, new Date().toISOString()]);\n });\n}<\/div>\n\n<h3>\u30dd\u30a4\u30f3\u30c8\u2460\uff1a\u30b9\u30b3\u30fc\u30d7\u5224\u5b9a<\/h3>\n\n<div class=\"code-block\">function hasNonBasicScope(scope) {\n if (!scope) return false;\n \/\/ \u30b9\u30b3\u30fc\u30d7\u6587\u5b57\u5217\u3092\u5206\u5272\u3057\u3066\u30011\u3064\u3067\u3082\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u4ee5\u5916\u304c\u3042\u308c\u3070true\n return scope.split(‘ ‘).filter(Boolean).some(s => !BASIC_SCOPES.has(s));\n}<\/div>\n\n<p>\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u3060\u3051\u306e\u30a2\u30d7\u30ea\uff08Google\u30ed\u30b0\u30a4\u30f3\u306e\u307f\uff09\u306f\u901a\u77e5\u4e0d\u8981\u306a\u306e\u3067\u30b9\u30ad\u30c3\u30d7\u3059\u308b\u3002\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u304c1\u3064\u3067\u3082\u542b\u307e\u308c\u3066\u3044\u305f\u3089\u901a\u77e5\u5bfe\u8c61\u306b\u306a\u308b\u3002<\/p>\n\n<h3>\u30dd\u30a4\u30f3\u30c8\u2461\uff1a\u91cd\u8907\u9632\u6b62<\/h3>\n\n<div class=\"code-block\">function getProcessedKeys(sheet) {\n const lastRow = sheet.getLastRow();\n if (lastRow === 0) return new Set();\n return new Set(\n sheet.getRange(1, 1, lastRow, 1).getValues().flat().map(String).filter(Boolean)\n );\n}<\/div>\n\n<p>5\u5206\u304a\u304d\u306b\u5b9f\u884c\u3059\u308b\u305f\u3081\u30dd\u30fc\u30ea\u30f3\u30b0\u3059\u308b\u305f\u3073\u306b\u540c\u3058\u7533\u8acb\u304c\u53d6\u308c\u3066\u3057\u307e\u3046\u3002\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u51e6\u7406\u6e08\u307f\u30ad\u30fc\u3092\u8a18\u9332\u3057\u3066\u304a\u304d\u3001\u91cd\u8907\u306f\u901a\u77e5\u3057\u306a\u3044\u8a2d\u8a08\u306b\u3057\u305f\u3002<\/p>\n\n<h3>\u30dd\u30a4\u30f3\u30c8\u2462\uff1aSlack\u901a\u77e5\uff08\u30b9\u30ec\u30c3\u30c9ts\u3092\u8fd4\u3059\uff09<\/h3>\n\n<div class=\"code-block\">function postSlackNotification(userEmail, appName, requestTime, clientId, scope) {\n const text = [\n ‘\u26a0\ufe0f *OAuth\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u7533\u8acb\u304c\u5c4a\u304d\u307e\u3057\u305f*’,\n ‘*\u7533\u8acb\u8005:* ‘ + userEmail,\n ‘*\u30a2\u30d7\u30ea:* ‘ + appName,\n ‘*\u65e5\u6642:* ‘ + requestTime,\n ‘*\u8981\u6c42\u30b9\u30b3\u30fc\u30d7:* `’ + (scope || ‘\u4e0d\u660e’) + ‘`’,\n ”,\n ‘\ud83d\udc49 \u5be9\u67fb\u30da\u30fc\u30b8: https:\/\/admin.google.com\/ac\/owl\/list?tab=pendingReviewApps’\n ].join(‘\\n’);\n\n const response = UrlFetchApp.fetch(‘https:\/\/slack.com\/api\/chat.postMessage’, {\n method: ‘post’,\n contentType: ‘application\/json’,\n headers: { Authorization: ‘Bearer ‘ + SLACK_BOT_TOKEN },\n payload: JSON.stringify({ channel: SLACK_CHANNEL_ID, text: text }),\n muteHttpExceptions: true\n });\n\n const result = JSON.parse(response.getContentText());\n if (!result.ok) {\n console.error(‘Slack\u6295\u7a3f\u30a8\u30e9\u30fc:’, result.error);\n return null;\n }\n return result.ts; \/\/ \u30b9\u30ec\u30c3\u30c9\u306b\u8fd4\u4fe1\u3059\u308b\u305f\u3081\u306bts\u3092\u8fd4\u3059\n}<\/div>\n\n<h3>\u30dd\u30a4\u30f3\u30c8\u2463\uff1aClaude\u306eAPI\u3092GAS\u304b\u3089\u547c\u3073\u51fa\u3059<\/h3>\n\n<div class=\"code-block\">function postClaudeAnalysis(appName, clientId, scope, threadTs) {\n const prompt = ‘\u4ee5\u4e0b\u306e\u30a2\u30d7\u30ea\u306b\u3064\u3044\u3066\u3001Google Workspace\u306e\u7ba1\u7406\u8005\u304c\u627f\u8a8d\u5224\u65ad\u3067\u304d\u308b\u3088\u3046\u65e5\u672c\u8a9e\u3067\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\\n\\n’\n + ‘\u30a2\u30d7\u30ea\u540d: ‘ + appName + ‘\\n’\n + ‘Client ID: ‘ + clientId + ‘\\n’\n + ‘\u8981\u6c42\u30b9\u30b3\u30fc\u30d7: ‘ + scope + ‘\\n\\n’\n + ‘\u4ee5\u4e0b\u306e\u5f62\u5f0f\u3067Slack\u5411\u3051\u30c6\u30ad\u30b9\u30c8\u3092\u51fa\u529b\u3057\u3066\u304f\u3060\u3055\u3044\uff08Slack\u5f62\u5f0f\uff1a*\u592a\u5b57*\u3001\u7b87\u6761\u66f8\u304d\u306f \u2022\uff09:\\n\\n’\n + ‘*\ud83d\udcf1 \u30a2\u30d7\u30ea\u6982\u8981*\\n\uff081\u301c2\u6587\uff09\\n\\n’\n + ‘*\ud83d\udd10 \u3053\u306e\u30b9\u30b3\u30fc\u30d7\u3067\u53ef\u80fd\u306b\u306a\u308b\u3053\u3068*\\n\u2022 \uff08\u5177\u4f53\u7684\u306b\u7b87\u6761\u66f8\u304d\uff09\\n\\n’\n + ‘*\u26a0\ufe0f \u30ea\u30b9\u30af*\\n\u2022 \uff08\u7b87\u6761\u66f8\u304d\uff09\\n\\n’\n + ‘*\ud83d\udca1 \u5224\u65ad: [\u627f\u8a8d\u63a8\u5968 \/ \u8981\u78ba\u8a8d \/ \u62d2\u5426\u63a8\u5968]*\\n\uff08\u7406\u7531\u30921\u6587\uff09’;\n\n const response = UrlFetchApp.fetch(‘https:\/\/api.anthropic.com\/v1\/messages’, {\n method: ‘post’,\n headers: {\n ‘Content-Type’: ‘application\/json’,\n ‘x-api-key’: ANTHROPIC_API_KEY,\n ‘anthropic-version’: ‘2023-06-01’\n },\n payload: JSON.stringify({\n model: ‘claude-opus-4-5’,\n max_tokens: 1024,\n messages: [{ role: ‘user’, content: prompt }]\n }),\n muteHttpExceptions: true\n });\n\n const data = JSON.parse(response.getContentText());\n const analysisText = data.content?.[0]?.text || ‘\u5206\u6790\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f’;\n\n \/\/ \u901a\u77e5\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u30b9\u30ec\u30c3\u30c9\u306b\u8fd4\u4fe1\n postThreadMessage(threadTs, ‘\ud83e\udd16 *Claude \u306b\u3088\u308b\u5b89\u5168\u6027\u5206\u6790*\\n\\n’ + analysisText);\n}<\/div>\n\n<h2>\u25bc\u5b9f\u969b\u306eSlack\u901a\u77e5\u30a4\u30e1\u30fc\u30b8<\/h2>\n\n<p>\u7533\u8acb\u304c\u6765\u308b\u3068\u3053\u3093\u306a\u5f62\u3067Slack\u306b\u901a\u77e5\u3055\u308c\u308b\u3002<\/p>\n\n<div class=\"code-block\">\u26a0\ufe0f OAuth\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u7533\u8acb\u304c\u5c4a\u304d\u307e\u3057\u305f\n\u7533\u8acb\u8005: user@example.com\n\u30a2\u30d7\u30ea: Genspark\n\u65e5\u6642: 2026\/04\/13 11:23:47\n\u8981\u6c42\u30b9\u30b3\u30fc\u30d7: `https:\/\/www.googleapis.com\/auth\/gmail.modify https:\/\/www.googleapis.com\/auth\/drive.file`\n\n\ud83d\udc49 \u5be9\u67fb\u30da\u30fc\u30b8: https:\/\/admin.google.com\/ac\/owl\/list?tab=pendingReviewApps<\/div>\n\n<p>\u305d\u306e\u30b9\u30ec\u30c3\u30c9\u306bClaude\u304c\u81ea\u52d5\u3067\u5206\u6790\u3092\u8fd4\u3057\u3066\u304f\u308b\u3002<\/p>\n\n<div class=\"code-block\">\ud83e\udd16 Claude \u306b\u3088\u308b\u5b89\u5168\u6027\u5206\u6790\n\n\ud83d\udcf1 \u30a2\u30d7\u30ea\u6982\u8981\nGenspark\u306f\u751f\u6210AI\u3092\u6d3b\u7528\u3057\u305f\u30a6\u30a7\u30d6\u691c\u7d22\u30fb\u30b3\u30f3\u30c6\u30f3\u30c4\u751f\u6210\u30c4\u30fc\u30eb\u3067\u3059\u3002\n\n\ud83d\udd10 \u3053\u306e\u30b9\u30b3\u30fc\u30d7\u3067\u53ef\u80fd\u306b\u306a\u308b\u3053\u3068\n\u2022 gmail.modify\uff1a\u30e1\u30fc\u30eb\u306e\u8aad\u307f\u53d6\u308a\u30fb\u9001\u4fe1\u30fb\u79fb\u52d5\u30fb\u524a\u9664\u304c\u53ef\u80fd\n\u2022 drive.file\uff1a\u30a2\u30d7\u30ea\u304c\u4f5c\u6210\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3078\u306e\u30a2\u30af\u30bb\u30b9\u304c\u53ef\u80fd\n\n\u26a0\ufe0f \u30ea\u30b9\u30af\n\u2022 Gmail\u3078\u306e\u30d5\u30eb\u30a2\u30af\u30bb\u30b9\u306b\u3088\u308a\u3001\u6a5f\u5bc6\u60c5\u5831\u3092\u542b\u3080\u30e1\u30fc\u30eb\u304c\u5916\u90e8\u306b\u9001\u4fe1\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\n\u2022 AI\u7cfb\u30b5\u30fc\u30d3\u30b9\u3078\u306e\u5165\u529b\u30c7\u30fc\u30bf\u304c\u5b66\u7fd2\u306b\u5229\u7528\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\n\n\ud83d\udca1 \u5224\u65ad: \u8981\u78ba\u8a8d\n\u696d\u52d9\u4e0a\u306e\u5fc5\u8981\u6027\u3092\u7533\u8acb\u8005\u306b\u78ba\u8a8d\u3057\u305f\u4e0a\u3067\u3001\u6a5f\u5bc6\u60c5\u5831\u3092\u542b\u3080\u30e1\u30fc\u30eb\u3092\u6271\u308f\u306a\u3044\u904b\u7528\u30eb\u30fc\u30eb\u3092\u6574\u5099\u3057\u3066\u304b\u3089\u627f\u8a8d\u3092\u691c\u8a0e\u3059\u308b\u3053\u3068\u3092\u63a8\u5968\u3057\u307e\u3059\u3002<\/div>\n\n<h2>\u25bc\u5b9f\u88c5\u3067\u30cf\u30de\u3063\u305f\u3053\u3068<\/h2>\n\n<ul style=\"list-style: none !important; padding-left: 0 !important;\">\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>Admin Reports API\u306feventName=authorize\u3058\u3083\u306a\u3044<\/strong>\uff1a\u300c\u5be9\u67fb\u5f85\u3061\u300d\u306e\u30a4\u30d9\u30f3\u30c8\u306feventName=<code>request<\/code>\u3067\u53d6\u5f97\u3059\u308b\u3002<code>authorize<\/code>\u306f\u627f\u8a8d\u6e08\u307f\u306e\u30ed\u30b0\u5168\u4ef6\u304c\u8fd4\u3063\u3066\u304f\u308b\u306e\u3067\u5225\u7269<\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>Admin SDK\u306fAdmin Reports\u3068\u540c\u3058\u30b5\u30fc\u30d3\u30b9\u306b\u767b\u9332\u3067\u304d\u306a\u3044<\/strong>\uff1aGAS\u306e\u30b5\u30fc\u30d3\u30b9\u306bAdmin SDK API\u3092\u8ffd\u52a0\u3059\u308b\u969b\u3001directory_v1\u3068reports_v1\u306f\u5225\u3005\u306b\u767b\u9332\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3002Reports API\u306fURLFetchApp\u3067\u76f4\u63a5\u53e9\u304f\u65b9\u6cd5\u3067\u89e3\u6c7a\u3057\u305f<\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>Slack\u306e\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u30c1\u30e3\u30f3\u30cd\u30eb\u3078\u306e\u6295\u7a3f\u306b\u306fgroups:history\u30b9\u30b3\u30fc\u30d7\u304c\u5fc5\u8981<\/strong>\uff1a\u30d1\u30d6\u30ea\u30c3\u30af\u30c1\u30e3\u30f3\u30cd\u30eb\u3068\u306f\u5fc5\u8981\u306a\u30b9\u30b3\u30fc\u30d7\u304c\u7570\u306a\u308b<\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>\u30b9\u30ec\u30c3\u30c9\u3078\u306e\u8fd4\u4fe1\u306b\u306fmessage_ts\u3067\u306f\u306a\u304fmessage.ts<\/strong>\uff1aSlack\u306e\u30da\u30a4\u30ed\u30fc\u30c9\u69cb\u9020\u304c\u53e4\u3044attachments\u5f62\u5f0f\u3060\u3068ts\u306e\u53d6\u5f97\u30d1\u30b9\u304c\u5909\u308f\u308b<\/li>\n<\/ul>\n\n<h2>\u25bc\u307e\u3068\u3081<\/h2>\n\n<ul style=\"list-style: none !important; padding-left: 0 !important;\">\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>GWS\u306eAPI\u5236\u5fa1\u306f\u300c\u5168\u7981\u6b62\u300d\u3067\u306f\u306a\u304f\u300c\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306fOK\u30fb\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u306f\u7533\u8acb\u5236\u300d\u304c\u73fe\u5b9f\u7684<\/strong><\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>OU\u5225\u306b\u5236\u5fa1\u306e\u53b3\u3057\u3055\u3092\u5909\u3048\u308b\u3053\u3068\u3067\u3001\u696d\u52d9\u59d4\u8a17\u30fb\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u539a\u304f\u7ba1\u7406\u3067\u304d\u308b<\/strong><\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>GAS\uff0bAdmin Reports API\uff0bSlack\uff0bClaude API\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u7533\u8acb\u901a\u77e5\u301c\u5b89\u5168\u6027\u5206\u6790\u307e\u3067\u304c\u5168\u81ea\u52d5\u306b\u306a\u308b<\/strong><\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>Claude\u306b\u300c\u30a2\u30d7\u30ea\u6982\u8981\u30fb\u30ea\u30b9\u30af\u30fb\u5224\u65ad\u300d\u3092\u51fa\u529b\u3055\u305b\u308b\u3053\u3068\u3067\u3001\u60c5\u30b7\u30b9\u62c5\u5f53\u8005\u304c\u30b9\u30b3\u30fc\u30d7\u306e\u610f\u5473\u30921\u304b\u3089\u8abf\u3079\u306a\u304f\u3066\u3088\u304f\u306a\u308b<\/strong><\/li>\n<\/ul>\n\n<div class=\"internal-link\">\n \ud83d\udcc4 GWS\u306e\u30c9\u30e9\u30a4\u30d6\u6a29\u9650\u8a2d\u8a08\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/hige-josys.info\/\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3067\u3082\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\n<\/div>\n\n<div class=\"internal-link\">\n \ud83d\udcc4 SaaS\u30a2\u30ab\u30a6\u30f3\u30c8\u68da\u5378\u3057\u306e\u5168\u4f53\u8a2d\u8a08\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/hige-josys.info\/?p=379\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3067\u3082\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\n<\/div>\n\n<div class=\"cta-box\">\n <p style=\"font-weight: bold; font-size: 1.1em; margin-bottom: 8px;\">\ud83d\udcc5 30\u5206\u7121\u6599\u76f8\u8ac7\u3001\u53d7\u3051\u4ed8\u3051\u3066\u3044\u307e\u3059<\/p>\n <p>\u300cGWS\u306eAPI\u5236\u5fa1\u3092\u3069\u3046\u8a2d\u8a08\u3059\u308c\u3070\u3044\u3044\u304b\u308f\u304b\u3089\u306a\u3044\u300d\u300c\u3053\u3046\u3044\u3046\u81ea\u52d5\u5316\u3092\u81ea\u793e\u3067\u3082\u5c0e\u5165\u3057\u305f\u3044\u300d\u2014\u2014\u305d\u3046\u3044\u3063\u305f\u6bb5\u968e\u304b\u3089\u304a\u6c17\u8efd\u306b\u3069\u3046\u305e\u3002<\/p>\n <a href=\"https:\/\/calendly.com\/syogo717\/30min\" target=\"_blank\" class=\"cta-button\">\ud83d\udcc5 30\u5206\u7121\u6599\u76f8\u8ac7\u3092\u4e88\u7d04\u3059\u308b \u2192<\/a>\n<\/div>\n\n<\/body>\n<\/html>\n","protected":false},"excerpt":{"rendered":"<p>GWS\u306e\u5916\u90e8\u30a2\u30d7\u30ea\u63a5\u7d9a\u3092\u5236\u5fa1\u3057\u3066Slack\u901a\u77e5\uff0bClaude\u5206\u6790\u307e\u3067\u81ea\u52d5\u5316\u3057\u305f\u8a71\u3010GAS\u5b9f\u88c5\u3011 \u3053\u306e\u8a18\u4e8b\u3067\u308f\u304b\u308b\u3053\u3068 Google Workspace\u3067\u5916\u90e8\u30a2\u30d7\u30ea\u3078\u306e\u63a5\u7d9a\u3092\u5236\u5fa1\u3059\u308b\u8a2d\u8a08\u306e\u8003\u3048\u65b9 OU\u3054\u3068\u306b\u7570\u306a\u308b\u5236\u5fa1\u65b9\u91dd\u3092 […]<\/p>\n","protected":false},"author":1,"featured_media":396,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,11,3,10,4],"tags":[],"class_list":["post-395","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai","category-google-workspace","category-it","category-10","category-4"],"_links":{"self":[{"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/posts\/395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=395"}],"version-history":[{"count":1,"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions"}],"predecessor-version":[{"id":397,"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions\/397"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/media\/396"}],"wp:attachment":[{"href":"https:\/\/hige-josys.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":395,"date":"2026-04-18T22:33:30","date_gmt":"2026-04-18T13:33:30","guid":{"rendered":"https:\/\/hige-josys.info\/?p=395"},"modified":"2026-04-18T22:33:32","modified_gmt":"2026-04-18T13:33:32","slug":"gws%e3%81%ae%e5%a4%96%e9%83%a8%e3%82%a2%e3%83%97%e3%83%aa%e6%8e%a5%e7%b6%9a%e3%82%92%e5%88%b6%e5%be%a1%e3%81%97%e3%81%a6slack%e9%80%9a%e7%9f%a5%ef%bc%8bclaude%e5%88%86%e6%9e%90%e3%81%be%e3%81%a7","status":"publish","type":"post","link":"https:\/\/hige-josys.info\/?p=395","title":{"rendered":"GWS\u306e\u5916\u90e8\u30a2\u30d7\u30ea\u63a5\u7d9a\u3092\u5236\u5fa1\u3057\u3066Slack\u901a\u77e5\uff0bClaude\u5206\u6790\u307e\u3067\u81ea\u52d5\u5316\u3057\u305f\u8a71\u3010GAS\u5b9f\u88c5\u30b3\u30fc\u30c9\u4ed8\u304d\u3011"},"content":{"rendered":"\n\n\n\n\n\nGWS\u306e\u5916\u90e8\u30a2\u30d7\u30ea\u63a5\u7d9a\u3092\u5236\u5fa1\u3057\u3066Slack\u901a\u77e5\uff0bClaude\u5206\u6790\u307e\u3067\u81ea\u52d5\u5316\u3057\u305f\u8a71\u3010GAS\u5b9f\u88c5\u3011<\/title>\n<style>\n body { font-family: 'Hiragino Sans', 'Meiryo', sans-serif; padding: 24px; color: #333; line-height: 1.8; }\n h2 { font-size: 1.3em; border-left: 4px solid #3b5bdb; padding-left: 12px; margin-top: 48px; }\n h3 { font-size: 1.1em; margin-top: 32px; color: #1e3a8a; }\n .intro-box { background: #f7f8ff; border: 1px solid #c5cff5; border-radius: 6px; padding: 16px 20px; margin: 20px 0; }\n .intro-box ul { padding-left: 20px !important; }\n .intro-box ul li { list-style: disc !important; }\n .point { background: #fff8e1; border-left: 4px solid #ffc107; padding: 12px 16px; margin: 16px 0; border-radius: 0 4px 4px 0; }\n .warn { background: #fff1f2; border-left: 4px solid #e11d48; padding: 12px 16px; margin: 16px 0; border-radius: 0 4px 4px 0; }\n .good { background: #f0fdf4; border-left: 4px solid #22c55e; padding: 12px 16px; margin: 16px 0; border-radius: 0 4px 4px 0; }\n .cta-box { background-color: #f0f4ff; border-left: 4px solid #3b5bdb; padding: 24px; margin: 40px 0; border-radius: 4px; }\n .cta-button { display: inline-block; background-color: #3b5bdb; color: white; padding: 12px 24px; border-radius: 4px; text-decoration: none; font-weight: bold; margin-top: 12px; }\n .internal-link { background: #f0f4ff; border: 1px solid #c5cff5; border-radius: 4px; padding: 12px 16px; margin: 16px 0; font-size: 0.95em; }\n .code-block { background: #1e293b; color: #e2e8f0; border-radius: 8px; padding: 16px 20px; margin: 16px 0; font-size: 13px; line-height: 1.8; font-family: 'Courier New', monospace; white-space: pre-wrap; overflow-x: auto; }\n .flow { display: flex; flex-direction: column; gap: 0; margin: 20px 0; }\n .flow-step { background: #f8fafc; border: 1px solid #e2e8f0; border-radius: 8px; padding: 12px 16px; margin-bottom: 4px; font-size: 14px; }\n .flow-arrow { text-align: center; color: #94a3b8; font-size: 18px; line-height: 1.2; }\n table { width: 100%; border-collapse: collapse; margin: 20px 0; font-size: 14px; }\n th { background: #1e3a8a !important; color: white !important; padding: 10px 12px !important; text-align: left !important; }\n td { padding: 10px 12px; border-bottom: 1px solid #e2e8f0; vertical-align: top; }\n tr:nth-child(even) td { background: #f7f8ff; }\n<\/style>\n<\/head>\n<body>\n\n<div class=\"intro-box\">\n <strong>\u3053\u306e\u8a18\u4e8b\u3067\u308f\u304b\u308b\u3053\u3068<\/strong>\n <ul>\n <li>Google Workspace\u3067\u5916\u90e8\u30a2\u30d7\u30ea\u3078\u306e\u63a5\u7d9a\u3092\u5236\u5fa1\u3059\u308b\u8a2d\u8a08\u306e\u8003\u3048\u65b9<\/li>\n <li>OU\u3054\u3068\u306b\u7570\u306a\u308b\u5236\u5fa1\u65b9\u91dd\u3092\u9069\u7528\u3059\u308b\u65b9\u6cd5<\/li>\n <li>GAS\u3067OAuth\u7533\u8acb\u3092Slack\u306b\u81ea\u52d5\u901a\u77e5\u3059\u308b\u4ed5\u7d44\u307f\u306e\u4f5c\u308a\u65b9<\/li>\n <li>Claude\u306eAPI\u3092GAS\u304b\u3089\u547c\u3073\u51fa\u3057\u3066\u627f\u8a8d\u5224\u65ad\u3092\u81ea\u52d5\u5206\u6790\u3055\u305b\u308b\u5b9f\u88c5<\/li>\n <\/ul>\n<\/div>\n\n<p>\u3042\u308b\u4f1a\u793e\u3067GWS\u306eAPI\u5236\u5fa1\u2014\u2014\u3064\u307e\u308a\u3001\u793e\u54e1\u304c\u5916\u90e8\u30a2\u30d7\u30ea\u306bGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u9023\u643a\u3055\u305b\u308b\u3053\u3068\u3078\u306e\u5236\u5fa1\u2014\u2014\u3092\u6574\u5099\u3059\u308b\u3053\u3068\u306b\u306a\u3063\u305f\u3002<\/p>\n\n<p>\u76ee\u7684\u306f\u30b7\u30f3\u30d7\u30eb\u3067\u3001<strong>\u91ce\u826fSaaS\u3078\u306e\u60c5\u5831\u6d41\u51fa\u30fb\u610f\u56f3\u3057\u306a\u3044\u30c7\u30fc\u30bf\u9023\u643a\u3092\u9632\u3050<\/strong>\u3053\u3068\u3060\u3002\u305f\u3060\u5358\u306b\u300c\u5168\u90e8\u7981\u6b62\u300d\u306b\u3059\u308c\u3070\u696d\u52d9\u304c\u6b62\u307e\u308b\u3057\u3001\u300c\u5168\u90e8\u8a31\u53ef\u300d\u3067\u306f\u7ba1\u7406\u306b\u306a\u3089\u306a\u3044\u3002\u305d\u3053\u3067\u5236\u5fa1\u65b9\u91dd\u3092\u8a2d\u8a08\u3057\u3001\u7533\u8acb\u304c\u6765\u305f\u3089\u81ea\u52d5\u3067Slack\u306b\u901a\u77e5\uff0bClaude\u306eAPI\u3067\u5b89\u5168\u6027\u3092\u5206\u6790\u3059\u308b\u4ed5\u7d44\u307f\u307e\u3067\u5b9f\u88c5\u3057\u305f\u3002\u3053\u306e\u8a18\u4e8b\u306f\u305d\u306e\u8a2d\u8a08\u3068\u5b9f\u88c5\u306e\u8a71\u3060\u3002<\/p>\n\n<h2>\u25bc\u80cc\u666f\uff1aGWS\u306eAPI\u63a5\u7d9a\u304c\u91ce\u826f\u72b6\u614b\u306b\u306a\u3063\u3066\u3044\u305f<\/h2>\n\n<p>Google Admin\u306eAPI\u5236\u5fa1\u753b\u9762\u3092\u958b\u304f\u3068\u3001\u793e\u54e1\u304c\u81ea\u7531\u306b\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u3078\u306eOAuth\u9023\u643a\u3092\u884c\u3063\u3066\u3044\u305f\u72b6\u614b\u304c\u53ef\u8996\u5316\u3055\u308c\u305f\u3002Zoom\u304cGmail\u3068Drive\u306b\u30d5\u30eb\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3044\u305f\u308a\u3001\u7528\u9014\u4e0d\u660e\u306e\u30b5\u30fc\u30c9\u30d1\u30fc\u30c6\u30a3GAS\u304c\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u8aad\u307f\u66f8\u304d\u3057\u3066\u3044\u305f\u308a\u3068\u3001\u300c\u8ab0\u304c\u4f55\u3092\u8a31\u53ef\u3057\u305f\u304b\u300d\u304c\u8ab0\u306b\u3082\u628a\u63e1\u3067\u304d\u3066\u3044\u306a\u3044\u72b6\u614b\u3060\u3063\u305f\u3002<\/p>\n\n<div class=\"warn\">\n \u26a0\ufe0f <strong>\u653e\u7f6e\u3059\u308b\u3068\u4f55\u304c\u8d77\u304d\u308b\u304b<\/strong><br>\n \u30fb\u9000\u8077\u8005\u304c\u4f7f\u3063\u3066\u3044\u305f\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u304cGmail\u3084Drive\u306b\u63a5\u7d9a\u3057\u305f\u307e\u307e\u306b\u306a\u308b<br>\n \u30fb\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5be9\u67fb\u3067\u300c\u5916\u90e8\u30a2\u30d7\u30ea\u3078\u306e\u30a2\u30af\u30bb\u30b9\u7ba1\u7406\u72b6\u6cc1\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u300d\u3068\u554f\u308f\u308c\u3066\u3082\u7b54\u3048\u3089\u308c\u306a\u3044<br>\n \u30fb\u91ce\u826fGAS\uff08\u500b\u4ebaGmail\u3067\u4f5c\u6210\u3055\u308c\u305f\u30b9\u30af\u30ea\u30d7\u30c8\uff09\u304c\u793e\u5185\u306e\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u8aad\u307f\u66f8\u304d\u3057\u7d9a\u3051\u308b\n<\/div>\n\n<h2>\u25bc\u5236\u5fa1\u65b9\u91dd\u306e\u8a2d\u8a08<\/h2>\n\n<h3>\u2460 \u6700\u4f4e\u8981\u4ef6\u3092\u6c7a\u3081\u308b\uff1a\u30ed\u30b0\u30a4\u30f3\u60c5\u5831\u306e\u307fOK<\/h3>\n\n<p>\u5916\u90e8\u30a2\u30d7\u30ea\u304cGoogle\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u8981\u6c42\u3059\u308b\u30b9\u30b3\u30fc\u30d7\u306f\u5927\u304d\u304f2\u7a2e\u985e\u306b\u5206\u3051\u3089\u308c\u308b\u3002<\/p>\n\n<table>\n <tr>\n <th>\u7a2e\u5225<\/th>\n <th>\u30b9\u30b3\u30fc\u30d7\u4f8b<\/th>\n <th>\u65b9\u91dd<\/th>\n <\/tr>\n <tr>\n <td><strong>\u57fa\u672c\u30b9\u30b3\u30fc\u30d7<\/strong><\/td>\n <td>openid \/ email \/ profile \/ userinfo.email \/ userinfo.profile<\/td>\n <td>\u2705 \u539f\u5247\u8a31\u53ef\uff08Google\u30ed\u30b0\u30a4\u30f3\u306e\u307f\uff09<\/td>\n <\/tr>\n <tr>\n <td><strong>\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7<\/strong><\/td>\n <td>Gmail \/ Drive \/ Calendar \/ Contacts \u306a\u3069<\/td>\n <td>\u26a0\ufe0f \u7533\u8acb\u5236\u30fb\u500b\u5225\u5be9\u67fb<\/td>\n <\/tr>\n<\/table>\n\n<p>\u300cGoogle\u3067\u30ed\u30b0\u30a4\u30f3\u300d\u3059\u308b\u3060\u3051\u306a\u3089\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u3067\u5b8c\u7d50\u3059\u308b\u3002\u554f\u984c\u306b\u306a\u308b\u306e\u306f\u3001\u30a2\u30d7\u30ea\u304cGmail\u3092\u8aad\u3093\u3060\u308aDrive\u3092\u66f8\u304d\u63db\u3048\u305f\u308a\u3067\u304d\u308b\u30b9\u30b3\u30fc\u30d7\u3092\u8981\u6c42\u3057\u3066\u304f\u308b\u30b1\u30fc\u30b9\u3060\u3002\u3053\u308c\u3092<strong>\u7533\u8acb\u5236\u306b\u3057\u3066\u30011\u4ef6\u305a\u3064\u5be9\u67fb\u3059\u308b<\/strong>\u3068\u3044\u3046\u65b9\u91dd\u306b\u3057\u305f\u3002<\/p>\n\n<h3>\u2461 OU\u3054\u3068\u306b\u5236\u5fa1\u3092\u5206\u3051\u308b<\/h3>\n\n<p>\u5168\u793e\u54e1\u306b\u540c\u3058\u5236\u5fa1\u3092\u304b\u3051\u308b\u306e\u3067\u306f\u306a\u304f\u3001OU\u306e\u6027\u8cea\u306b\u5fdc\u3058\u3066\u9069\u7528\u30eb\u30fc\u30eb\u3092\u5909\u3048\u305f\u3002<\/p>\n\n<table>\n <tr>\n <th>\u5bfe\u8c61OU<\/th>\n <th>\u5236\u5fa1\u65b9\u91dd<\/th>\n <\/tr>\n <tr>\n <td>\u6b63\u793e\u54e1\u30fb\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u7b49<\/td>\n <td>\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306f\u81ea\u7531\u306b\u8a31\u53ef\u3002\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u306f\u7533\u8acb\u5236<\/td>\n <\/tr>\n <tr>\n <td>\u696d\u52d9\u59d4\u8a17\u30fb\u30a4\u30f3\u30bf\u30fc\u30f3\u30fb\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8<\/td>\n <td>\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u3092\u542b\u3080\u5168\u30a2\u30af\u30bb\u30b9\u3092\u7533\u8acb\u5236\uff08\u3088\u308a\u53b3\u683c\u306b\u7ba1\u7406\uff09<\/td>\n <\/tr>\n<\/table>\n\n<p>\u696d\u52d9\u59d4\u8a17\u3084\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306f\u7279\u306b\u7ba1\u7406\u304c\u629c\u3051\u3084\u3059\u3044\u306e\u3067\u3001\u3053\u3061\u3089\u306f\u5168\u30b9\u30b3\u30fc\u30d7\u7533\u8acb\u5236\u306b\u3057\u305f\u3002<\/p>\n\n<h3>\u2462 \u7533\u8acb\u304c\u6765\u305f\u3089Slack\u306b\u901a\u77e5\uff0bClaude\u5206\u6790<\/h3>\n\n<p>\u5236\u5fa1\u8a2d\u5b9a\u3092\u5165\u308c\u308b\u3060\u3051\u3067\u306f\u300c\u7533\u8acb\u304c\u6765\u3066\u3082\u8ab0\u3082\u6c17\u3065\u304b\u306a\u3044\u300d\u554f\u984c\u304c\u8d77\u304d\u308b\u3002\u306a\u306e\u3067\u7533\u8acb\u304c\u3042\u3063\u305f\u77ac\u9593\u306bSlack\u3078\u901a\u77e5\u3057\u3001\u305d\u306e\u30b9\u30ec\u30c3\u30c9\u306bClaude\u304c\u81ea\u52d5\u3067\u30a2\u30d7\u30ea\u306e\u6982\u8981\u30fb\u30ea\u30b9\u30af\u30fb\u627f\u8a8d\u5224\u65ad\u3092\u6295\u7a3f\u3059\u308b\u4ed5\u7d44\u307f\u3092\u4f5c\u3063\u305f\u3002<\/p>\n\n<h2>\u25bc\u4ed5\u7d44\u307f\u306e\u5168\u4f53\u50cf<\/h2>\n\n<div class=\"flow\">\n <div class=\"flow-step\">\u2460 \u793e\u54e1\u304cGWS\u4e0a\u3067\u5916\u90e8\u30a2\u30d7\u30ea\u306e\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u63a5\u7d9a\u3092\u8a66\u307f\u308b<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2461 Google Admin\u306eAPI\u5236\u5fa1\u3067\u30ea\u30af\u30a8\u30b9\u30c8\u3068\u3057\u3066\u8a18\u9332\u3055\u308c\u308b<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2462 GAS\u304c5\u5206\u304a\u304d\u306bAdmin Reports API\u3092\u30dd\u30fc\u30ea\u30f3\u30b0\u3057\u3066\u7533\u8acb\u3092\u691c\u77e5<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2463 \u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306e\u307f\u306e\u7533\u8acb\u306f\u30b9\u30ad\u30c3\u30d7\u3002\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u304c\u3042\u308b\u7533\u8acb\u3060\u3051Slack\u306b\u901a\u77e5<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2464 \u540c\u3058\u901a\u77e5\u306e\u30b9\u30ec\u30c3\u30c9\u306bClaude\u304c\u30a2\u30d7\u30ea\u6982\u8981\u30fb\u30ea\u30b9\u30af\u30fb\u5224\u65ad\u3092\u81ea\u52d5\u6295\u7a3f<\/div>\n <div class=\"flow-arrow\">\u2193<\/div>\n <div class=\"flow-step\">\u2465 \u7ba1\u7406\u8005\u304cSlack\u3092\u898b\u3066Google Admin Console\u3067\u627f\u8a8d\/\u5374\u4e0b<\/div>\n<\/div>\n\n<div class=\"point\">\n \ud83d\udca1 <strong>\u306a\u305c\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u306f\u306a\u304f\u30dd\u30fc\u30ea\u30f3\u30b0\u304b<\/strong><br>\n Google Admin Reports API\u306fPush\u901a\u77e5\uff08Webhook\uff09\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u3002\u305d\u306e\u305f\u3081GAS\u306e\u30c8\u30ea\u30ac\u30fc\u30675\u5206\u304a\u304d\u306b\u7533\u8acb\u3092\u53d6\u5f97\u3059\u308b\u30dd\u30fc\u30ea\u30f3\u30b0\u65b9\u5f0f\u3092\u63a1\u7528\u3057\u3066\u3044\u308b\u3002\u6700\u59275\u5206\u306e\u30bf\u30a4\u30e0\u30e9\u30b0\u304c\u751f\u3058\u308b\u304c\u3001\u5b9f\u52d9\u4e0a\u306f\u554f\u984c\u306a\u3044\u3002\n<\/div>\n\n<h2>\u25bc\u5b9f\u88c5\uff1aGAS\u306e\u30b3\u30fc\u30c9\u89e3\u8aac<\/h2>\n\n<h3>\u8a2d\u5b9a\u5024<\/h3>\n\n<div class=\"code-block\">const SLACK_BOT_TOKEN = ‘xoxb-XXXX-XXXX-XXXX’; \/\/ Slack Bot Token\nconst SLACK_CHANNEL_ID = ‘CXXXXXXXXX’; \/\/ \u901a\u77e5\u5148\u30c1\u30e3\u30f3\u30cd\u30ebID\nconst ANTHROPIC_API_KEY = ‘sk-ant-XXXXXXXXXXXX’; \/\/ Anthropic API\u30ad\u30fc\nconst SPREADSHEET_ID = ‘XXXXXXXXXXXXXXXXXXXX’; \/\/ \u51e6\u7406\u6e08\u307f\u7ba1\u7406\u7528\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8ID\n\n\/\/ \u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306e\u5b9a\u7fa9\uff08\u3053\u308c\u3060\u3051\u306a\u3089\u7533\u8acb\u4e0d\u8981\uff09\nconst BASIC_SCOPES = new Set([\n ‘openid’,\n ‘email’,\n ‘profile’,\n ‘https:\/\/www.googleapis.com\/auth\/userinfo.email’,\n ‘https:\/\/www.googleapis.com\/auth\/userinfo.profile’\n]);<\/div>\n\n<h3>\u30e1\u30a4\u30f3\u51e6\u7406\uff1a\u7533\u8acb\u306e\u691c\u77e5\u3068\u632f\u308a\u5206\u3051<\/h3>\n\n<div class=\"code-block\">function checkPendingRequests() {\n const token = ScriptApp.getOAuthToken();\n \/\/ \u76f4\u8fd172\u6642\u9593\u306e\u7533\u8acb\u3092\u53d6\u5f97\n const startTime = new Date(Date.now() – 72 * 60 * 60 * 1000).toISOString();\n\n const url = ‘https:\/\/admin.googleapis.com\/admin\/reports\/v1\/activity’\n + ‘\/users\/all\/applications\/token’\n + ‘?eventName=request&maxResults=50&startTime=’ + encodeURIComponent(startTime);\n\n const response = UrlFetchApp.fetch(url, {\n headers: { Authorization: ‘Bearer ‘ + token },\n muteHttpExceptions: true\n });\n const data = JSON.parse(response.getContentText());\n\n if (!data.items || data.items.length === 0) return;\n\n const sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getActiveSheet();\n const processed = getProcessedKeys(sheet); \/\/ \u51e6\u7406\u6e08\u307f\u30ad\u30fc\u306eSet\n\n data.items.forEach(item => {\n if (!item.actor?.email || !item.events?.[0]?.parameters) return;\n\n const params = item.events[0].parameters;\n const userEmail = item.actor.email;\n const appName = params.find(p => p.name === ‘app_name’)?.value || ‘\u4e0d\u660e\u306a\u30a2\u30d7\u30ea’;\n const clientId = params.find(p => p.name === ‘client_id’)?.value || ”;\n const scope = (params.find(p => p.name === ‘scope’)?.multiValue || []).join(‘ ‘);\n\n \/\/ \u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306e\u307f \u2192 \u30b9\u30ad\u30c3\u30d7\n if (!hasNonBasicScope(scope)) return;\n\n \/\/ \u91cd\u8907\u30c1\u30a7\u30c3\u30af\uff08\u540c\u3058\u7533\u8acb\u30922\u56de\u901a\u77e5\u3057\u306a\u3044\uff09\n const uniqueKey = userEmail + ‘_’ + appName + ‘_’ + item.id.time;\n if (processed.has(uniqueKey)) return;\n\n const jstTime = formatJst(new Date(item.id.time));\n\n \/\/ Slack\u901a\u77e5 \u2192 \u30b9\u30ec\u30c3\u30c9ts\u3092\u53d6\u5f97\n const ts = postSlackNotification(userEmail, appName, jstTime, clientId, scope);\n if (!ts) return;\n\n \/\/ Claude\u306b\u3088\u308b\u5206\u6790\u3092\u30b9\u30ec\u30c3\u30c9\u306b\u6295\u7a3f\n postClaudeAnalysis(appName, clientId, scope, ts);\n\n \/\/ \u51e6\u7406\u6e08\u307f\u3068\u3057\u3066\u8a18\u9332\n sheet.appendRow([uniqueKey, userEmail, appName, scope, new Date().toISOString()]);\n });\n}<\/div>\n\n<h3>\u30dd\u30a4\u30f3\u30c8\u2460\uff1a\u30b9\u30b3\u30fc\u30d7\u5224\u5b9a<\/h3>\n\n<div class=\"code-block\">function hasNonBasicScope(scope) {\n if (!scope) return false;\n \/\/ \u30b9\u30b3\u30fc\u30d7\u6587\u5b57\u5217\u3092\u5206\u5272\u3057\u3066\u30011\u3064\u3067\u3082\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u4ee5\u5916\u304c\u3042\u308c\u3070true\n return scope.split(‘ ‘).filter(Boolean).some(s => !BASIC_SCOPES.has(s));\n}<\/div>\n\n<p>\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u3060\u3051\u306e\u30a2\u30d7\u30ea\uff08Google\u30ed\u30b0\u30a4\u30f3\u306e\u307f\uff09\u306f\u901a\u77e5\u4e0d\u8981\u306a\u306e\u3067\u30b9\u30ad\u30c3\u30d7\u3059\u308b\u3002\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u304c1\u3064\u3067\u3082\u542b\u307e\u308c\u3066\u3044\u305f\u3089\u901a\u77e5\u5bfe\u8c61\u306b\u306a\u308b\u3002<\/p>\n\n<h3>\u30dd\u30a4\u30f3\u30c8\u2461\uff1a\u91cd\u8907\u9632\u6b62<\/h3>\n\n<div class=\"code-block\">function getProcessedKeys(sheet) {\n const lastRow = sheet.getLastRow();\n if (lastRow === 0) return new Set();\n return new Set(\n sheet.getRange(1, 1, lastRow, 1).getValues().flat().map(String).filter(Boolean)\n );\n}<\/div>\n\n<p>5\u5206\u304a\u304d\u306b\u5b9f\u884c\u3059\u308b\u305f\u3081\u30dd\u30fc\u30ea\u30f3\u30b0\u3059\u308b\u305f\u3073\u306b\u540c\u3058\u7533\u8acb\u304c\u53d6\u308c\u3066\u3057\u307e\u3046\u3002\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u51e6\u7406\u6e08\u307f\u30ad\u30fc\u3092\u8a18\u9332\u3057\u3066\u304a\u304d\u3001\u91cd\u8907\u306f\u901a\u77e5\u3057\u306a\u3044\u8a2d\u8a08\u306b\u3057\u305f\u3002<\/p>\n\n<h3>\u30dd\u30a4\u30f3\u30c8\u2462\uff1aSlack\u901a\u77e5\uff08\u30b9\u30ec\u30c3\u30c9ts\u3092\u8fd4\u3059\uff09<\/h3>\n\n<div class=\"code-block\">function postSlackNotification(userEmail, appName, requestTime, clientId, scope) {\n const text = [\n ‘\u26a0\ufe0f *OAuth\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u7533\u8acb\u304c\u5c4a\u304d\u307e\u3057\u305f*’,\n ‘*\u7533\u8acb\u8005:* ‘ + userEmail,\n ‘*\u30a2\u30d7\u30ea:* ‘ + appName,\n ‘*\u65e5\u6642:* ‘ + requestTime,\n ‘*\u8981\u6c42\u30b9\u30b3\u30fc\u30d7:* `’ + (scope || ‘\u4e0d\u660e’) + ‘`’,\n ”,\n ‘\ud83d\udc49 \u5be9\u67fb\u30da\u30fc\u30b8: https:\/\/admin.google.com\/ac\/owl\/list?tab=pendingReviewApps’\n ].join(‘\\n’);\n\n const response = UrlFetchApp.fetch(‘https:\/\/slack.com\/api\/chat.postMessage’, {\n method: ‘post’,\n contentType: ‘application\/json’,\n headers: { Authorization: ‘Bearer ‘ + SLACK_BOT_TOKEN },\n payload: JSON.stringify({ channel: SLACK_CHANNEL_ID, text: text }),\n muteHttpExceptions: true\n });\n\n const result = JSON.parse(response.getContentText());\n if (!result.ok) {\n console.error(‘Slack\u6295\u7a3f\u30a8\u30e9\u30fc:’, result.error);\n return null;\n }\n return result.ts; \/\/ \u30b9\u30ec\u30c3\u30c9\u306b\u8fd4\u4fe1\u3059\u308b\u305f\u3081\u306bts\u3092\u8fd4\u3059\n}<\/div>\n\n<h3>\u30dd\u30a4\u30f3\u30c8\u2463\uff1aClaude\u306eAPI\u3092GAS\u304b\u3089\u547c\u3073\u51fa\u3059<\/h3>\n\n<div class=\"code-block\">function postClaudeAnalysis(appName, clientId, scope, threadTs) {\n const prompt = ‘\u4ee5\u4e0b\u306e\u30a2\u30d7\u30ea\u306b\u3064\u3044\u3066\u3001Google Workspace\u306e\u7ba1\u7406\u8005\u304c\u627f\u8a8d\u5224\u65ad\u3067\u304d\u308b\u3088\u3046\u65e5\u672c\u8a9e\u3067\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\\n\\n’\n + ‘\u30a2\u30d7\u30ea\u540d: ‘ + appName + ‘\\n’\n + ‘Client ID: ‘ + clientId + ‘\\n’\n + ‘\u8981\u6c42\u30b9\u30b3\u30fc\u30d7: ‘ + scope + ‘\\n\\n’\n + ‘\u4ee5\u4e0b\u306e\u5f62\u5f0f\u3067Slack\u5411\u3051\u30c6\u30ad\u30b9\u30c8\u3092\u51fa\u529b\u3057\u3066\u304f\u3060\u3055\u3044\uff08Slack\u5f62\u5f0f\uff1a*\u592a\u5b57*\u3001\u7b87\u6761\u66f8\u304d\u306f \u2022\uff09:\\n\\n’\n + ‘*\ud83d\udcf1 \u30a2\u30d7\u30ea\u6982\u8981*\\n\uff081\u301c2\u6587\uff09\\n\\n’\n + ‘*\ud83d\udd10 \u3053\u306e\u30b9\u30b3\u30fc\u30d7\u3067\u53ef\u80fd\u306b\u306a\u308b\u3053\u3068*\\n\u2022 \uff08\u5177\u4f53\u7684\u306b\u7b87\u6761\u66f8\u304d\uff09\\n\\n’\n + ‘*\u26a0\ufe0f \u30ea\u30b9\u30af*\\n\u2022 \uff08\u7b87\u6761\u66f8\u304d\uff09\\n\\n’\n + ‘*\ud83d\udca1 \u5224\u65ad: [\u627f\u8a8d\u63a8\u5968 \/ \u8981\u78ba\u8a8d \/ \u62d2\u5426\u63a8\u5968]*\\n\uff08\u7406\u7531\u30921\u6587\uff09’;\n\n const response = UrlFetchApp.fetch(‘https:\/\/api.anthropic.com\/v1\/messages’, {\n method: ‘post’,\n headers: {\n ‘Content-Type’: ‘application\/json’,\n ‘x-api-key’: ANTHROPIC_API_KEY,\n ‘anthropic-version’: ‘2023-06-01’\n },\n payload: JSON.stringify({\n model: ‘claude-opus-4-5’,\n max_tokens: 1024,\n messages: [{ role: ‘user’, content: prompt }]\n }),\n muteHttpExceptions: true\n });\n\n const data = JSON.parse(response.getContentText());\n const analysisText = data.content?.[0]?.text || ‘\u5206\u6790\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f’;\n\n \/\/ \u901a\u77e5\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u30b9\u30ec\u30c3\u30c9\u306b\u8fd4\u4fe1\n postThreadMessage(threadTs, ‘\ud83e\udd16 *Claude \u306b\u3088\u308b\u5b89\u5168\u6027\u5206\u6790*\\n\\n’ + analysisText);\n}<\/div>\n\n<h2>\u25bc\u5b9f\u969b\u306eSlack\u901a\u77e5\u30a4\u30e1\u30fc\u30b8<\/h2>\n\n<p>\u7533\u8acb\u304c\u6765\u308b\u3068\u3053\u3093\u306a\u5f62\u3067Slack\u306b\u901a\u77e5\u3055\u308c\u308b\u3002<\/p>\n\n<div class=\"code-block\">\u26a0\ufe0f OAuth\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u7533\u8acb\u304c\u5c4a\u304d\u307e\u3057\u305f\n\u7533\u8acb\u8005: user@example.com\n\u30a2\u30d7\u30ea: Genspark\n\u65e5\u6642: 2026\/04\/13 11:23:47\n\u8981\u6c42\u30b9\u30b3\u30fc\u30d7: `https:\/\/www.googleapis.com\/auth\/gmail.modify https:\/\/www.googleapis.com\/auth\/drive.file`\n\n\ud83d\udc49 \u5be9\u67fb\u30da\u30fc\u30b8: https:\/\/admin.google.com\/ac\/owl\/list?tab=pendingReviewApps<\/div>\n\n<p>\u305d\u306e\u30b9\u30ec\u30c3\u30c9\u306bClaude\u304c\u81ea\u52d5\u3067\u5206\u6790\u3092\u8fd4\u3057\u3066\u304f\u308b\u3002<\/p>\n\n<div class=\"code-block\">\ud83e\udd16 Claude \u306b\u3088\u308b\u5b89\u5168\u6027\u5206\u6790\n\n\ud83d\udcf1 \u30a2\u30d7\u30ea\u6982\u8981\nGenspark\u306f\u751f\u6210AI\u3092\u6d3b\u7528\u3057\u305f\u30a6\u30a7\u30d6\u691c\u7d22\u30fb\u30b3\u30f3\u30c6\u30f3\u30c4\u751f\u6210\u30c4\u30fc\u30eb\u3067\u3059\u3002\n\n\ud83d\udd10 \u3053\u306e\u30b9\u30b3\u30fc\u30d7\u3067\u53ef\u80fd\u306b\u306a\u308b\u3053\u3068\n\u2022 gmail.modify\uff1a\u30e1\u30fc\u30eb\u306e\u8aad\u307f\u53d6\u308a\u30fb\u9001\u4fe1\u30fb\u79fb\u52d5\u30fb\u524a\u9664\u304c\u53ef\u80fd\n\u2022 drive.file\uff1a\u30a2\u30d7\u30ea\u304c\u4f5c\u6210\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3078\u306e\u30a2\u30af\u30bb\u30b9\u304c\u53ef\u80fd\n\n\u26a0\ufe0f \u30ea\u30b9\u30af\n\u2022 Gmail\u3078\u306e\u30d5\u30eb\u30a2\u30af\u30bb\u30b9\u306b\u3088\u308a\u3001\u6a5f\u5bc6\u60c5\u5831\u3092\u542b\u3080\u30e1\u30fc\u30eb\u304c\u5916\u90e8\u306b\u9001\u4fe1\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\n\u2022 AI\u7cfb\u30b5\u30fc\u30d3\u30b9\u3078\u306e\u5165\u529b\u30c7\u30fc\u30bf\u304c\u5b66\u7fd2\u306b\u5229\u7528\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\n\n\ud83d\udca1 \u5224\u65ad: \u8981\u78ba\u8a8d\n\u696d\u52d9\u4e0a\u306e\u5fc5\u8981\u6027\u3092\u7533\u8acb\u8005\u306b\u78ba\u8a8d\u3057\u305f\u4e0a\u3067\u3001\u6a5f\u5bc6\u60c5\u5831\u3092\u542b\u3080\u30e1\u30fc\u30eb\u3092\u6271\u308f\u306a\u3044\u904b\u7528\u30eb\u30fc\u30eb\u3092\u6574\u5099\u3057\u3066\u304b\u3089\u627f\u8a8d\u3092\u691c\u8a0e\u3059\u308b\u3053\u3068\u3092\u63a8\u5968\u3057\u307e\u3059\u3002<\/div>\n\n<h2>\u25bc\u5b9f\u88c5\u3067\u30cf\u30de\u3063\u305f\u3053\u3068<\/h2>\n\n<ul style=\"list-style: none !important; padding-left: 0 !important;\">\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>Admin Reports API\u306feventName=authorize\u3058\u3083\u306a\u3044<\/strong>\uff1a\u300c\u5be9\u67fb\u5f85\u3061\u300d\u306e\u30a4\u30d9\u30f3\u30c8\u306feventName=<code>request<\/code>\u3067\u53d6\u5f97\u3059\u308b\u3002<code>authorize<\/code>\u306f\u627f\u8a8d\u6e08\u307f\u306e\u30ed\u30b0\u5168\u4ef6\u304c\u8fd4\u3063\u3066\u304f\u308b\u306e\u3067\u5225\u7269<\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>Admin SDK\u306fAdmin Reports\u3068\u540c\u3058\u30b5\u30fc\u30d3\u30b9\u306b\u767b\u9332\u3067\u304d\u306a\u3044<\/strong>\uff1aGAS\u306e\u30b5\u30fc\u30d3\u30b9\u306bAdmin SDK API\u3092\u8ffd\u52a0\u3059\u308b\u969b\u3001directory_v1\u3068reports_v1\u306f\u5225\u3005\u306b\u767b\u9332\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308b\u3002Reports API\u306fURLFetchApp\u3067\u76f4\u63a5\u53e9\u304f\u65b9\u6cd5\u3067\u89e3\u6c7a\u3057\u305f<\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>Slack\u306e\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8\u30c1\u30e3\u30f3\u30cd\u30eb\u3078\u306e\u6295\u7a3f\u306b\u306fgroups:history\u30b9\u30b3\u30fc\u30d7\u304c\u5fc5\u8981<\/strong>\uff1a\u30d1\u30d6\u30ea\u30c3\u30af\u30c1\u30e3\u30f3\u30cd\u30eb\u3068\u306f\u5fc5\u8981\u306a\u30b9\u30b3\u30fc\u30d7\u304c\u7570\u306a\u308b<\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>\u30b9\u30ec\u30c3\u30c9\u3078\u306e\u8fd4\u4fe1\u306b\u306fmessage_ts\u3067\u306f\u306a\u304fmessage.ts<\/strong>\uff1aSlack\u306e\u30da\u30a4\u30ed\u30fc\u30c9\u69cb\u9020\u304c\u53e4\u3044attachments\u5f62\u5f0f\u3060\u3068ts\u306e\u53d6\u5f97\u30d1\u30b9\u304c\u5909\u308f\u308b<\/li>\n<\/ul>\n\n<h2>\u25bc\u307e\u3068\u3081<\/h2>\n\n<ul style=\"list-style: none !important; padding-left: 0 !important;\">\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>GWS\u306eAPI\u5236\u5fa1\u306f\u300c\u5168\u7981\u6b62\u300d\u3067\u306f\u306a\u304f\u300c\u57fa\u672c\u30b9\u30b3\u30fc\u30d7\u306fOK\u30fb\u8ffd\u52a0\u30b9\u30b3\u30fc\u30d7\u306f\u7533\u8acb\u5236\u300d\u304c\u73fe\u5b9f\u7684<\/strong><\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>OU\u5225\u306b\u5236\u5fa1\u306e\u53b3\u3057\u3055\u3092\u5909\u3048\u308b\u3053\u3068\u3067\u3001\u696d\u52d9\u59d4\u8a17\u30fb\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u539a\u304f\u7ba1\u7406\u3067\u304d\u308b<\/strong><\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>GAS\uff0bAdmin Reports API\uff0bSlack\uff0bClaude API\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u7533\u8acb\u901a\u77e5\u301c\u5b89\u5168\u6027\u5206\u6790\u307e\u3067\u304c\u5168\u81ea\u52d5\u306b\u306a\u308b<\/strong><\/li>\n <li style=\"list-style: none !important; padding: 8px 0 8px 8px;\">\u25b6 <strong>Claude\u306b\u300c\u30a2\u30d7\u30ea\u6982\u8981\u30fb\u30ea\u30b9\u30af\u30fb\u5224\u65ad\u300d\u3092\u51fa\u529b\u3055\u305b\u308b\u3053\u3068\u3067\u3001\u60c5\u30b7\u30b9\u62c5\u5f53\u8005\u304c\u30b9\u30b3\u30fc\u30d7\u306e\u610f\u5473\u30921\u304b\u3089\u8abf\u3079\u306a\u304f\u3066\u3088\u304f\u306a\u308b<\/strong><\/li>\n<\/ul>\n\n<div class=\"internal-link\">\n \ud83d\udcc4 GWS\u306e\u30c9\u30e9\u30a4\u30d6\u6a29\u9650\u8a2d\u8a08\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/hige-josys.info\/\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3067\u3082\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\n<\/div>\n\n<div class=\"internal-link\">\n \ud83d\udcc4 SaaS\u30a2\u30ab\u30a6\u30f3\u30c8\u68da\u5378\u3057\u306e\u5168\u4f53\u8a2d\u8a08\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/hige-josys.info\/?p=379\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3067\u3082\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002\n<\/div>\n\n<div class=\"cta-box\">\n <p style=\"font-weight: bold; font-size: 1.1em; margin-bottom: 8px;\">\ud83d\udcc5 30\u5206\u7121\u6599\u76f8\u8ac7\u3001\u53d7\u3051\u4ed8\u3051\u3066\u3044\u307e\u3059<\/p>\n <p>\u300cGWS\u306eAPI\u5236\u5fa1\u3092\u3069\u3046\u8a2d\u8a08\u3059\u308c\u3070\u3044\u3044\u304b\u308f\u304b\u3089\u306a\u3044\u300d\u300c\u3053\u3046\u3044\u3046\u81ea\u52d5\u5316\u3092\u81ea\u793e\u3067\u3082\u5c0e\u5165\u3057\u305f\u3044\u300d\u2014\u2014\u305d\u3046\u3044\u3063\u305f\u6bb5\u968e\u304b\u3089\u304a\u6c17\u8efd\u306b\u3069\u3046\u305e\u3002<\/p>\n <a href=\"https:\/\/calendly.com\/syogo717\/30min\" target=\"_blank\" class=\"cta-button\">\ud83d\udcc5 30\u5206\u7121\u6599\u76f8\u8ac7\u3092\u4e88\u7d04\u3059\u308b \u2192<\/a>\n<\/div>\n\n<\/body>\n<\/html>\n","protected":false},"excerpt":{"rendered":"<p>GWS\u306e\u5916\u90e8\u30a2\u30d7\u30ea\u63a5\u7d9a\u3092\u5236\u5fa1\u3057\u3066Slack\u901a\u77e5\uff0bClaude\u5206\u6790\u307e\u3067\u81ea\u52d5\u5316\u3057\u305f\u8a71\u3010GAS\u5b9f\u88c5\u3011 \u3053\u306e\u8a18\u4e8b\u3067\u308f\u304b\u308b\u3053\u3068 Google Workspace\u3067\u5916\u90e8\u30a2\u30d7\u30ea\u3078\u306e\u63a5\u7d9a\u3092\u5236\u5fa1\u3059\u308b\u8a2d\u8a08\u306e\u8003\u3048\u65b9 OU\u3054\u3068\u306b\u7570\u306a\u308b\u5236\u5fa1\u65b9\u91dd\u3092 […]<\/p>\n","protected":false},"author":1,"featured_media":396,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,11,3,10,4],"tags":[],"class_list":["post-395","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai","category-google-workspace","category-it","category-10","category-4"],"_links":{"self":[{"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/posts\/395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=395"}],"version-history":[{"count":1,"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions"}],"predecessor-version":[{"id":397,"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions\/397"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=\/wp\/v2\/media\/396"}],"wp:attachment":[{"href":"https:\/\/hige-josys.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hige-josys.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}