{ "edges": [ { "to": "ai-agent", "from": "think", "toPort": "0", "fromPort": "ai_tool" }, { "to": "ai-agent", "from": "calculator", "toPort": "0", "fromPort": "ai_tool" }, { "to": "ai-agent", "from": "add-income", "toPort": "0", "fromPort": "ai_tool" }, { "to": "ai-agent", "from": "get-income", "toPort": "0", "fromPort": "ai_tool" }, { "to": "ai-agent", "from": "add-expense", "toPort": "0", "fromPort": "ai_tool" }, { "to": "ai-agent", "from": "get-expense", "toPort": "0", "fromPort": "ai_tool" }, { "to": "ai-agent", "from": "memory", "toPort": "0", "fromPort": "ai_memory" }, { "to": "ai-agent", "from": "delete-expense", "toPort": "0", "fromPort": "ai_tool" }, { "to": "typing", "from": "telegram-trigger", "toPort": "0", "fromPort": "0" }, { "to": "ai-agent", "from": "telegram-trigger", "toPort": "0", "fromPort": "0" }, { "to": "ai-agent", "from": "gemini-model", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "markdown-formatter", "from": "ai-agent", "toPort": "0", "fromPort": "0" }, { "to": "send-error", "from": "ai-agent", "toPort": "0", "fromPort": "1" }, { "to": "send-message", "from": "markdown-formatter", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "telegram-trigger", "name": "Telegram Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.telegramTrigger", "updates": [ "message" ], "additionalFields": {} }, "position": [ 16, 1280 ] }, { "id": "typing", "name": "Typing...", "type": "integration", "params": { "chatId": "={{ $json.message.chat.id }}", "service": "telegram", "operation": "sendChatAction" }, "position": [ 272, 1152 ] }, { "id": "ai-agent", "name": "AI Agent - Expense Tracker", "type": "llm", "params": { "text": "={{ $json.message.text }}", "prompt": "={{ $json.message.text }}", "options": { "systemMessage": "=You are an AI Expense Tracker assistant.\n\n## TOOLS\n\n| Tool | Function | When to Use |\n|------|----------|-------------|\n| add_expense | Record 1 expense to monthly sheet | Each expense item |\n| get_expense | View all expense data | Analysis, viewing |\n| delete_expense | Delete last N rows | User requests delete |\n| add_income | Record 1 income | Each income item |\n| get_income | View all income data | Analysis |\n| Calculator | Math operations | Totals, averages |\n| Think | Deep reasoning | Complex operations |\n\n## CORE RULES\n\n1. ALWAYS call tool first, THEN confirm to user.\n2. Multiple items = multiple sequential tool calls.\n3. Use Calculator for: sums, totals, averages.\n4. Use Think before: 3+ step operations or deletes.\n5. If tool fails, be honest with user.\n\n## DATA FORMAT\n\nExpense Sheet (dynamic monthly name like \"February 2026\"):\nDate (yyyy-mm-dd) | Category | Description | Amount | Payment Method\n\nIncome Log (static sheet \"Income Log\"):\nDate (yyyy-mm-dd) | Category | Description | Amount | Account\n\n### Expense Categories:\nFood | Transport | Shopping | Entertainment | Bills | Others\n\n### Income Categories:\nSalary | Freelance | Investment | Bonus | Transfer | Others\n\n### Payment Methods:\ngopay/ovo/dana → E-wallet | debit → Debit | cc → Credit Card | transfer → Transfer | cash → Cash\n\n### Amount Parsing:\n25rb/25k = 25000 | 1.5jt = 1500000\n\n## WORKFLOWS\n\nRecord Expense:\n1. Parse input (amount, category, desc, payment, date)\n2. Call add_expense → wait for result\n3. If success → Calculator(total today) → respond\n4. Multiple items: repeat per item\n\nRecord Income:\n1. Parse input\n2. Call add_income → wait\n3. Respond with confirmation\n\nView Data:\n1. Call get_expense/get_income\n2. Filter by period\n3. Calculator → sums\n4. Format response\n\nDelete:\n⚠️ Can ONLY delete last N rows!\n1. Think → analyze request\n2. Call get_expense → check data\n3. If entry is last row → confirm → delete\n4. If not last row → explain limitation\n\n## RESPONSES\n\nExpense recorded:\n✅ [Description] - $[amount]\n📂 [Category] | 💳 [Payment]\nToday's total: $[total]\n\nIncome recorded:\n💰 [Description] - $[amount] → [Account]\n\nView data:\n📊 [Period] expenses:\n[Category]: $[total]\n • [item] - $[amount]\n━━━\n💰 Total: $[grand total]\n\n## COMMANDS\n/help → all commands | /today → today's expenses | /week → this week\n/month → monthly summary | /delete → delete entry | /stats → statistics\n\nCurrent time: {{ $now.format('cccc DD HH:mm') }}\nDate format: yyyy-mm-dd" }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "=You are an AI Expense Tracker assistant.\n\n## TOOLS\n\n| Tool | Function | When to Use |\n|------|----------|-------------|\n| add_expense | Record 1 expense to monthly sheet | Each expense item |\n| get_expense | View all expense data | Analysis, viewing |\n| delete_expense | Delete last N rows | User requests delete |\n| add_income | Record 1 income | Each income item |\n| get_income | View all income data | Analysis |\n| Calculator | Math operations | Totals, averages |\n| Think | Deep reasoning | Complex operations |\n\n## CORE RULES\n\n1. ALWAYS call tool first, THEN confirm to user.\n2. Multiple items = multiple sequential tool calls.\n3. Use Calculator for: sums, totals, averages.\n4. Use Think before: 3+ step operations or deletes.\n5. If tool fails, be honest with user.\n\n## DATA FORMAT\n\nExpense Sheet (dynamic monthly name like \"February 2026\"):\nDate (yyyy-mm-dd) | Category | Description | Amount | Payment Method\n\nIncome Log (static sheet \"Income Log\"):\nDate (yyyy-mm-dd) | Category | Description | Amount | Account\n\n### Expense Categories:\nFood | Transport | Shopping | Entertainment | Bills | Others\n\n### Income Categories:\nSalary | Freelance | Investment | Bonus | Transfer | Others\n\n### Payment Methods:\ngopay/ovo/dana → E-wallet | debit → Debit | cc → Credit Card | transfer → Transfer | cash → Cash\n\n### Amount Parsing:\n25rb/25k = 25000 | 1.5jt = 1500000\n\n## WORKFLOWS\n\nRecord Expense:\n1. Parse input (amount, category, desc, payment, date)\n2. Call add_expense → wait for result\n3. If success → Calculator(total today) → respond\n4. Multiple items: repeat per item\n\nRecord Income:\n1. Parse input\n2. Call add_income → wait\n3. Respond with confirmation\n\nView Data:\n1. Call get_expense/get_income\n2. Filter by period\n3. Calculator → sums\n4. Format response\n\nDelete:\n⚠️ Can ONLY delete last N rows!\n1. Think → analyze request\n2. Call get_expense → check data\n3. If entry is last row → confirm → delete\n4. If not last row → explain limitation\n\n## RESPONSES\n\nExpense recorded:\n✅ [Description] - $[amount]\n📂 [Category] | 💳 [Payment]\nToday's total: $[total]\n\nIncome recorded:\n💰 [Description] - $[amount] → [Account]\n\nView data:\n📊 [Period] expenses:\n[Category]: $[total]\n • [item] - $[amount]\n━━━\n💰 Total: $[grand total]\n\n## COMMANDS\n/help → all commands | /today → today's expenses | /week → this week\n/month → monthly summary | /delete → delete entry | /stats → statistics\n\nCurrent time: {{ $now.format('cccc DD HH:mm') }}\nDate format: yyyy-mm-dd" }, "position": [ 480, 1280 ] }, { "id": "gemini-model", "name": "Google Gemini Chat Model", "type": "llm", "params": { "options": { "temperature": 0.6 }, "provider": "google", "temperature": 0.6 }, "position": [ 80, 1520 ] }, { "id": "memory", "name": "Simple Memory", "type": "passthrough", "params": { "mode": "noOp", "sessionKey": "={{ $json.message.chat.id }}", "sessionIdType": "customKey" }, "position": [ 224, 1520 ] }, { "id": "add-expense", "name": "add_expense", "type": "integration", "params": { "columns": { "value": { "Date": "={{ $fromAI('Date', '', 'string') }}", "Amount": "={{ $fromAI('Amount', '', 'string') }}", "Category": "={{ $fromAI('Category', '', 'string') }}", "Description": "={{ $fromAI('Description', '', 'string') }}", "Payment_Method": "={{ $fromAI('Payment_Method', '', 'string') }}" }, "schema": [ { "id": "Date", "type": "string", "displayName": "Date" }, { "id": "Category", "type": "string", "displayName": "Category" }, { "id": "Description", "type": "string", "displayName": "Description" }, { "id": "Amount", "type": "string", "displayName": "Amount" }, { "id": "Payment_Method", "type": "string", "displayName": "Payment_Method" } ], "mappingMode": "defineBelow", "matchingColumns": [] }, "options": { "cellFormat": "USER_ENTERED" }, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "={{ $now.setLocale('en').toFormat('MMMM yyyy') }}" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_GOOGLE_SHEET_ID_HERE" }, "descriptionType": "manual", "toolDescription": "Add one expense entry to Google Sheets. Parameters:\n- Date: YYYY-MM-DD\n- Category: Food/Transport/Shopping/Entertainment/Bills/Others\n- Description: Short description\n- Amount: Number only\n- Payment_Method: Cash/Card/E-wallet/etc" }, "position": [ 352, 1520 ] }, { "id": "get-expense", "name": "get_expense", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "name", "value": "={{ $now.setLocale('en').toFormat('MMMM yyyy') }}" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_GOOGLE_SHEET_ID_HERE" } }, "position": [ 464, 1520 ] }, { "id": "delete-expense", "name": "delete_expense", "type": "integration", "params": { "service": "googleSheets", "operation": "delete", "sheetName": { "__rl": true, "mode": "name", "value": "={{ $now.setLocale('en').toFormat('MMMM yyyy') }}" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_GOOGLE_SHEET_ID_HERE" }, "numberToDelete": "={{ $fromAI('Number_of_Rows_to_Delete', '', 'number') }}" }, "position": [ 592, 1520 ] }, { "id": "add-income", "name": "add_income", "type": "integration", "params": { "columns": { "value": { "Date": "={{ $fromAI('Date', '', 'string') }}", "Amount": "={{ $fromAI('Amount', '', 'string') }}", "Account": "={{ $fromAI('Account', '', 'string') }}", "Category": "={{ $fromAI('Category', '', 'string') }}", "Description": "={{ $fromAI('Description', '', 'string') }}" }, "schema": [ { "id": "Date", "type": "string", "displayName": "Date" }, { "id": "Category", "type": "string", "displayName": "Category" }, { "id": "Description", "type": "string", "displayName": "Description" }, { "id": "Amount", "type": "string", "displayName": "Amount" }, { "id": "Account", "type": "string", "displayName": "Account" } ], "mappingMode": "defineBelow", "matchingColumns": [] }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "Income Log" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_GOOGLE_SHEET_ID_HERE" } }, "position": [ 720, 1520 ] }, { "id": "get-income", "name": "get_income", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "name", "value": "Income Log" }, "documentId": { "__rl": true, "mode": "id", "value": "YOUR_GOOGLE_SHEET_ID_HERE" } }, "position": [ 848, 1520 ] }, { "id": "calculator", "name": "Calculator", "type": "integration", "params": { "service": "toolcalculator", "operation": "run", "__originalType": "@n8n/n8n-nodes-langchain.toolCalculator" }, "position": [ 960, 1520 ] }, { "id": "think", "name": "Think", "type": "integration", "params": { "service": "toolthink", "operation": "run", "__originalType": "@n8n/n8n-nodes-langchain.toolThink" }, "position": [ 1072, 1520 ] }, { "id": "markdown-formatter", "name": "Markdown to HTML Formatter", "type": "code", "params": { "jsCode": "/**\n * Markdown to HTML converter for Telegram\n */\n\nconst MAX_TELEGRAM = 4096;\nconst SAFE_BUDGET = 4000;\n\nfunction escapeHtml(text) {\n if (!text) return '';\n return String(text)\n .replace(/&/g, '&')\n .replace(//g, '>');\n}\n\nfunction markdownToHtml(inputText) {\n if (!inputText) return '';\n let text = String(inputText);\n const placeholders = [];\n let placeholderIndex = 0;\n \n const addPlaceholder = (html) => {\n const ph = `\\x00PH${placeholderIndex++}\\x00`;\n placeholders.push({ ph, html });\n return ph;\n };\n \n text = text.replace(/```([\\s\\S]*?)```/g, (m, code) => {\n return addPlaceholder(`

${escapeHtml(code.trim())}

`);\n });\n \n text = text.replace(/`([^`\\n]+)`/g, (m, code) => {\n return addPlaceholder(`${escapeHtml(code)}`);\n });\n \n text = text.replace(/\\[([^\\]]+)\\]\$([^)]+)\$/g, (m, label, url) => {\n return addPlaceholder(`${escapeHtml(label)}`);\n });\n \n text = text.replace(/\\*\\*([^*]+)\\*\\*/g, (m, content) => {\n return addPlaceholder(`${escapeHtml(content)}`);\n });\n \n text = text.replace(/(? {\n return addPlaceholder(`${escapeHtml(content)}`);\n });\n \n text = escapeHtml(text);\n \n for (const { ph, html } of placeholders) {\n text = text.replace(ph, html);\n }\n \n text = text.replace(/\\n{3,}/g, '\\n\\n');\n return text.trim();\n}\n\nfunction chunkForTelegram(text, maxLen = SAFE_BUDGET) {\n if (!text || text.length <= maxLen) return [text || ''];\n const parts = [];\n const paragraphs = text.split(/\\n{2,}/);\n \n for (const p of paragraphs) {\n if (p.length <= maxLen) {\n parts.push(p);\n } else {\n const lines = p.split('\\n');\n for (const line of lines) {\n if (line.length <= maxLen) {\n parts.push(line);\n } else {\n const re = new RegExp(`.{1,${maxLen}}`, 'g');\n const pieces = line.match(re) || [];\n parts.push(...pieces);\n }\n }\n }\n }\n return parts.filter(p => p.length > 0);\n}\n\nconst inputItems = $input.all();\nconst out = [];\n\nfor (const item of inputItems) {\n const j = item.json || {};\n const raw = j.output ?? j.message ?? j.text ?? j.content ?? '';\n const formatted = markdownToHtml(raw);\n const chunks = chunkForTelegram(formatted, SAFE_BUDGET);\n\n chunks.forEach((chunk, idx) => {\n out.push({\n json: { ...j, output: chunk, message: chunk, part_index: idx + 1, parts_total: chunks.length },\n binary: item.binary,\n });\n });\n}\n\nreturn out;" }, "position": [ 832, 1104 ] }, { "id": "send-message", "name": "Send Telegram Message", "type": "integration", "params": { "text": "={{ $json.message }}", "chatId": "={{ $('Telegram Trigger').item.json.message.chat.id }}", "service": "telegram", "operation": "read", "additionalFields": { "parse_mode": "HTML", "appendAttribution": false } }, "position": [ 1040, 1104 ] }, { "id": "send-error", "name": "Send Error Message", "type": "integration", "params": { "text": "=Error occurred. Please try again!\n\nIf the issue persists, contact support.", "chatId": "={{ $('Telegram Trigger').item.json.message.chat.id }}", "service": "telegram", "operation": "read", "additionalFields": { "appendAttribution": false } }, "position": [ 832, 1296 ] } ] }

Track expenses and income in Google Sheets from Telegram with Google Gemini