Extract structured invoice data from JotForm PDFs with GPT-4.1-mini & Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Formatted Structured Data Extract (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Download Invoice (HTTP Request): calls an HTTP API
- Write File from Disk for Inbound Invoice Processing (Read/Write Files from Disk): writes a file to disk
- Extract from File: extracts data from a file (pdf)
- Structured Data Extract (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Append or update row in sheet (Google Sheets): append or update
- Create a Binary Response (Function): runs custom JavaScript (legacy Function node)
- Write the Structured Invoice to Disk (Read/Write Files from Disk): writes a file to disk
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Create a Binary Response: replace with Code node, mode 'Run Once for All Items'.
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Create a Binary Response | Code node, mode 'Run Once for All Items' |
Nodes used (10)
- Webhook
n8n-nodes-base.webhook - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - HTTP Request
n8n-nodes-base.httpRequest - Extract from File
n8n-nodes-base.extractFromFile - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Read/Write Files from Disk
n8n-nodes-base.readWriteFile - Google Sheets
n8n-nodes-base.googleSheets - Function
n8n-nodes-base.function
From the author
Who this is for This workflow is designed for Finance teams, accounting professionals, and automation engineers. Use Case: Automates processing of invoice submissions received via JotForm. Core Function: Extracts structured data such as: Invoice number Client…