Automated Trip Expense Claim Form With OpenAI Agent & Google Drive โ€” n8n ์›Œํฌํ”Œ๋กœ

๋ณดํ†ต ๋ณต์žก๋„โšก ํŠธ๋ฆฌ๊ฑฐ12๊ฐœ์˜ ๋…ธ๋“œ๐Ÿท๏ธ Invoice Processing๐Ÿ‘ 96ํšŒ ์กฐํšŒ์ž‘์„ฑ์ž: Trung Tran

๊ฐœ์š”

๐Ÿงพ Automated Trip Expense Claim Form With OpenAI Agent & Google Drive Watch the demo video below:

> This workflow is designed for employees who need to submit expense claims for business trips. It automates the process of extracting data from receipts/invoices, logging it to a Google Sheet, and notifying the finance team via email. ๐Ÿ‘ค Whoโ€™s it for Ideal users: Employees submitting business trip expense claims HR or Admins reviewing travel-related reimbursements Finance teams responsible for pr

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

Send EmailGoogle SheetsGoogle DriveCodeAI AgentOpenAI Chat ModelStructured Output Parser

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

๐Ÿงพ Automated Trip Expense Reporting Workflow
๐Ÿ‘ค Whoโ€™s it for
This workflow is designed for employees who need to sub
!Alt text
1.1 โ€“ Extract and Parse Invoices with AI Agen
Uploaded PDF receipts are processed using OCR and AI. T
3. Send Claim Summary to Finance Team
A formatted email with the employeeโ€™s business trip and
!Alt text
1.2. Store Invoices in Google Sheet
The parsed invoice records are transformed and appended
2. Transform and Generate HTML Email
This step prepares a professional email summary by comb
!Alt text
modelparser
โšก
O
On form submission
Transform Output
Upload file
E
Extract from File
DocClaim Assistant Agent
Append row in sheet
Transform invoice record
Structured Output Parser
Create HTML Email Template
Send trip expense requesโ€ฆ
Handle multiple files
GPT
12 nodes11 edges

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

  1. 1

    ํŠธ๋ฆฌ๊ฑฐ

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

  2. 2

    ์ฒ˜๋ฆฌ

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

  3. 3

    ์ถœ๋ ฅ

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

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

SE

Send Email

emailSend

#1
GO

Google Sheets

googleSheets

#2
GO

Google Drive

googleDrive

#3
CO

Code

code

#4
AI

AI Agent

n8n-nodes-langchain.agent

#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-trip-expense-claim-form-with-openai-agent-google-drive ํŒŒ์ผ์„ ์„ ํƒํ•˜๊ณ  ๊ฐ€์ ธ์˜ค๊ธฐ๋ฅผ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.
  4. 4๊ฐ ์„œ๋น„์Šค ๋…ธ๋“œ์— ๋Œ€ํ•œ ์ž๊ฒฉ ์ฆ๋ช…๏ผˆAPI ํ‚ค, OAuth ๋“ฑ๏ผ‰์„ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  5. 5์›Œํฌํ”Œ๋กœ ํ…Œ์ŠคํŠธ๋ฅผ ํด๋ฆญํ•˜์—ฌ ๋ชจ๋“  ๊ฒƒ์ด ์ž‘๋™ํ•˜๋Š”์ง€ ํ™•์ธํ•œ ํ›„ ํ™œ์„ฑํ™”ํ•ฉ๋‹ˆ๋‹ค.

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

{ "name": "Automated Trip Expense Claim Form With OpenAI Agent & Google Drive", "nodes": [...], ...}

ํ†ตํ•ฉ

agentcodeemailsendextractfromfileformtriggergoogledrivegooglesheetslmchatopenaioutputparserstructured

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

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

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

์ œ์ž‘์ž

Trung Tran

Trung Tran

@trungtran

ํƒœ๊ทธ

agentcodeemailsendextractfromfileformtriggergoogledrivegooglesheetslmchatopenaioutputparserstructured
โšก

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