Automated Invoice Processing with Telegram, GPT-4o, OCR and SAP Integration โ€” n8n ์›Œํฌํ”Œ๋กœ

๋†’์Œ ๋ณต์žก๋„โšก ํŠธ๋ฆฌ๊ฑฐ27๊ฐœ์˜ ๋…ธ๋“œ๐Ÿท๏ธ Invoice Processing๐Ÿ‘ 12,872ํšŒ ์กฐํšŒ์ž‘์„ฑ์ž: Raquel Giugliano

๊ฐœ์š”

++HOW IT WORKS:++ This workflow automates the processing of invoices sent via Telegram. It extracts the data using LlamaIndex OCR, logs it in Google Sheets, and optionally pushes the structured data to SAP Business One

๐Ÿ”น 1. Receive Invoice via Telegram:** A user sends a PDF of an invoice through Telegram A Telegram Trigger node listens for incoming messages and captures the file and metadata The document is downloaded and prepared for OCR

๐Ÿ”น 2. OCR with LlamaIndex: The file is uploaded to the L

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

Google SheetsHTTP RequestTelegramCodeBasic LLM ChainOpenAI Chat ModelStructured Output Parser

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

Waiting for an answer on telegram
Send data and OCR with LlamaIndex
modelparser
W
Wait
Basic LLM Chain
OpenAI Chat Model
N
No Operation, do nothing
S
Split Out
M
Merge
โšก
C
Callback Waiting Answer
A
Answer?
Connect to SAP
Get Header
Get Row Details
Generate DocumentLines
Create JSON
POST PurchaseInvoices
PurchaseInvoices created
โšก
T
Trigger Receive Message
C
Capture Telegram Data
File Received
Download File
Upload File LlamaIndex
Validate Status LlamaIndex
S
Status?
Get Results LlamaIndex
Structured Output Parserโ€ฆ
Detail
Header
ยฟUpload to SAP?
27 nodes27 edges

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

  1. 1

    ํŠธ๋ฆฌ๊ฑฐ

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

  2. 2

    ์ฒ˜๋ฆฌ

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

  3. 3

    ์ถœ๋ ฅ

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

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

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
TE

Telegram

telegram

#3
CO

Code

code

#4
BA

Basic LLM Chain

n8n-nodes-langchain.chainLlm

#5
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#6
ST

Structured Output Parser

n8n-nodes-langchain.outputParserStructured

#7

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

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

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

{ "name": "Automated Invoice Processing with Telegram, GPT-4o, OCR and SAP Integration", "nodes": [...], ...}

ํ†ตํ•ฉ

chainllmcodegooglesheetshttprequestlmchatopenaimergeoutputparserstructuredsetsplitoutswitchtelegramtelegramtriggerwait

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

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

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

์ œ์ž‘์ž

Raquel Giugliano

Raquel Giugliano

@raquelgiugliano

ํƒœ๊ทธ

chainllmcodegooglesheetshttprequestlmchatopenaimergeoutputparserstructuredsetsplitoutswitch
โšก

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