N8N 재무 추적기: Telegram 인보이스至 Notion, AI 요약 및 리포트 포함
고급
이것은Finance, AI분야의자동화 워크플로우로, 28개의 노드를 포함합니다.주로 Code, Notion, SplitOut, Telegram, EditImage 등의 노드를 사용하며인공지능 기술을 결합하여 스마트 자동화를 구현합니다. Telegram 인보이스를 Notion에 동기화하고 Gemini AI 보고서를 생성하는 자동 재정 추적기
사전 요구사항
- •Notion API Key
- •Telegram Bot Token
- •Google Gemini API Key
사용된 노드 (28)
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"id": "3BkxvtCbF6hHGUgM",
"meta": {
"instanceId": "d847dccbed2cefba539a228a44c266869b59eafbd4f307c4928a1149fb542a9e",
"templateCredsSetupCompleted": true
},
"name": "N8N Financial Tracker Telegram Invoices to Notion with AI Summaries & Reports",
"tags": [
{
"id": "OXcPKHaINFSvU1ux",
"name": "Money",
"createdAt": "2025-05-09T11:02:15.929Z",
"updatedAt": "2025-05-09T11:02:15.929Z"
},
{
"id": "witgF3iHQ0sAlkjG",
"name": "experimental",
"createdAt": "2025-05-09T11:02:15.933Z",
"updatedAt": "2025-05-09T11:02:15.933Z"
}
],
"nodes": [
{
"id": "3792ae58-807f-4e83-a219-25c17c8b4048",
"name": "Google Gemini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
680,
380
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.5-flash-preview-04-17"
},
"credentials": {
"googlePalmApi": {
"id": "haEP6ehKtsSUjFmK",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "943f87e2-a1ac-4f7e-999b-8ea261259e5a",
"name": "Basic LLM Chain",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
640,
220
],
"parameters": {
"text": "=ini ada base64 invoice rangkumkan Pengeluaran dari invoice tersebut Nama Barang jumlah dan Pengeluaran masing masing barang dan total, outputnya jangan panjang panjang saya cukup berikan \n\ndate: DD-MM-YYYY ( Jika dari OCR tidak ada tanggal ambil tanggal hari ini )\nid:\nname:\n qty: \nprice:\n total:\ncategory:\ntax : (jika di total berbeda dengan item brati ada pajak nya hitungkan juga pajaknya masukan kesini)\n\nuntuk pilihan categorynya : Food & Beverage / Transportation / Utilities / Shopping / Healthcare / Entertaiment / Housing / Education\n\ndalam bentuk JSON array object, berikan juga key message summary untuk rangkuman, berikan rangkauman singkat total pengeluaran dan barang apa saja yang dibeli serta jumlah nya berikan juga pajaknya",
"messages": {
"messageValues": [
{
"type": "HumanMessagePromptTemplate",
"messageType": "imageBinary"
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.4
},
{
"id": "247b78cb-c3f6-4f31-8559-0fff70de9ba9",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"width": 1703,
"height": 580,
"content": "## Automated Financial Tracker: Telegram Invoices to Notion with AI Summaries & Reports\n"
},
"typeVersion": 1
},
{
"id": "e20045c2-a8ef-43d6-b619-6825f605e183",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
620
],
"parameters": {
"color": 5,
"width": 1706,
"height": 527,
"content": "## Schedule report to send on chanel or private message\n"
},
"typeVersion": 1
},
{
"id": "ed8d6544-af9e-416a-b1f3-624ca108427f",
"name": "Schedule Trigger | 차트 보고서 전송용",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
80,
880
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "22ad7ea1-9404-48bd-9d0f-0c58b8b66e3d",
"name": "Notion에서 최근 데이터 가져오기",
"type": "n8n-nodes-base.notion",
"position": [
400,
940
],
"parameters": {
"filters": {
"conditions": [
{
"key": "Created time|created_time",
"condition": "past_week"
}
]
},
"options": {},
"resource": "databasePage",
"operation": "getAll",
"returnAll": true,
"databaseId": {
"__rl": true,
"mode": "list",
"value": "1d858554-d218-807c-936c-d06c8a8ec769",
"cachedResultUrl": "https://www.notion.so/1d858554d218807c936cd06c8a8ec769",
"cachedResultName": "Pengeluaran Rizqi Dini"
},
"filterType": "manual"
},
"credentials": {
"notionApi": {
"id": "AhjWhO7Jpc5x7xKG",
"name": "Notion account"
}
},
"typeVersion": 2.2
},
{
"id": "34310645-52da-4f9c-96a2-0a01d0a640f9",
"name": "거래 데이터 요약",
"type": "n8n-nodes-base.summarize",
"position": [
760,
920
],
"parameters": {
"options": {},
"fieldsToSplitBy": "property_category",
"fieldsToSummarize": {
"values": [
{
"field": "property_total",
"aggregation": "sum"
}
]
}
},
"typeVersion": 1
},
{
"id": "80a374cb-00cf-46b1-9505-709be1c550da",
"name": "차트 생성",
"type": "n8n-nodes-base.quickChart",
"position": [
1200,
900
],
"parameters": {
"data": "={{ $json.chart.data.datasets[0].data }}",
"labelsMode": "array",
"labelsArray": "={{ $json.chart.data.labels }}",
"chartOptions": {},
"datasetOptions": {}
},
"typeVersion": 1
},
{
"id": "6b7c67ee-b205-42f5-9441-eb2ecee4a503",
"name": "그룹 또는 개인 채팅에 차트 이미지 전송",
"type": "n8n-nodes-base.telegram",
"position": [
1460,
760
],
"webhookId": "66cce6e1-819c-487b-b8ad-3f02aebd40cb",
"parameters": {
"chatId": "-1001957001324",
"operation": "sendPhoto",
"binaryData": true,
"additionalFields": {
"fileName": "chart",
"message_thread_id": 571
}
},
"credentials": {
"telegramApi": {
"id": "J8yRVYmsnH74HuaD",
"name": "Telegram account"
}
},
"typeVersion": 1.2
},
{
"id": "06afd5ea-77b2-468d-b12b-1386d37a3ee6",
"name": "데이터를 JSON 차트 페이로드로 변환",
"type": "n8n-nodes-base.code",
"position": [
1080,
900
],
"parameters": {
"jsCode": "const labels = [];\nconst values = [];\n\nfor (const item of items) {\n labels.push(item.json.property_category);\n values.push(item.json.sum_property_total);\n}\n\nreturn [\n {\n json: {\n chart: {\n type: 'bar',\n data: {\n labels,\n datasets: [\n {\n label: 'Spending by Category',\n data: values,\n backgroundColor: 'rgba(54, 162, 235, 0.6)',\n borderColor: 'rgba(54, 162, 235, 1)',\n borderWidth: 1\n }\n ]\n },\n options: {\n plugins: {\n title: {\n display: true,\n text: 'Spending Summary by Category'\n }\n },\n scales: {\n y: {\n beginAtZero: true\n }\n }\n }\n }\n }\n }\n];"
},
"typeVersion": 2
},
{
"id": "4ad8c9c9-fbec-46ce-943d-447ca687e031",
"name": "Telegram Trigger | 사진 수신 시",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
160,
160
],
"webhookId": "cac4ce91-ed1f-42ea-aebe-97ac3612aea6",
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "J8yRVYmsnH74HuaD",
"name": "Telegram account"
}
},
"typeVersion": 1.1
},
{
"id": "5231929f-2d7d-43ff-b9ae-141374926131",
"name": "이미지 정보 가져오기",
"type": "n8n-nodes-base.editImage",
"position": [
460,
160
],
"parameters": {
"operation": "information"
},
"typeVersion": 1
},
{
"id": "c8dcc6a1-2367-4049-9a8b-d8a04299ee72",
"name": "Parse To your object | 테이블",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1040,
460
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n \"type\": \"object\",\n \"properties\": {\n \"message\": {\n \"type\": \"string\"\n },\n \"summary\": {\n \"type\": \"array\",\n \"items\": {\n \"type\": \"object\",\n \"properties\": {\"date\": { \"type\": \"date\" },\n \"id\": { \"type\": \"integer\" },\n \"name\": { \"type\": \"string\" },\n \"qty\": { \"type\": \"integer\" },\n \"price\": { \"type\": \"number\" },\n \"tax\": { \"type\": \"number\" },\n \"total\": { \"type\": \"number\" },\"category\": { \"type\": \"string\" }\n },\n \"required\": [\"id\", \"name\", \"qty\", \"price\", \"total\",\"category\"]\n }\n }\n },\n \"required\": [\"message\", \"summary\"]\n}\n"
},
"typeVersion": 1.2
},
{
"id": "bc098a26-4e55-4908-880c-e5f27737a941",
"name": "Split Out | 거래 데이터",
"type": "n8n-nodes-base.splitOut",
"position": [
1120,
40
],
"parameters": {
"options": {},
"fieldToSplitOut": "output.summary"
},
"typeVersion": 1
},
{
"id": "2a42bc4b-a5c7-433e-91e4-aa5531570f73",
"name": "채팅으로 다시 전송 및 요약 텍스트 제공",
"type": "n8n-nodes-base.telegram",
"position": [
1480,
400
],
"webhookId": "f90475fa-69cd-4e19-bc93-bffdceae8324",
"parameters": {
"text": "={{ $json.output.message }}",
"chatId": "={{ $('Telegram Trigger | When recive photo').item.json.message.chat.id }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "J8yRVYmsnH74HuaD",
"name": "Telegram account"
}
},
"typeVersion": 1.2
},
{
"id": "bfc5c52e-313d-4257-bdfa-c542b687a853",
"name": "Record To Notion Database",
"type": "n8n-nodes-base.notion",
"position": [
1580,
120
],
"parameters": {
"options": {},
"resource": "databasePage",
"databaseId": {
"__rl": true,
"mode": "list",
"value": "1d858554-d218-807c-936c-d06c8a8ec769",
"cachedResultUrl": "https://www.notion.so/1d858554d218807c936cd06c8a8ec769",
"cachedResultName": "Pengeluaran Rizqi Dini"
},
"propertiesUi": {
"propertyValues": [
{
"key": "Name|title",
"title": "={{ $json.name }}"
},
{
"key": "Quantity|number",
"numberValue": "={{ $json.qty }}"
},
{
"key": "Price|number",
"numberValue": "={{ $json.price }}"
},
{
"key": "Total|number",
"numberValue": "={{ $json.total }}"
},
{
"key": "Category|select",
"selectValue": "={{ $json.category }}"
},
{
"key": "Date|rich_text",
"textContent": "={{ $json.date }}"
},
{
"key": "Tax|number",
"numberValue": "={{ $json.tax }}"
}
]
}
},
"credentials": {
"notionApi": {
"id": "AhjWhO7Jpc5x7xKG",
"name": "Notion account"
}
},
"typeVersion": 2.2
},
{
"id": "f514554b-eb9e-47e2-ad6b-0b13036beaf4",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
40,
60
],
"parameters": {
"color": 3,
"width": 340,
"height": 280,
"content": "📸 INVOICE INPUT 📸\nBot listens here for photos of your receipts/invoices.\nEnsure your Telegram Bot API token is set in credentials."
},
"typeVersion": 1
},
{
"id": "53fc4c77-3f16-4cb8-82e8-f4810af1f569",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
60
],
"parameters": {
"color": 5,
"width": 360,
"height": 460,
"content": "🤖 AI MAGIC HAPPENS HERE 🧠\n- Image is sent to Google Gemini for data extraction.\n- Check 'Basic LLM Chain' to customize the AI prompt (e.g., categories, output format).\n- Requires Google Gemini API credentials."
},
"typeVersion": 1
},
{
"id": "c6fb1193-7cc9-4f45-8a5f-20af41cdf3c8",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
340
],
"parameters": {
"color": 5,
"width": 280,
"height": 200,
"content": "✨ STRUCTURING AI DATA ✨\nConverts the AI's text output into a usable JSON object.\nCheck the schema if you modify the AI prompt significantly."
},
"typeVersion": 1
},
{
"id": "79a4e9ba-d1ea-4cfc-870c-145bae80c9b4",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
0
],
"parameters": {
"color": 2,
"width": 380,
"height": 240,
"content": "📝 SAVING TO NOTION 📝\n- Extracted transaction data is saved here.\n- Configure with your Notion API key & Database ID.\n- Map fields correctly to your database columns!"
},
"typeVersion": 1
},
{
"id": "9406306b-9f3d-4877-a888-1f5e16a431c1",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
760
],
"parameters": {
"height": 280,
"content": "REPORTING SCHEDULE 🗓️\nSet how often you want to receive your spending report (e.g., weekly, monthly)."
},
"typeVersion": 1
},
{
"id": "1b6c8a28-b0f0-44fb-be02-21725d950716",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
760
],
"parameters": {
"color": 2,
"width": 280,
"height": 380,
"content": "📊 FETCHING DATA FOR REPORT 📊\n- Retrieves transactions from Notion for the report period.\n- Default: \"Past Week\". Adjust filter as needed.\n- Requires Notion API credentials & Database ID."
},
"typeVersion": 1
},
{
"id": "4612006e-04a9-4ad5-9f05-d49ec13f31cf",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
740
],
"parameters": {
"width": 320,
"height": 360,
"content": "➕ SUMMARIZING SPENDING ➕\nAggregates your expenses, usually by category,\nto prepare for the chart."
},
"typeVersion": 1
},
{
"id": "103132cf-37a6-455f-b19f-14d3e17af912",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
740
],
"parameters": {
"width": 300,
"height": 340,
"content": "📈 GENERATING VISUAL REPORT 📈\nCreates the actual chart image based on your spending data.\nYou can customize chart type (bar, pie, etc.) here."
},
"typeVersion": 1
},
{
"id": "24324366-33e5-4097-ab36-aac31cef0006",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1380,
640
],
"parameters": {
"color": 6,
"width": 300,
"height": 300,
"content": "📤 SENDING REPORT TO TELEGRAM 📤\n- Delivers the generated chart to your chosen Telegram chat/group.\n- Set the correct Chat ID and Bot API token."
},
"typeVersion": 1
},
{
"id": "e9fc1140-411b-411a-87a6-bbe9718ba3b3",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
1320,
280
],
"parameters": {
"color": 6,
"width": 300,
"height": 280,
"content": "💬 TRANSACTION SUMMARY 💬\nSends a confirmation message back to the user in Telegram\nwith a summary of the recorded expense."
},
"typeVersion": 1
},
{
"id": "013fd587-3504-44b8-97e1-09cad47a0089",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
40,
360
],
"parameters": {
"color": 7,
"width": 460,
"height": 240,
"content": " 🔑 CREDENTIALS NEEDED 🔑\n Remember to set up API keys/tokens for:\n - Telegram\n - Google Gemini\n - Notion\n\n 💡 CUSTOMIZE ME! 💡\n - Adjust AI prompts for better accuracy.\n - Change Notion database structure.\n - Modify report frequency and content.\n"
},
"typeVersion": 1
},
{
"id": "8f6f0fdb-d3be-4464-a7db-ea4d642a4f55",
"name": "Telegram",
"type": "n8n-nodes-base.telegram",
"position": [
320,
160
],
"webhookId": "6e801e0b-72d1-42a9-ac47-61ac113a01d2",
"parameters": {
"fileId": "={{ $json.message.photo[3].file_id }}",
"resource": "file"
},
"credentials": {
"telegramApi": {
"id": "J8yRVYmsnH74HuaD",
"name": "Telegram account"
}
},
"typeVersion": 1.2
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a192c50c-4a77-44ee-b98a-f18d4ced2cb1",
"connections": {
"8f6f0fdb-d3be-4464-a7db-ea4d642a4f55": {
"main": [
[
{
"node": "5231929f-2d7d-43ff-b9ae-141374926131",
"type": "main",
"index": 0
}
]
]
},
"80a374cb-00cf-46b1-9505-709be1c550da": {
"main": [
[
{
"node": "6b7c67ee-b205-42f5-9441-eb2ecee4a503",
"type": "main",
"index": 0
}
]
]
},
"5231929f-2d7d-43ff-b9ae-141374926131": {
"main": [
[
{
"node": "943f87e2-a1ac-4f7e-999b-8ea261259e5a",
"type": "main",
"index": 0
}
]
]
},
"943f87e2-a1ac-4f7e-999b-8ea261259e5a": {
"main": [
[
{
"node": "bc098a26-4e55-4908-880c-e5f27737a941",
"type": "main",
"index": 0
},
{
"node": "2a42bc4b-a5c7-433e-91e4-aa5531570f73",
"type": "main",
"index": 0
}
]
]
},
"3792ae58-807f-4e83-a219-25c17c8b4048": {
"ai_languageModel": [
[
{
"node": "943f87e2-a1ac-4f7e-999b-8ea261259e5a",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"34310645-52da-4f9c-96a2-0a01d0a640f9": {
"main": [
[
{
"node": "06afd5ea-77b2-468d-b12b-1386d37a3ee6",
"type": "main",
"index": 0
}
]
]
},
"22ad7ea1-9404-48bd-9d0f-0c58b8b66e3d": {
"main": [
[
{
"node": "34310645-52da-4f9c-96a2-0a01d0a640f9",
"type": "main",
"index": 0
}
]
]
},
"c8dcc6a1-2367-4049-9a8b-d8a04299ee72": {
"ai_outputParser": [
[
{
"node": "943f87e2-a1ac-4f7e-999b-8ea261259e5a",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"bc098a26-4e55-4908-880c-e5f27737a941": {
"main": [
[
{
"node": "bfc5c52e-313d-4257-bdfa-c542b687a853",
"type": "main",
"index": 0
}
]
]
},
"06afd5ea-77b2-468d-b12b-1386d37a3ee6": {
"main": [
[
{
"node": "80a374cb-00cf-46b1-9505-709be1c550da",
"type": "main",
"index": 0
}
]
]
},
"4ad8c9c9-fbec-46ce-943d-447ca687e031": {
"main": [
[
{
"node": "8f6f0fdb-d3be-4464-a7db-ea4d642a4f55",
"type": "main",
"index": 0
}
]
]
},
"ed8d6544-af9e-416a-b1f3-624ca108427f": {
"main": [
[
{
"node": "22ad7ea1-9404-48bd-9d0f-0c58b8b66e3d",
"type": "main",
"index": 0
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급 - 금융, 인공지능
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
Tesseract - 재정 도우미 X
통해Telegram사용Tesseract및Llama에서收据中추출详细信息
If
Set
Code
+
If
Set
Code
27 노드Khairul Muhtadin
금융
스마트资金관리器
基于Telegram、Google Sheets및OpenAI의AI驱动收据및支出追踪器
If
Set
Code
+
If
Set
Code
50 노드Khairul Muhtadin
금융
개인 - TRM 신청
Telegram 로봇과 AI 날짜 인식을 사용하여 코리아 페소兑 미국 달러 환율 가져오기
If
Set
Code
+
If
Set
Code
31 노드Juan Sanchez
금융
⚡AI驱动의YouTube播放列表및视频摘要与분석v2
AI YouTube播放列表与视频분석채팅봇
If
Set
Code
+
If
Set
Code
72 노드dmr
기타
AI 기반 RAG 문서 처리 및 챗봇 - Google Drive, Supabase, OpenAI
Google Drive, Supabase 및 OpenAI를 활용한 AI 기반 RAG 문서 처리 및 챗봇
Set
Code
Limit
+
Set
Code
Limit
35 노드Billy Christi
인공지능
OCR Telegram - SAP
Telegram, GPT-4o, OCR, SAP 통합 기반 자동 인voice 처리
Set
Code
Wait
+
Set
Code
Wait
29 노드Raquel Giugliano
인공지능
