{ "edges": [ { "to": "a433bab2-5943-49d2-a770-b75ecd7baa62", "from": "627fd6e3-2232-4f76-bafe-a4b01fbc0e51", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "a433bab2-5943-49d2-a770-b75ecd7baa62", "from": "b9f18554-7c19-4969-86de-0a81be8c53d2", "toPort": "0", "fromPort": "0" }, { "to": "9387f59f-2ce3-4d22-b8a8-7e48032f3ca2", "from": "9806596c-ad71-48dc-a7b4-e4ffbc992dbd", "toPort": "0", "fromPort": "0" }, { "to": "57ea0ffb-1a76-4f6c-8e60-0e7619c7f4a7", "from": "9387f59f-2ce3-4d22-b8a8-7e48032f3ca2", "toPort": "0", "fromPort": "0" }, { "to": "e8261ff4-b303-47fd-a0f6-997f27f7b037", "from": "9387f59f-2ce3-4d22-b8a8-7e48032f3ca2", "toPort": "0", "fromPort": "1" }, { "to": "885991be-8d6f-49f5-b742-c57e3da0aaa3", "from": "9387f59f-2ce3-4d22-b8a8-7e48032f3ca2", "toPort": "0", "fromPort": "2" }, { "to": "2a720602-ff73-44f5-9669-986e57be1d4d", "from": "218d3c40-8eb1-4dd8-b1b9-8dc01fa525b0", "toPort": "0", "fromPort": "0" }, { "to": "218d3c40-8eb1-4dd8-b1b9-8dc01fa525b0", "from": "a433bab2-5943-49d2-a770-b75ecd7baa62", "toPort": "0", "fromPort": "0" }, { "to": "5da81e46-54f5-434c-bd13-21e6c8d1c00a", "from": "e8261ff4-b303-47fd-a0f6-997f27f7b037", "toPort": "0", "fromPort": "0" }, { "to": "52bdb900-a6c1-4676-83fb-c34f63ea9434", "from": "2a720602-ff73-44f5-9669-986e57be1d4d", "toPort": "0", "fromPort": "0" }, { "to": "7d347763-8d31-48c4-aba7-f7ed6f332b6d", "from": "2a720602-ff73-44f5-9669-986e57be1d4d", "toPort": "0", "fromPort": "1" }, { "to": "b9f18554-7c19-4969-86de-0a81be8c53d2", "from": "57ea0ffb-1a76-4f6c-8e60-0e7619c7f4a7", "toPort": "0", "fromPort": "0" }, { "to": "de6afe46-3c00-459c-85e4-8cb613e5714b", "from": "52bdb900-a6c1-4676-83fb-c34f63ea9434", "toPort": "0", "fromPort": "0" }, { "to": "9806596c-ad71-48dc-a7b4-e4ffbc992dbd", "from": "ff5c621a-0deb-4067-864d-04bd59b6c2e5", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "ff5c621a-0deb-4067-864d-04bd59b6c2e5", "name": "When chat message received", "type": "trigger", "params": { "kind": "@n8n/n8n-nodes-langchain.chatTrigger", "options": {} }, "position": [ 6480, 4560 ] }, { "id": "9806596c-ad71-48dc-a7b4-e4ffbc992dbd", "name": "Detect Intent", "type": "code", "params": { "jsCode": "\nconst chatInput = ($input.first().json.chatInput || $input.first().json.input || '').trim();\nconsole.log('Input:', chatInput);\nconst isSummary = /\\b(summary|report|total|spending|how much|breakdown|stats)\\b/i.test(chatInput);\nconst isHelp = /^(\\?|help|\\/help)$/i.test(chatInput);\nreturn [{ json: {\n chat_input: chatInput,\n intent: isSummary ? 'summary' : isHelp ? 'help' : 'expense'\n}}];\n" }, "position": [ 6704, 4560 ] }, { "id": "9387f59f-2ce3-4d22-b8a8-7e48032f3ca2", "name": "Intent Switch", "type": "switch", "params": { "rules": { "values": [ { "conditions": { "options": { "leftValue": "", "caseSensitive": false, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "i1", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $json.intent }}", "rightValue": "expense" } ] } }, { "conditions": { "options": { "leftValue": "", "caseSensitive": false, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "i2", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $json.intent }}", "rightValue": "summary" } ] } }, { "conditions": { "options": { "leftValue": "", "caseSensitive": false, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "i3", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $json.intent }}", "rightValue": "help" } ] } } ] }, "options": {} }, "position": [ 6928, 4544 ] }, { "id": "57ea0ffb-1a76-4f6c-8e60-0e7619c7f4a7", "name": "Read All Expenses", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg/edit?usp=drivesdk", "cachedResultName": "Expense track" } }, "position": [ 7152, 4368 ] }, { "id": "b9f18554-7c19-4969-86de-0a81be8c53d2", "name": "Prepare Data", "type": "code", "params": { "jsCode": "\n// This node ALWAYS outputs data regardless of how many rows the sheet has\n// Fixes: \"No item to return\" when sheet is empty\n\nconst allRows = $input.all();\nconst chatInput = $('Detect Intent').first().json.chat_input;\n\n// Calculate current month total from existing rows (0 if empty)\nconst now = new Date();\nconst currentMonth = now.toLocaleString('en-US', {month:'long'}) + ' ' + now.getFullYear();\n\nconst monthTotal = allRows\n .filter(r => (r.json['Month'] || '') === currentMonth)\n .reduce((sum, r) => sum + parseFloat(r.json['Amount'] || 0), 0);\n\nconsole.log('Rows in sheet:', allRows.length, '| Month total so far:', monthTotal);\n\n// Always return exactly 1 item so flow never stops\nreturn [{ json: {\n chat_input: chatInput,\n month_total: monthTotal,\n current_month: currentMonth,\n row_count: allRows.length\n}}];\n" }, "position": [ 7376, 4368 ] }, { "id": "a433bab2-5943-49d2-a770-b75ecd7baa62", "name": "AI Parse Expense", "type": "llm", "params": { "text": "=You are an expense parser. Extract expense details from this message and return ONLY a JSON object, nothing else.\n\nMessage: \"{{ $('Detect Intent').first().json.chat_input }}\"\nToday: {{ new Date().toISOString().split('T')[0] }}\n\nReturn ONLY this JSON:\n{\"amount\": , \"description\": \"<2-4 words>\", \"category\": \"\", \"currency\": \"\", \"date\": \"\", \"is_expense\": }\n\nRules:\n- If the message is clearly an expense with an amount → is_expense: true\n- If no amount can be found → is_expense: false\n- currency default: INR\n- date default: today\n\nExamples:\n\"spent 500 on car wash\" → {\"amount\":500,\"description\":\"Car wash\",\"category\":\"Transport\",\"currency\":\"INR\",\"date\":\"{{ new Date().toISOString().split('T')[0] }}\",\"is_expense\":true}\n\"test 500\" → {\"amount\":500,\"description\":\"Test\",\"category\":\"Other\",\"currency\":\"INR\",\"date\":\"{{ new Date().toISOString().split('T')[0] }}\",\"is_expense\":true}\n\"lunch 450\" → {\"amount\":450,\"description\":\"Lunch\",\"category\":\"Food & Dining\",\"currency\":\"INR\",\"date\":\"{{ new Date().toISOString().split('T')[0] }}\",\"is_expense\":true}\n\"hello\" → {\"amount\":0,\"description\":\"\",\"category\":\"Other\",\"currency\":\"INR\",\"date\":\"{{ new Date().toISOString().split('T')[0] }}\",\"is_expense\":false}\n\nJSON only. No explanation.", "prompt": "=You are an expense parser. Extract expense details from this message and return ONLY a JSON object, nothing else.\n\nMessage: \"{{ $('Detect Intent').first().json.chat_input }}\"\nToday: {{ new Date().toISOString().split('T')[0] }}\n\nReturn ONLY this JSON:\n{\"amount\": , \"description\": \"<2-4 words>\", \"category\": \"\", \"currency\": \"\", \"date\": \"\", \"is_expense\": }\n\nRules:\n- If the message is clearly an expense with an amount → is_expense: true\n- If no amount can be found → is_expense: false\n- currency default: INR\n- date default: today\n\nExamples:\n\"spent 500 on car wash\" → {\"amount\":500,\"description\":\"Car wash\",\"category\":\"Transport\",\"currency\":\"INR\",\"date\":\"{{ new Date().toISOString().split('T')[0] }}\",\"is_expense\":true}\n\"test 500\" → {\"amount\":500,\"description\":\"Test\",\"category\":\"Other\",\"currency\":\"INR\",\"date\":\"{{ new Date().toISOString().split('T')[0] }}\",\"is_expense\":true}\n\"lunch 450\" → {\"amount\":450,\"description\":\"Lunch\",\"category\":\"Food & Dining\",\"currency\":\"INR\",\"date\":\"{{ new Date().toISOString().split('T')[0] }}\",\"is_expense\":true}\n\"hello\" → {\"amount\":0,\"description\":\"\",\"category\":\"Other\",\"currency\":\"INR\",\"date\":\"{{ new Date().toISOString().split('T')[0] }}\",\"is_expense\":false}\n\nJSON only. No explanation.", "provider": "openai", "promptType": "define", "approximated": true }, "position": [ 7600, 4368 ] }, { "id": "627fd6e3-2232-4f76-bafe-a4b01fbc0e51", "name": "Claude Haiku", "type": "llm", "params": { "model": "claude-haiku-4-5-20251001", "options": {}, "provider": "anthropic" }, "position": [ 7744, 4544 ] }, { "id": "218d3c40-8eb1-4dd8-b1b9-8dc01fa525b0", "name": "Parse & Total", "type": "code", "params": { "jsCode": "const rawText = ($json.text || $json.output || '').trim();\nconst prepared = $('Prepare Data').first().json;\nconst chatInput = prepared.chat_input;\nconsole.log('AI response:', rawText);\n\nlet parsed = null;\ntry { parsed = JSON.parse(rawText); } catch(e) {}\nif (!parsed) {\n try { const m = rawText.match(/\\{[\\s\\S]*\\}/); if(m) parsed = JSON.parse(m[0]); } catch(e) {}\n}\n\nif (!parsed || !parsed.is_expense || !parsed.amount || parseFloat(parsed.amount) <= 0) {\n return [{ json: {\n valid: false,\n reply: `I couldn't identify an expense amount in that message.\\n\\nPlease include an amount, like:\\n• \"spent 500 on lunch\"\\n• \"uber 150\"\\n• \"1200 electricity bill\"`\n }}];\n}\n\nconst emo = {'Food & Dining':'🍕','Transport':'🚗','Shopping':'🛍️','Bills & Utilities':'💡','Entertainment':'🎬','Health':'🏥','Business':'💼','Education':'📚','Other':'💰'};\nconst cat = parsed.category || 'Other';\nconst amount = parseFloat(parsed.amount);\nconst currency = parsed.currency || 'INR';\nconst symbol = currency === 'INR' ? '₹' : currency + ' ';\nconst dateStr = parsed.date || new Date().toISOString().split('T')[0];\n\n// Derive month from parsed date (not today)\nconst parsedDate = new Date(dateStr);\nconst entryMonth = parsedDate.toLocaleString('en-US', {month:'long'}) + ' ' + parsedDate.getFullYear();\n\n// Running total for that specific month\nconst allRows = $('Read All Expenses').all();\nconst entryMonthTotal = allRows\n .filter(r => (r.json['Month'] || '') === entryMonth)\n .reduce((sum, r) => sum + parseFloat(r.json['Amount'] || 0), 0);\nconst newTotal = entryMonthTotal + amount;\n\nconsole.log(`Saving: ${symbol}${amount} | ${cat} | ${parsed.description} | Month: ${entryMonth} | Total: ${newTotal}`);\n\nreturn [{ json: {\n valid: true,\n Date: dateStr,\n Amount: amount,\n Category: cat,\n Description: parsed.description || chatInput,\n Currency: currency,\n Month: entryMonth,\n \"Raw Message\": chatInput,\n Total: newTotal,\n _display: `${emo[cat]||'💰'} *${cat}* — ${parsed.description || chatInput}\\n💳 ${symbol}${amount}\\n📅 ${dateStr}\\n📊 ${entryMonth} total: ${symbol}${newTotal.toFixed(0)}`\n}}];" }, "position": [ 7952, 4368 ] }, { "id": "2a720602-ff73-44f5-9669-986e57be1d4d", "name": "Is Valid Expense?", "type": "if", "params": { "options": {}, "conditions": { "options": { "leftValue": "", "caseSensitive": false, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "v1", "operator": { "type": "boolean", "operation": "equals", "rightType": "boolean" }, "leftValue": "={{ $json.valid }}", "rightValue": true } ] } }, "position": [ 8176, 4368 ] }, { "id": "52bdb900-a6c1-4676-83fb-c34f63ea9434", "name": "Save Expense to Sheet", "type": "integration", "params": { "columns": { "value": { "Date": "={{ $json.Date }}", "Month": "={{ $json.Month }}", "Total": "={{ $json.Total }}", "Amount": "={{ $json.Amount }}", "Category": "={{ $json.Category }}", "Currency": "={{ $json.Currency }}", "Description": "={{ $json.Description }}", "Raw Message": "={{ $json['Raw Message'] }}" }, "schema": [ { "id": "Date", "type": "string", "display": true, "required": false, "displayName": "Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Amount", "type": "string", "display": true, "required": false, "displayName": "Amount", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Category", "type": "string", "display": true, "required": false, "displayName": "Category", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Description", "type": "string", "display": true, "required": false, "displayName": "Description", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Currency", "type": "string", "display": true, "required": false, "displayName": "Currency", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Month", "type": "string", "display": true, "required": false, "displayName": "Month", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Raw Message", "type": "string", "display": true, "required": false, "displayName": "Raw Message", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Total", "type": "string", "display": true, "required": false, "displayName": "Total", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg/edit?usp=drivesdk", "cachedResultName": "Expense track" } }, "position": [ 8400, 4272 ] }, { "id": "de6afe46-3c00-459c-85e4-8cb613e5714b", "name": "Reply Saved", "type": "code", "params": { "jsCode": "\nconst d = $('Parse & Total').first().json;\nreturn [{ json: { output: `✅ Expense saved!\\n\\n${d._display}` }}];\n" }, "position": [ 8624, 4272 ] }, { "id": "7d347763-8d31-48c4-aba7-f7ed6f332b6d", "name": "Reply Invalid", "type": "code", "params": { "jsCode": "\nconst d = $('Parse & Total').first().json;\nreturn [{ json: { output: d.reply || \"Please include an amount in your message.\" }}];\n" }, "position": [ 8400, 4464 ] }, { "id": "e8261ff4-b303-47fd-a0f6-997f27f7b037", "name": "Read for Summary", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1n7izUA8ACWfN-XqwOQkEkZ6lspUXsY1PMlmko67tLSg/edit?usp=drivesdk", "cachedResultName": "Expense track" } }, "position": [ 7264, 4736 ] }, { "id": "5da81e46-54f5-434c-bd13-21e6c8d1c00a", "name": "Build Summary", "type": "code", "params": { "jsCode": "const rows = $input.all();\nconst now = new Date();\nconst chatInput = $('Detect Intent').first().json.chat_input;\n\n// Detect if user asked for specific month\nconst monthNames = ['january','february','march','april','may','june','july','august','september','october','november','december'];\nlet targetMonth = null;\n\nconst lower = chatInput.toLowerCase();\nfor (const m of monthNames) {\n if (lower.includes(m)) {\n const yearMatch = lower.match(/20(\\d{2})/);\n const shortYearMatch = lower.match(/\\b(\\d{2})\\b/);\n let year = now.getFullYear();\n if (yearMatch) year = parseInt(yearMatch[0]);\n else if (shortYearMatch) year = 2000 + parseInt(shortYearMatch[1]);\n targetMonth = m.charAt(0).toUpperCase() + m.slice(1) + ' ' + year;\n break;\n }\n}\n\nif (!targetMonth) {\n targetMonth = now.toLocaleString('en-US', {month:'long'}) + ' ' + now.getFullYear();\n}\n\nconsole.log('Summary for month:', targetMonth);\n\nconst thisMonth = rows.filter(r => (r.json['Month'] || '') === targetMonth);\n\nif (rows.length === 0 || thisMonth.length === 0) {\n return [{ json: { output: `📊 No expenses found for *${targetMonth}*.\\n\\nTry: SUMMARY or \"summary march\"` }}];\n}\n\nconst total = thisMonth.reduce((s,r) => s + parseFloat(r.json['Amount']||0), 0);\nconst byCategory = {};\nfor (const r of thisMonth) {\n const cat = r.json['Category'] || 'Other';\n byCategory[cat] = (byCategory[cat]||0) + parseFloat(r.json['Amount']||0);\n}\nconst sorted = Object.entries(byCategory).sort((a,b) => b[1]-a[1]);\nconst emo = {'Food & Dining':'🍕','Transport':'🚗','Shopping':'🛍️','Bills & Utilities':'💡','Entertainment':'🎬','Health':'🏥','Business':'💼','Education':'📚','Other':'💰'};\nconst lines = sorted.map(([c,a]) => `${emo[c]||'💰'} ${c}: ₹${a.toFixed(0)} (${((a/total)*100).toFixed(0)}%)`).join('\\n');\n\nreturn [{ json: { output:\n `📊 *${targetMonth} Report*\\n\\n` +\n `💳 *Total: ₹${total.toFixed(0)}*\\n` +\n `📝 Entries: ${thisMonth.length}\\n` +\n `📈 Daily avg: ₹${(total/now.getDate()).toFixed(0)}\\n` +\n `🔝 Top: ${emo[sorted[0]?.[0]]||'💰'} ${sorted[0]?.[0]}\\n\\n` +\n `*Breakdown:*\\n${lines}`\n}}];" }, "position": [ 7472, 4736 ] }, { "id": "885991be-8d6f-49f5-b742-c57e3da0aaa3", "name": "Send Help", "type": "code", "params": { "jsCode": "\nreturn [{ json: { output:\n`💰 *Expense Tracker — Commands*\n\n📝 *Add expense (just type naturally):*\n• \"spent 500 on lunch\"\n• \"paid 1200 electricity bill\"\n• \"uber 150\"\n• \"test 500\"\n• \"₹450 groceries\"\n• \"netflix 499\"\n\n📊 *Monthly report:*\nType: SUMMARY\n\n💱 *Currencies:* ₹INR $USD €EUR £GBP\n\n📂 *Auto-detected categories:*\n🍕 Food & Dining 🚗 Transport\n🛍️ Shopping 💡 Bills & Utilities\n🎬 Entertainment 🏥 Health\n💼 Business 📚 Education 💰 Other`\n}}];\n" }, "position": [ 7152, 4976 ] } ] }

Track expenses via chat with Claude Haiku and Google Sheets