Automate invoice data extraction with OCR.Space, GPT & 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 10 nodes and runs on a schedule (every week at 20:00). Along the way it connects Google Drive, OpenAI and Google Sheets. It also calls api.ocr.space over HTTP.
How it runs
Trigger: On a schedule (every week at 20:00).
- Get Parent Folder (Google Drive): work with file folder
- Get Monthly Subfolder (Google Drive): work with file folder
- List Files (Google Drive): work with file folder
- Download File (Binary from Drive) (Google Drive): download
- OCR (OCR.Space Parsing) (HTTP Request): calls api.ocr.space (POST)
- Clean OCR Text (Noise Removal) (Code): runs custom JavaScript code
- AI Extraction (Generate Structured JSON) (OpenAI): uses OpenAI
- Parse AI Output to JSON (Code): runs custom JavaScript code
- Append to Google Sheets (Google Sheets): append
Services it uses
HTTP calls to: api.ocr.space
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 (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Drive
n8n-nodes-base.googleDrive - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets
From the author
Overview This template automates invoice processing for teams that currently copy data from PDFs into spreadsheets by hand. It is ideal for small businesses, back-office teams, accounting, and operations who want to reduce manual entry, avoid human error, and…