AI Assistant

if (mode === 'add') {
    // Fetch last 40 transactions for context
    const historyData = sheet.getRange(
        Math.max(1, sheet.getLastRow() - 40), 
        1, 41, 4
    ).getValues();
    const historyContext = historyData
        .map(r => `${r[1]} (${r[2]}) [${r[3]}]`)
        .join("\n");

    prompt = `
You are a financial assistant. 
CONTEXT: The user wants to ADD a transaction.
USER INPUT: "${userText}"
HISTORY: 
${historyContext}

TASK:
1. Extract: Description, Amount, Category (Food, Transport, Tech, Invest, Income, Misc).
2. Analyze: Compare this new expense to the HISTORY. Is it higher than usual? Is it a repeat?
3. Insight: Write a very short, witty, or helpful insight (max 15 words) about this specific spend.

OUTPUT JSON STRICTLY:
{
  "description": "String",
  "amount": Number,
  "category": "String",
  "type": "DEBIT" or "CREDIT",
  "insight": "String"
}
`;
}

if (mode === 'ask') {
    prompt = `
You are a financial analyst.
CONTEXT: The user is ASKING a question about their finances.
USER INPUT: "${userText}"
HISTORY: 
${historyContext}

TASK: 
Answer the user's question based strictly on the HISTORY data provided. 
Be concise (max 30 words).

OUTPUT JSON STRICTLY:
{
  "answer": "String"
}
`;
}

if (mode === 'ask') {
    card.className = "card p-4 bg-purple-50 border-purple-200 min-h-[80px]";
    tip.innerText = "Analyzing history...";
    tip.className = "text-[11px] font-bold text-purple-800 italic leading-relaxed flex-1";
}

// After AI response
if (data.status === "Success") {
    icon.innerText = "🧠";
    tip.innerText = data.ai_response;
}

const SpeechRecognition = window.SpeechRecognition || window.webkitSpeechRecognition;
let recognition = null;

if (SpeechRecognition) {
    recognition = new SpeechRecognition();
    recognition.continuous = false;
    recognition.lang = 'en-IN';  // Indian English
    recognition.interimResults = false;
    
    recognition.onstart = () => { 
        document.getElementById('micBtn').classList.add('mic-active'); 
    };
    
    recognition.onend = () => { 
        document.getElementById('micBtn').classList.remove('mic-active'); 
    };
    
    recognition.onresult = (event) => {
        const transcript = event.results[0][0].transcript;
        const current = document.getElementById('omniInput').value;
        document.getElementById('omniInput').value = current 
            ? current + " " + transcript 
            : transcript;
    };
}

function toggleVoice() {
    if (recognition) recognition.start();
    else alert("Voice recognition not supported on this browser.");
}

.mic-active {
    animation: pulse-red 1.5s infinite;
    color: #ef4444 !important;
}

@keyframes pulse-red {
    0% {
        box-shadow: 0 0 0 0 rgba(239, 68, 68, 0.7);
    }
    70% {
        box-shadow: 0 0 0 10px rgba(239, 68, 68, 0);
    }
    100% {
        box-shadow: 0 0 0 0 rgba(239, 68, 68, 0);
    }
}

const SCRIPT_PROP = PropertiesService.getScriptProperties();

// Saving API key
if (body.action === "save_settings") {
    SCRIPT_PROP.setProperty("DAILY_BUDGET", body.budget.toString());
    SCRIPT_PROP.setProperty("PRIVACY_MODE", body.privacy.toString());
    if (body.geminiKey) SCRIPT_PROP.setProperty("GEMINI_KEY", body.geminiKey);
    return ContentService.createTextOutput(
        JSON.stringify({ status: "Saved" })
    ).setMimeType(ContentService.MimeType.JSON);
}

// Retrieving for AI calls
const geminiKey = SCRIPT_PROP.getProperty("GEMINI_KEY");

const geminiKey = SCRIPT_PROP.getProperty("GEMINI_KEY");
const aiUrl = `https://generativelanguage.googleapis.com/v1beta/models/gemini-flash-latest:generateContent?key=${geminiKey}`;

const aiPayload = { 
    contents: [{ 
        parts: [{ text: prompt }] 
    }] 
};

try {
    const aiRes = UrlFetchApp.fetch(aiUrl, { 
        method: 'post', 
        contentType: 'application/json', 
        payload: JSON.stringify(aiPayload) 
    });
    
    const aiJson = JSON.parse(aiRes.getContentText());
    const rawText = aiJson.candidates[0].content.parts[0].text;
    
    // Clean markdown code blocks from response
    const cleanJson = rawText
        .replace(/```json/g, '')
        .replace(/```/g, '')
        .trim();
    
    const parsed = JSON.parse(cleanJson);
    // Process parsed data...
} catch (e) {
    return ContentService.createTextOutput(
        JSON.stringify({ 
            status: "Error", 
            message: "AI Failed: " + e.message 
        })
    ).setMimeType(ContentService.MimeType.JSON);
}

if (data.status === "Success") {
    icon.innerText = mode === 'add' ? "✅" : "🧠";
    tip.innerText = data.ai_response;
    
    if (mode === 'add') {
        appData.balance = parseFloat(data.balance);
        if (data.parsed) appData.expenses.push(data.parsed);
        renderUI();
    }
}

try {
    const res = await fetch(SCRIPT_URL, {
        method: 'POST',
        body: JSON.stringify({ action: "process_text", text: txt, mode: mode })
    });
    const data = await res.json();
    
    if (data.status === "Success") {
        // Handle success...
    } else {
        throw new Error("API Limit or Error");
    }
} catch (e) {
    if (mode === 'add') {
        handleManualFallback(txt);  // Regex-based parsing
    } else {
        icon.innerText = "⚠️";
        tip.innerText = "AI Offline. Can't analyze right now.";
    }
}

icon.innerHTML = '<div class="loader"></div>';

if (mode === 'add') {
    card.className = "card p-4 bg-blue-50 border-blue-200 min-h-[80px]";
    tip.innerText = "Processing...";
    tip.className = "text-[11px] font-bold text-blue-800 italic leading-relaxed flex-1";
} else {
    card.className = "card p-4 bg-purple-50 border-purple-200 min-h-[80px]";
    tip.innerText = "Analyzing history...";
    tip.className = "text-[11px] font-bold text-purple-800 italic leading-relaxed flex-1";
}

const historyData = sheet.getRange(
    Math.max(1, sheet.getLastRow() - 40), 
    1, 41, 4
).getValues();

const historyContext = historyData
    .map(r => `${r[1]} (${r[2]}) [${r[3]}]`)
    .join("\n");

// Example output:
// Coffee (200) [Food]
// Uber (150) [Transport]
// Netflix (199) [Tech]

<div class="pt-4 border-t border-slate-100">
    <label class="block text-xs font-bold text-slate-400 uppercase mb-2">Gemini API Key</label>
    <input type="password" id="geminiKeyInput" placeholder="Enter new key"
        class="w-full p-3 bg-slate-50 rounded-lg text-xs font-mono outline-none mb-2">
    <button onclick="pushSettings(true)"
        class="w-full p-3 bg-slate-900 text-white rounded-lg font-bold text-xs">
        Save Key to Cloud
    </button>
</div>