Automated Expense Tracking with AI Receipt Analysis & Google Sheets โ€” n8n ์›Œํฌํ”Œ๋กœ

๋†’์Œ ๋ณต์žก๋„โšก ํŠธ๋ฆฌ๊ฑฐ31๊ฐœ์˜ ๋…ธ๋“œ๐Ÿท๏ธ Invoice Processing์ž‘์„ฑ์ž: Issam AGGOUR

๊ฐœ์š”

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Your Pocket Bookkeeper is workflow designed to automate expense tracking for freelancers and small businesses. It transforms your favorite chat app into a smart financial assistant, eliminating tedious manual data entry and ensuring your records are always organized, up-to-date, and secure. Just send a photo or a text, and let AI handle the rest.

Why Your Pocket Bookkeeper? ๐Ÿค”

For a freelancer

์‚ฌ์šฉ๋œ ๋…ธ๋“œ

Google SheetsHTTP RequestTelegramGoogle DriveCodeAI AgentOpenAI Chat ModelSimple MemoryAuto-fixing Output ParserStructured Output ParserMistral Cloud Chat ModelGoogle Gemini Chat ModelOpenRouter Chat ModelThink Tool

์›Œํฌํ”Œ๋กœ ๋ฏธ๋ฆฌ๋ณด๊ธฐ

tooltoolmemoryparsermodelparsermodel
Format Summary Message
C
Check Invalid Input
E
Extract Text Input
C
Check for Image
Receipt Parser
Send Error Message
Send Expense Summary
E
Extract Value From Image
โšก
T
Telegram Trigger1
Google Gemini Chat Model
Telegram
AI Agent
Auto-fixing Output Parser
Simple Memory
Think
D
Date & Time
Mistral Cloud Chat Model
Mistral Cloud Chat Model1
Send Expense Summary1
Google Sheets
E
Edit Fields
OpenAI Chat Model
OpenRouter Chat Model
E
Execute Workflow
โšก
W
When Executed by Anotherโ€ฆ
Save Receipt
M
Merge
Mistral Upload
Mistral Signed URL
Mistral DOC OCR
Code
31 nodes29 edges

์ž‘๋™ ์›๋ฆฌ

  1. 1

    ํŠธ๋ฆฌ๊ฑฐ

    ์›Œํฌํ”Œ๋กœ๋Š” ํŠธ๋ฆฌ๊ฑฐ ํŠธ๋ฆฌ๊ฑฐ๋กœ ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค.

  2. 2

    ์ฒ˜๋ฆฌ

    ๋ฐ์ดํ„ฐ๊ฐ€ 31๊ฐœ์˜ ๋…ธ๋“œ๋ฅผ ํ†ตํ•ด ํ๋ฆ…๋‹ˆ๋‹ค, connecting agent, code, datetimetool.

  3. 3

    ์ถœ๋ ฅ

    ์›Œํฌํ”Œ๋กœ๊ฐ€ ์ž๋™ํ™”๋ฅผ ์™„๋ฃŒํ•˜๊ณ  ๊ตฌ์„ฑ๋œ ๋Œ€์ƒ์— ๊ฒฐ๊ณผ๋ฅผ ์ „๋‹ฌํ•ฉ๋‹ˆ๋‹ค.

๋…ธ๋“œ ์„ธ๋ถ€ ์ •๋ณด (31)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
TE

Telegram

telegram

#3
GO

Google Drive

googleDrive

#4
CO

Code

code

#5
AI

AI Agent

n8n-nodes-langchain.agent

#6
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#7
SI

Simple Memory

n8n-nodes-langchain.memoryBufferWindow

#8
AU

Auto-fixing Output Parser

n8n-nodes-langchain.outputParserAutofixing

#9
ST

Structured Output Parser

n8n-nodes-langchain.outputParserStructured

#10
MI

Mistral Cloud Chat Model

n8n-nodes-langchain.lmChatMistralCloud

#11
GO

Google Gemini Chat Model

n8n-nodes-langchain.lmChatGoogleGemini

#12
OP

OpenRouter Chat Model

n8n-nodes-langchain.lmChatOpenRouter

#13
TH

Think Tool

n8n-nodes-langchain.toolThink

#14

์ด ์›Œํฌํ”Œ๋กœ ๊ฐ€์ ธ์˜ค๋Š” ๋ฐฉ๋ฒ•

  1. 1์˜ค๋ฅธ์ชฝ์˜ JSON ๋‹ค์šด๋กœ๋“œ ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜์—ฌ ์›Œํฌํ”Œ๋กœ ํŒŒ์ผ์„ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค.
  2. 2n8n ์ธ์Šคํ„ด์Šค๋ฅผ ์—ด๊ณ  ์›Œํฌํ”Œ๋กœ โ†’ ์ƒˆ๋กœ ๋งŒ๋“ค๊ธฐ โ†’ ํŒŒ์ผ์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค.
  3. 3๋‹ค์šด๋กœ๋“œ๋œ automated-expense-tracking-with-ai-receipt-analysis-google-sheets ํŒŒ์ผ์„ ์„ ํƒํ•˜๊ณ  ๊ฐ€์ ธ์˜ค๊ธฐ๋ฅผ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.
  4. 4๊ฐ ์„œ๋น„์Šค ๋…ธ๋“œ์— ๋Œ€ํ•œ ์ž๊ฒฉ ์ฆ๋ช…๏ผˆAPI ํ‚ค, OAuth ๋“ฑ๏ผ‰์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  5. 5์›Œํฌํ”Œ๋กœ ํ…Œ์ŠคํŠธ๋ฅผ ํด๋ฆญํ•˜์—ฌ ๋ชจ๋“  ๊ฒƒ์ด ์ž‘๋™ํ•˜๋Š”์ง€ ํ™•์ธํ•œ ํ›„ ํ™œ์„ฑํ™”ํ•ฉ๋‹ˆ๋‹ค.

๋˜๋Š” n8n โ†’ JSON์—์„œ ๊ฐ€์ ธ์˜ค๊ธฐ์— ์ง์ ‘ ๋ถ™์—ฌ๋„ฃ๊ธฐ:

{ "name": "Automated Expense Tracking with AI Receipt Analysis & Google Sheets", "nodes": [...], ...}

ํ†ตํ•ฉ

agentcodedatetimetoolexecuteworkflowexecuteworkflowtriggergoogledrivegooglesheetshttprequestiflmchatgooglegeminilmchatmistralcloudlmchatopenailmchatopenroutermemorybufferwindowmergen8n-nodes-tesseractjs.tesseractnodeoutputparserautofixingoutputparserstructuredsettelegram

์ด ์›Œํฌํ”Œ๋กœ ๊ฐ€์ ธ์˜ค๊ธฐ

ํ•œ ๋ฒˆ์˜ ํด๋ฆญ์œผ๋กœ ๋‹ค์šด๋กœ๋“œ ๋ฐ ๊ฐ€์ ธ์˜ค๊ธฐ

JSON ๋‹ค์šด๋กœ๋“œn8n.io์—์„œ ๋ณด๊ธฐ
๋…ธ๋“œ31
๋ณต์žก๋„high
ํŠธ๋ฆฌ๊ฑฐtrigger
์นดํ…Œ๊ณ ๋ฆฌInvoice Processing

์ œ์ž‘์ž

Issam AGGOUR

Issam AGGOUR

@devgor

ํƒœ๊ทธ

agentcodedatetimetoolexecuteworkflowexecuteworkflowtriggergoogledrivegooglesheetshttprequestiflmchatgooglegemini
โšก

n8n์„ ์ฒ˜์Œ ์‚ฌ์šฉํ•˜์‹œ๋‚˜์š”?

n8n์€ ๋ฌด๋ฃŒ ์˜คํ”ˆ์†Œ์Šค ์›Œํฌํ”Œ๋กœ ์ž๋™ํ™” ๋„๊ตฌ์ž…๋‹ˆ๋‹ค. ์ž์ฒด ํ˜ธ์ŠคํŒ…ํ•˜๊ฑฐ๋‚˜ ํด๋ผ์šฐ๋“œ ๋ฒ„์ „์„ ์‚ฌ์šฉํ•˜์„ธ์š”.

n8n ๋ฌด๋ฃŒ๋กœ ์‹œ์ž‘ํ•˜๊ธฐ โ†’

Related Invoice Processing Workflows

COCOEMEX+5
medium

Automate Custom QuickBooks Invoice PDFs & Email with n8n

Standard accounting templates often fail to reflect a premium brand identity. This sophisticated n8n workflow bridges the gap between financial record-keeping and professional client presentation. By moving beyond the native limitations of QuickBooks Online, this automation enables businesses to generate high-end, multi-page PDF invoices that align perfectly with their corporate styling. The process begins the moment a new invoice is generated in QuickBooks, triggering a webhook that captures real-time billing data. The workflow then utilizes advanced HTML-to-File conversion and custom Code nodes to structure data into a polished, branded layout. It handles complex logic such as line-item merging and multi-page formatting automatically. Once the document is rendered, the system bypasses generic 'no-reply' senders by routing the finalized PDF through your preferred email provider. This ensures a seamless, white-labeled experience for your clients while eliminating the manual overhead of exporting, styling, and attaching files. Ideal for agencies and service providers, this flow guarantees that your most frequent touchpointโ€”the billโ€”is as professional as your work. **Common Use Cases:** - High-end creative agencies requiring bespoke, white-labeled billing documents for premium clients. - Automated recurring subscription billing where custom tax disclosures or localized branding are required. - Service-based businesses needing to attach dynamic project reports or terms of service directly to QuickBooks invoices.

๐Ÿ”— Webhookยท12 nodes