Automate employee trip expense processing with Jotform, OpenAI and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on Jotform events. Along the way it connects Google Drive, Google Sheets, OpenAI Chat Model and Gmail and 1 more.
How it runs
Trigger: On Jotform events.
- 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
- Document Extractor (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 a message (Gmail): uses Gmail
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)
- Code
n8n-nodes-base.code - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - AI Agent
@n8n/n8n-nodes-langchain.agent - Jotform Trigger
n8n-nodes-base.jotFormTrigger
From the author
👤 Who’s it for 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. Ideal…