{"id":267,"date":"2025-05-26T11:37:08","date_gmt":"2025-05-26T02:37:08","guid":{"rendered":"https:\/\/cg-method.com\/google\/?p=267"},"modified":"2026-10-28T20:58:35","modified_gmt":"2026-10-28T11:58:35","slug":"gcp-natural-language-api","status":"publish","type":"post","link":"https:\/\/cg-method.com\/google\/gcp-natural-language-api\/","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502Natural Language API\u3067\u611f\u60c5\u5206\u6790\u3092\u3059\u308b\u65b9\u6cd5\u2502GCP"},"content":{"rendered":"\n

\u30c6\u30ad\u30b9\u30c8\u304c\u30dd\u30b8\u30c6\u30a3\u30d6\u304b\u30cd\u30ac\u30c6\u30a3\u30d6\u304b\u3001\u3069\u306e\u7a0b\u5ea6\u306e\u611f\u60c5\u306e\u5f37\u3055\u304c\u3042\u308b\u304b\u3092\u5224\u5b9a\u3057\u305f\u3044\u30b1\u30fc\u30b9\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

Google Cloud\u306eNatural Language API\u3067\u3001\u6587\u7ae0\u306b\u8868\u308c\u305f\u611f\u60c5\u306e\u50be\u5411\u3092\u63a8\u5b9a\u3057\u307e\u3059\u3002\u66f8\u304d\u624b\u306e\u672c\u5fc3\u3084\u5065\u5eb7\u72b6\u614b\u3092\u5224\u5b9a\u3059\u308b\u7528\u9014\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\u3053\u306e\u624b\u6cd5\u306f\u30bb\u30f3\u30c1\u30e1\u30f3\u30c8\u5206\u6790\uff08\u611f\u60c5\u5206\u6790\uff09\u3068\u547c\u3070\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\"Google<\/figure>\n\n\n\n

Natural Language API \u306e\u4f7f\u3044\u65b9<\/h2>\n\n\n\n

Google Apps Script\uff08GAS\uff09\u304b\u3089Natural Language API\u3078\u6587\u7ae0\u3092\u9001\u4fe1\u3057\u3001Score\u3068Magnitude\u3092\u30b7\u30fc\u30c8\u306b\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002\u7df4\u7fd2\u306b\u306f\u67b6\u7a7a\u306e\u6587\u7ae0\u3092\u4f7f\u3044\u3001\u9001\u4fe1\u6a29\u9650\u306e\u306a\u3044\u500b\u4eba\u60c5\u5831\u30fb\u6a5f\u5bc6\u60c5\u5831\u306f\u5165\u529b\u3057\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002\u65e2\u5b58\u753b\u50cf\u306f\u65e7\u7248\u306e\u53c2\u8003\u753b\u9762\u3067\u3059\u3002\u4eca\u56de\u306e\u672c\u6587\u30fb\u30b3\u30fc\u30c9\u306e\u898b\u76f4\u3057\u3067\u306fGoogle\u5b9f\u6a5f\u3067\u306eAPI\u901a\u4fe1\u3084\u8ab2\u91d1\u306f\u691c\u8a3c\u3057\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\n
STEP<\/span><\/div>
GCP\uff08Google Cloud Platform\uff09\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210<\/div>
\n

\u753b\u9762\u306e\u6848\u5185\u306b\u6cbf\u3063\u3066\u64cd\u4f5c\u3057\u3001GCP\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u5229\u7528\u3059\u308bGoogle Cloud\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u8acb\u6c42\u5148\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\u767b\u9332\u3067\u304d\u308b\u652f\u6255\u3044\u65b9\u6cd5\u3084\u7d44\u7e54\u306e\u6a29\u9650\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n

\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/svg>\t\t\t\t<\/span>\n\t\t\t\tCloud Natural Language<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\n\n
\"\u30a2\u30ab\u30a6\u30f3\u30c8\u8a2d\u5b9a\u306b\u304a\u3051\u308b\u30af\u30ec\u30b8\u30c3\u30c8\u30ab\u30fc\u30c9\u306e\u767b\u9332\u753b\u9762\u3002\"<\/figure>\n\n\n\n
\n

\u203b\u5229\u7528\u91cf\u304c\u7121\u6599\u67a0\u3092\u8d85\u3048\u308b\u3068\u8ab2\u91d1\u304c\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

2026\u5e7410\u670823\u65e5\u306b\u516c\u5f0f\u6599\u91d1\u8868<\/a>\u3092\u7167\u5408\u3057\u305f\u6642\u70b9\u3067\u306f\u3001\u611f\u60c5\u5206\u6790\u306f\u67085,000\u30e6\u30cb\u30c3\u30c8\u307e\u3067\u7121\u6599\u3067\u3059\u30021\u30ea\u30af\u30a8\u30b9\u30c8\u306eUnicode\u6587\u5b57\u6570\u30921,000\u6587\u5b57\u5358\u4f4d\u3067\u5207\u308a\u4e0a\u3052\u307e\u3059\u30021,500\u6587\u5b57\u306a\u30892\u30e6\u30cb\u30c3\u30c8\u3067\u3001\u518d\u9001\u3082\u5229\u7528\u91cf\u306b\u542b\u307e\u308c\u307e\u3059\u3002\u7121\u6599\u67a0\u306f5,000\u884c\u3068\u3044\u3046\u610f\u5473\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

Google Cloud\u306e\u8acb\u6c42\u30ec\u30dd\u30fc\u30c8\u3067\u5bfe\u8c61\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u5229\u7528\u984d\u3092\u3001API\u306e\u5272\u308a\u5f53\u3066\u753b\u9762\u3067\u5229\u7528\u91cf\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u4e88\u7b97\u30a2\u30e9\u30fc\u30c8\u3060\u3051\u3067API\u304c\u81ea\u52d5\u505c\u6b62\u3059\u308b\u3068\u306f\u9650\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\"GCP\u30b3\u30f3\u30bd\u30fc\u30eb\u306e\u30ca\u30d3\u30b2\u30fc\u30b7\u30e7\u30f3\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u304a\u652f\u6255\u3044\u3068\u6599\u91d1\u3092\u958b\u3044\u3066\u5229\u7528\u72b6\u6cc1\u3084\u91d1\u984d\u3092\u78ba\u8a8d\u3059\u308b\u753b\u9762\u3002\"<\/figure>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n
STEP<\/span><\/div>
API\u3092\u6709\u52b9\u306b\u3059\u308b<\/div>
\n

\u5bfe\u8c61\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067Cloud Natural Language API\u3092\u6709\u52b9\u306b\u3057\u307e\u3059\u3002\u305d\u306e\u5f8c\u300cAPI\u3068\u30b5\u30fc\u30d3\u30b9\u300d\u306e\u300c\u8a8d\u8a3c\u60c5\u5831\u300d\u304b\u3089API\u30ad\u30fc\u3092\u4f5c\u6210\u3057\u3001API\u306e\u5236\u9650\u3092Cloud Natural Language API\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002\u30ad\u30fc\u306e\u767a\u884c\u3060\u3051\u3067\u306fAPI\u306e\u6709\u52b9\u5316\u306f\u5b8c\u4e86\u3057\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\"GCP\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u4f5c\u6210\u5f8c\u306bAPI\u3068\u30b5\u30fc\u30d3\u30b9\u306e\u8a8d\u8a3c\u60c5\u5831\u304b\u3089API\u30ad\u30fc\u3092\u767a\u884c\u3059\u308b\u624b\u9806\u3002\"<\/figure>\n\n\n\n

\u30ad\u30fc\u306f\u30bb\u30eb\u3084\u516c\u958b\u30b3\u30fc\u30c9\u306b\u8cbc\u3089\u305a\u3001Apps Script\u306e\u300c\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8a2d\u5b9a\u300d\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u30d7\u30ed\u30d1\u30c6\u30a3\u3078\u3001\u540d\u524dNL_API_KEY\u3067\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\u30b9\u30af\u30ea\u30d7\u30c8\u30d7\u30ed\u30d1\u30c6\u30a3\u3082\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u7de8\u96c6\u8005\u304b\u3089\u79d8\u5bc6\u3092\u5b88\u308b\u4ed5\u7d44\u307f\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u30b7\u30fc\u30c8\u3068\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u7de8\u96c6\u6a29\u9650\u3092\u9650\u5b9a\u3057\u3001\u6f0f\u3048\u3044\u3057\u305f\u30ad\u30fc\u306f\u7121\u52b9\u5316\u3057\u3066\u518d\u767a\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u8a8d\u8a3c\u65b9\u6cd5\u306fGoogle\u306eAPI\u30ad\u30fc\u5229\u7528\u624b\u9806<\/a>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

\"\u767a\u884c\u3055\u308c\u305fAPI\u30ad\u30fc\u306e\u5024\u3092\u30b3\u30d4\u30fc\u3057\u3066\u63a7\u3048\u3066\u304a\u304f\u753b\u9762\u3002\"<\/figure>\n<\/div><\/div>\n\n\n\n
STEP<\/span><\/div>
\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3068GAS\u306e\u4f5c\u6210<\/div>
\n

\u30c6\u30b9\u30c8\u7528\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f5c\u308a\u3001\u300c\u62e1\u5f35\u6a5f\u80fd\u300d\u2192\u300cApps Script\u300d\u3092\u958b\u304d\u307e\u3059\u3002\u3053\u306e\u30b3\u30fc\u30c9\u306f\u3001\u305d\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u7d10\u3065\u304f\u30b9\u30af\u30ea\u30d7\u30c8\u7528\u3067\u3059\u3002<\/p>\n\n\n\n

\u300c\u5206\u6790\u300d\u30b7\u30fc\u30c8\u3092\u4f5c\u308a\u3001A1\u306b\u6587\u7ae0\u3001B1\u306bScore\u3001C1\u306bMagnitude\u3068\u5165\u529b\u3057\u307e\u3059\u3002A2:A11\u306b\u67b6\u7a7a\u306e\u65e5\u672c\u8a9e\u6587\u3092\u5165\u308c\u3001B2:C11\u306f\u51fa\u529b\u5c02\u7528\u3068\u3057\u3066\u7a7a\u3051\u307e\u3059\u3002\u5f8c\u8ff0\u306e\u30b3\u30fc\u30c9\u3092\u4fdd\u5b58\u3057\u3001\u65e2\u5b58\u306eonOpen\u304c\u3042\u308b\u5834\u5408\u306f\u30e1\u30cb\u30e5\u30fc\u8ffd\u52a0\u51e6\u7406\u3092\u7d71\u5408\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

API\u30ad\u30fc\u306fNL_API_KEY\u30d7\u30ed\u30d1\u30c6\u30a3\u304b\u3089\u8aad\u307f\u307e\u3059\u3002<\/p>\n\n\n\n

\u5bfe\u8c61\u306fA2:A11\u306e\u6700\u592710\u884c\u30011\u884c1,000\u6587\u5b57\u307e\u3067\u3068\u3044\u3046\u7df4\u7fd2\u7528\u306e\u4e0a\u9650\u3067\u3059\u3002<\/p>\n\n\n\n

\u300c8\u500b\u307e\u3067\u300d\u3068\u3044\u3046API\u4ed5\u69d8\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

B\u5217\u304bC\u5217\u306b\u5024\u307e\u305f\u306f\u6570\u5f0f\u304c\u3042\u308b\u884c\u306f\u518d\u9001\u305b\u305a\u3001\u6587\u7ae0\u304c\u7a7a\u306e\u884c\u3082\u9001\u4fe1\u3057\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\u7a7a\u6b04\u306b\u898b\u3048\u308b=\"\"<\/code>\u306a\u3069\u306e\u6570\u5f0f\u3082\u3001\u4e0a\u66f8\u304d\u3092\u907f\u3051\u308b\u305f\u3081\u5bfe\u8c61\u5916\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

function onOpen() {\n  SpreadsheetApp.getUi().createMenu('\u611f\u60c5\u5206\u6790').addItem('A2:A11\u3092\u5206\u6790', 'main').addToUi();\n}\n\nfunction main() {\n  const lock = LockService.getScriptLock();\n  if (!lock.tryLock(10000)) throw new Error('\u540c\u3058\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u51e6\u7406\u4e2d\u3067\u3059');\n  try {\n    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('\u5206\u6790');\n    if (!sheet) throw new Error('\u5206\u6790\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044');\n    const key = PropertiesService.getScriptProperties().getProperty('NL_API_KEY');\n    if (!key) throw new Error('\u30b9\u30af\u30ea\u30d7\u30c8\u30d7\u30ed\u30d1\u30c6\u30a3NL_API_KEY\u3092\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044');\n    const data = sheet.getRange('A2:C11').getValues();\n    const formulas = sheet.getRange('B2:C11').getFormulas();\n    const jobs = [];\n    for (let i = 0; i < data.length; i++) {\n      const [text, score, magnitude] = data[i];\n      if (text === '' || score !== '' || magnitude !== '' ||\n          formulas[i][0] !== '' || formulas[i][1] !== '') continue;\n      if (typeof text !== 'string' || !text.trim() || Array.from(text).length > 1000) {\n        throw new Error((i + 2) + '\u884c\u76ee\u306f1\u301c1000\u6587\u5b57\u306e\u6587\u7ae0\u306b\u3057\u3066\u304f\u3060\u3055\u3044');\n      }\n      jobs.push({row: i + 2, text});\n    }\n    for (const job of jobs) {\n      let response;\n      try {\n        response = UrlFetchApp.fetch('https:\/\/language.googleapis.com\/v1\/documents:analyzeSentiment', {\n          method: 'post', contentType: 'application\/json',\n          headers: {'x-goog-api-key': key},\n          payload: JSON.stringify({document: {type: 'PLAIN_TEXT', language: 'ja', content: job.text}, encodingType: 'UTF8'}),\n          muteHttpExceptions: true\n        });\n      } catch (e) {\n        throw new Error(job.row + '\u884c\u76ee\u306e\u901a\u4fe1\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002\u8ab2\u91d1\u30fb\u51fa\u529b\u3092\u78ba\u8a8d\u3057\u3066\u304b\u3089\u518d\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044');\n      }\n      if (response.getResponseCode() !== 200) {\n        throw new Error(job.row + '\u884c\u76ee: HTTP ' + response.getResponseCode() + '\u3002API\u8a2d\u5b9a\u30fb\u8ab2\u91d1\u30fb\u5272\u308a\u5f53\u3066\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044');\n      }\n      let result;\n      try { result = JSON.parse(response.getContentText()).documentSentiment; }\n      catch (e) { throw new Error(job.row + '\u884c\u76ee\u306e\u5fdc\u7b54\u3092\u89e3\u6790\u3067\u304d\u307e\u305b\u3093'); }\n      if (!result || !Number.isFinite(result.score) || result.score < -1 || result.score > 1 ||\n          !Number.isFinite(result.magnitude) || result.magnitude < 0) {\n        throw new Error(job.row + '\u884c\u76ee\u306e\u5206\u6790\u7d50\u679c\u304c\u4e0d\u6b63\u3067\u3059');\n      }\n      sheet.getRange(job.row, 2, 1, 2).setValues([[result.score, result.magnitude]]);\n    }\n  } finally {\n    try { SpreadsheetApp.flush(); }\n    finally { lock.releaseLock(); }\n  }\n}<\/code><\/pre><\/div>\n\n\n\n
\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u753b\u9762\u306b\u623b\u308a\u3001F5\u30ad\u30fc\u306a\u3069\u3067\u30d6\u30e9\u30a6\u30b6\u3092\u518d\u8aad\u307f\u8fbc\u307f\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30e1\u30cb\u30e5\u30fc\u30d0\u30fc\u306b\u72ec\u81ea\u306e\u30ab\u30b9\u30bf\u30e0\u30e1\u30cb\u30e5\u30fc\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n
\u6700\u521d\u306fA2\u3060\u3051\u306b\u6587\u7ae0\u3092\u5165\u308c\u3066\u5b9f\u884c\u3057\u307e\u3059\u3002\u30b7\u30fc\u30c8\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3068\u5916\u90e8\u901a\u4fe1\u306e\u627f\u8a8d\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n
\u5b9f\u884c\u4e2d\u306f\u300c\u5206\u6790\u300d\u30b7\u30fc\u30c8\u306e\u5165\u529b\u3068\u51fa\u529b\u3092\u7de8\u96c6\u3057\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n
\u3053\u306e\u30ed\u30c3\u30af\u306f\u540c\u3058\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u540c\u6642\u5b9f\u884c\u3092\u6291\u3048\u308b\u3082\u306e\u3067\u3001\u624b\u4f5c\u696d\u3084\u5225\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u7de8\u96c6\u306f\u9632\u3052\u307e\u305b\u3093\u3002<\/p>\n\n\n\n
\u300c\u611f\u60c5\u5206\u6790\u300d\u2192\u300cA2:A11\u3092\u5206\u6790\u300d\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u6210\u529f\u3057\u305f\u884c\u306eB\u30fbC\u5217\u306b\u7d50\u679c\u3092\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002HTTP\u30a8\u30e9\u30fc\u3084\u4e0d\u6b63\u306a\u5fdc\u7b54\u3067\u505c\u6b62\u3057\u3001\u6e08\u3093\u3060\u884c\u306f\u6b8b\u308a\u307e\u3059\u3002\u901a\u4fe1\u5931\u6557\u6642\u306b\u3082\u30b5\u30fc\u30d0\u30fc\u5074\u3067\u51e6\u7406\u3055\u308c\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u305f\u3081\u3001\u518d\u9001\u524d\u306b\u5229\u7528\u91cf\u3068\u51fa\u529b\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n
\"\u8ffd\u52a0\u3055\u308c\u305f\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3057\u3066\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u51fa\u529b\u3055\u308c\u305f\u611f\u60c5\u5206\u6790\u306e\u7d50\u679c\u3002\"<\/figure>\n\n\n\n
\n