Extract Colombian invoice data from Drive to Sheets with GPT-4o
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 18 nodes and runs on Google Drive events (file updated) (plus 1 other trigger). Along the way it connects Azure OpenAI Chat Model, Google Drive and Google Sheets.
How it runs
Trigger: On Google Drive events (file updated) (plus 1 other trigger).
- 2. Download file (Google Drive): download
- 3. Route (Switch): routes items into 2 branches
- 4. Extract data from PDF (Extract from File): extracts data from a file (pdf)
- 4. Extract Data Agent (Basic LLM Chain): sends a prompt to an LLM, with model: Azure OpenAI Chat Model
- 5. Reasoning Agent (Basic LLM Chain): sends a prompt to an LLM, with model: Azure OpenAI Chat Model; output parser: Structured Output Parser
- 5. Reasoning Agent (Basic LLM Chain): sends a prompt to an LLM, with model: Azure OpenAI Chat Model
- 6. Edit Field (Edit Fields (Set)): sets 1 field: response.text
- 6. Edit Field (Edit Fields (Set)): sets 1 field: response.text
- 7. Split data (Split Out): splits a list into separate items
- 7. Split Data (Split Out): splits a list into separate items
…plus 2 more steps. See the full node list below.
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 (10)
- Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Switch
n8n-nodes-base.switch - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Extract from File
n8n-nodes-base.extractFromFile
From the author
Automate Colombian Cashflow Data Extraction to Google Sheets with AI Who’s it for This workflow is designed for finance professionals, accountants, small business owners in Colombia, or anyone needing to automate the extraction of invoice data and its entry…