OCR技術とGASで名刺データ化をスムーズに！スプレッドシート入力の手間を削減

function processBusinessCards() {
  const folderId = "名刺フォルダのIDをここに入れる";
  const folder = DriveApp.getFolderById(folderId);
  const processedFolder = folder.getFoldersByName("登録済み").next();
  const files = folder.getFiles();
  const visionApiKey = PropertiesService.getScriptProperties().getProperty("VISION_API_KEY");
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("シート名をここに入れる");

  Logger.log("Starting to process files in folder: " + folderId);

  while (files.hasNext()) {
    const file = files.next();
    const imageBlob = file.getBlob();
    Logger.log("Processing file: " + file.getName());

    // Google Vision APIを呼び出してOCR処理
    const ocrText = callGoogleVisionApi(visionApiKey, imageBlob);

    // OCR結果をスプレッドシートに転記
    if (ocrText) {
      Logger.log("OCR Text: " + ocrText);
      appendToSheet(sheet, ocrText);

      // 処理後に画像を"登録済み"フォルダに移動
      processedFolder.addFile(file);
      folder.removeFile(file);
      Logger.log("File moved to processed folder: " + file.getName());
    } else {
      Logger.log("No text detected for file: " + file.getName());
    }
  }

  Logger.log("Processing completed for all files in folder: " + folderId);
}

function callGoogleVisionApi(apiKey, imageBlob) {
  const url = `https://vision.googleapis.com/v1/images:annotate?key=${apiKey}`;
  const requestBody = {
    "requests": [
      {
        "image": {
          "content": Utilities.base64Encode(imageBlob.getBytes())
        },
        "features": [
          {
            "type": "TEXT_DETECTION"
          }
        ]
      }
    ]
  };

  const options = {
    "method": "post",
    "contentType": "application/json",
    "payload": JSON.stringify(requestBody)
  };

  try {
    const response = UrlFetchApp.fetch(url, options);
    const json = JSON.parse(response.getContentText());
    Logger.log("Vision API response: " + response.getContentText());
    const textAnnotations = json.responses[0].textAnnotations;
    if (textAnnotations && textAnnotations.length > 0) {
      return textAnnotations[0].description;
    }
  } catch (e) {
    Logger.log("Error during Vision API call: " + e.message);
  }
  return null;
}

function appendToSheet(sheet, ocrText) {
  const rows = ocrText.split('\n');
  const newRow = Array(12).fill(""); // 12列分の空の配列を作成

  // OCR結果全体をシートに追加（デバッグ用）
  sheet.appendRow([ocrText]);

  // スプレッドシートの項目に対応するデータを抽出
  rows.forEach(row => {
    if (row.includes("氏名")) {
      newRow[0] = row.split(":")[1]?.trim() || "";
    } else if (row.includes("会社名")) {
      newRow[1] = row.split(":")[1]?.trim() || "";
    }
    // 他の項目も必要に応じて追加
  });

  // 新しい行をスプレッドシートに追加（空でない場合のみ）
  if (newRow.some(cell => cell !== "")) {
    sheet.appendRow(newRow);
  }
}