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

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

n8nn8n12 modulesv1.0
Google SheetsOpenAIGoogle Drive

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 - Monito

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
n8n
Connects
Google Sheets, OpenAI, Google Drive
Modules
12
Price
Free
Version
v1.0
Extract and process invoices with GPT-4, Google Drive, and Google Sheets workflow diagram

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)

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Resume data extraction and storage in Supabase from email attachments

Description What Problem Does This Solve? 🛠️ This workflow automates the process of extracting key information from resumes received as email attachments and storing that data in a structured format within a Supabase database. It eliminates the manual effort of reviewing each resume, identifying relevant details, and entering them into a database. This streamlines the hiring process, making it faster and more efficient for recruiters and HR professionals. Target audience: Recruiters, HR departme

Free

Add leads from noCRM.io to Google Sheet

Import all or selected leads from noCRM into Google Sheets. The Google Sheets used in this scenario has the following columns: Lead ID, Title, Description, Status, and Step.

Free

Convert ISO 3166-1 codes listed in a Google Sheets spreadsheet to country names

This scenario uses the ISO service to automatically convert ISO 3166-1 codes listed in a specific Google Sheets spreadsheet to corresponding country names. The template uses a table created according to this [example](https://goo.gl/YeHIgY).

Free

Add Google Sheets rows for prospects that reply in Woodpecker

Every time a new prospect replies in Woodpecker, Make will automatically add a new row to a Google Sheet. This example uses [this sheet](https://docs.google.com/spreadsheets/d/1I_0ORbuaKUyehO5qj7l3iWRNYELfAuG5lQzLfyuSw9A/edit#gid=0).

Free

Add info and links of Zoom recordings to a Google Sheet and upload to Google Drive

When a recording is completed on Zoom, this scenario instantly receives the details, adds the info and the recording's link to a Google Sheet and uploads the file to Google Drive. This template uses this Google Sheet example.

Free

Send WhatsApp bulk messages from Google Sheets

WhatsApp Bulk Message Broadcast via Google Sheets (n8n Workflow) Use Case This workflow enables automated bulk WhatsApp message broadcasting using the WhatsApp Business Cloud API. It pulls recipient and message data from a Google Sheet, sends templated messages (optionally with image headers), and updates the sheet with the message status. It is ideal for marketing teams, support agents, and businesses handling high-volume outreach. --- Who Is This For? - Businesses conducting WhatsApp marketing

Free

N8N for beginners: looping over items

N8N for Beginners: Looping Over Items Description This workflow is designed for n8n beginners to understand how n8n handles looping (iteration) over multiple items. It highlights two key behaviors: - Built-In Looping: By default, most n8n nodes iterate over each item in an input array. - Explicit Looping: The Loop Over Items node allows controlled iteration, enabling custom batch processing and multi-step workflows. This workflow demonstrates the difference betwe

Free

Summarize content from URLs, text & PDFs using OpenAI

AI Content Summarizer Suite This n8n template collection demonstrates how to build a comprehensive AI-powered content summarization system that handles multiple input types: URLs, raw text, and PDF files. Built as 4 separate workflows for maximum flexibility. Use cases: Research workflows, content curation, document processing, meeting prep, social media content creation, or integrating smart summarization into any app or platform. How it works - Multi-input handling: Separate workflows f

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free