Home/Browse/Extract and process invoices with GPT-4, Google Drive, and Google Sheets

Extract and process invoices with GPT-4, Google Drive, and Google Sheets

n8n12 modulesv1.0

Google SheetsOpenAIGoogle Drive

At a glance

Extract and process invoices with GPT-4, Google Drive, and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform

About this workflow

This template is a fully automated AI invoice processing workflow for n8n. It watches a Google Drive folder for new invoice PDFs, extracts all key information using an AI Agent, assigns the correct booking account, saves the renamed invoice in the right Drive folder, and updates your Google Sheets booking list. A perfect starter template if you want to build your own AI-powered accounting automation. What this workflow does - Monitors a Google Drive folder for new invoice PDFs. - Downloads and extracts invoice text from the uploaded PDF. - Uses an AI Agent (OpenAI + Structured Output Parser) to extract: - invoice date - vendor - currency - total amount - invoice number - booking text - booking account - matching Google Drive folder ID - Automatically renames the PDF to a clean, consistent format (e.g. 250912 Vendor.pdf). - Saves the invoice into the correct accounting folder in Google Drive. - Updates your booking list in Google Sheets with all extracted fields. - Moves the processed invoice to an output folder to avoid duplicates. Everything runs hands-free after setup. Key features - 🧠 AI Invoice Reading using OpenAI + LangChain - 📑 Structured Output Parser guarantees clean, validated fields - 📁 Automated Google Drive File Routing - 📊 Google Sheets logging for accounting records - 🔄 File movement logic to keep input/output folders organized - ⚙️ Chart of Accounts integration from your Google Sheet - 🟦 Works out of the box with Invoice Agent – Folder Structure Setup (recommended) Typical use cases - Automated accounting workflows - Pre-processing invoices before importing into ERP or sevDesk - AI-powered invoice extraction for small businesses or freelancers - Structured archiving of invoices for tax and audit requirements - Fully automated Google Drive invoice inbox How to use this template 1. Connect your Google Drive & Sheets credentials in all relevant nodes. 2. Select your: • Input folder (where invoices are uploaded) • Output folder (where processed invoices go) • Folder structure sheet + booking accounts sheet 3. Upload any invoice PDF into the input folder. 4. The workflow starts automatically and processes the invoice end-to-end. ⸻ Requirements • Google Drive OAuth2 • Google Sheets OAuth2 • OpenAI API key • A Google Sheet containing your chart of accounts • A prepared folder structure (use the “Google Drive Structure Setup” template)

Extract and process invoices with GPT-4, Google Drive, and Google Sheets

At a glance

About this workflow

How to import this n8n workflow

Setup guide

Step 1: Connect your apps

Step 2: Import the workflow JSON

More N8n workflows

Reviews