Automated trip expense claim form with OpenAI agent & Google Drive
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs when someone submits an n8n form (“Business Trip Claim Submission”). Along the way it connects Google Drive, Google Sheets and OpenAI Chat Model.
How it runs
Trigger: When someone submits an n8n form (“Business Trip Claim Submission”).
- Handle multiple files (Code): runs custom JavaScript code
- Upload file (Google Drive): uses Google Drive
- Extract from File: extracts data from a file (pdf)
- Transform invoice record (Code): runs custom JavaScript code
- DocClaim Assistant Agent (AI Agent): runs an AI agent, with model: GPT; output parser: Structured Output Parser
- Append row in sheet (Google Sheets): append
- Transform Output (Code): runs custom JavaScript code
- Create HTML Email Template (Code): runs custom JavaScript code
- Send trip expense request to finance team (Send Email): sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Send Email
n8n-nodes-base.emailSend - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
🧾 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…