8. Đồ Án Tốt Nghiệp: Triển Khai Hệ Thống Tự Động Hóa Vận Hành Toàn Diện Trên Google Cloud & Gemini 2.5

// CODE ĐỒ ÁN MẪU HOÀN CHỈNH TRONG GOOGLE APPS SCRIPT
function fullEnterpriseAutomationPipeline() {
  const FOLDER_ID = "YOUR_DRIVE_FOLDER_ID";
  const folder = DriveApp.getFolderById(FOLDER_ID);
  const files = folder.getFiles();
  const apiKey = "YOUR_GEMINI_API_KEY";
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("BaoCao");
  
  while (files.hasNext()) {
    const file = files.next();
    if (file.getMimeType() === "application/pdf") {
      const base64 = Utilities.base64Encode(file.getBlob().getBytes());
      
      const payload = {
        contents: [{
          parts: [
            { inlineData: { mimeType: "application/pdf", data: base64 } },
            { text: "Trích xuất JSON {\"tax_id\": \"...\", \"vendor\": \"...\", \"total_amount\": 0, \"items\": [\"item1\", \"item2\"], \"risk_warning\": \"Có/Không\"}" }
          ]
        }],
        generationConfig: { responseMimeType: "application/json" }
      };
      
      const res = UrlFetchApp.fetch("https://generativelanguage.googleapis.com/v1beta/models/gemini-2.5-flash:generateContent?key=" + apiKey, {
        method: "post",
        contentType: "application/json",
        payload: JSON.stringify(payload)
      });
      
      const data = JSON.parse(JSON.parse(res.getContentText()).candidates[0].content.parts[0].text);
      sheet.appendRow([new Date(), file.getName(), data.tax_id, data.vendor, data.total_amount, data.items.join(", "), data.risk_warning]);
    }
  }
}