// 최초 1회 실행: API 키를 저장
function setupApiKey() {
PropertiesService.getScriptProperties().setProperty(
...

function callGemini(prompt, model = 'gemini-2.5-flash') {
const apiKey = getApiKey();
const url = `https://generativelanguage.googleapis.com/v1beta/models/${model}:generateContent?key=${apiKey}`;
...

function classifyIncomingEmails() {
const threads = GmailApp.search('label:inbox is:unread', 0, 20);
threads.forEach(thread => {
...

function setupGmailTrigger() {
// 기존 트리거 삭제
ScriptApp.getProjectTriggers().forEach(trigger => {
...

function summarizeSheetData() {
const sheet = SpreadsheetApp.getActiveSheet();
const data = sheet.getDataRange().getValues();
...

function onOpen() {
SpreadsheetApp.getUi()
.createMenu('AI 활용')
...

function summarizeMeetingDoc() {
const docId = DocumentApp.getActiveDocument().getId();
const docBody = DocumentApp.openById(docId).getBody().getText();
...

function postSummaryToSlack(summaryText) {
const webhookUrl = PropertiesService.getScriptProperties()
.getProperty('SLACK_WEBHOOK_URL');
...

function maskSensitiveData(text) {
return text
.replace(/[A-Z]{2}\d{6}/g, '[ID-MASKED]') // 사원 ID 패턴
...

// Vertex AI를 통한 호출 예시
function callVertexAI(prompt) {
const projectId = 'your-gcp-project';
...

function callGeminiWithRetry(prompt, maxRetries = 3) {
let lastError;
for (let i = 0; i < maxRetries; i++) {
...

function callGeminiWithTokenCount(prompt) {
const apiKey = getApiKey();
const url = `https://generativelanguage.googleapis.com/v1beta/models/gemini-2.5-flash:generateContent?key=${apiKey}`;
...

function calculateMonthlyCost() {
// 로그 시트에서 토큰 사용량을 집계
const sheet = SpreadsheetApp.openById('YOUR_LOG_SHEET_ID').getActiveSheet();
...

function processBatch() {
const batchSize = 50;
const currentIndex = parseInt(
...

function safePrompt(userInput) {
return `
다음 사용자 입력을 요약해 주세요.
...

function parseJSONResponse(response) {
try {
// 마크다운 코드 블록 제거
let cleaned = response.replace(/```json\s*/g, '').replace(/```\s*/g, '');
return JSON.parse(cleaned);
} catch (error) {
console.error('JSON parse failed:', response);
...

function callGeminiWithSchema(prompt, schema) {
const apiKey = getApiKey();
const url = `https://generativelanguage.googleapis.com/v1beta/models/gemini-2.5-flash:generateContent?key=${apiKey}`;
...