Analyze invoices from Google Drive with AI and store data in Google Sheets

Who this template is for

This workflow is designed for teams and businesses that receive invoices in Google Drive and want to automatically extract structured financial data without manual processing. It is ideal for finance teams, operators, and founders who want a simple way to turn invoices into usable data.

No accounting software is required, and the workflow works with common invoice formats such as PDFs and images.

What this workflow does

This workflow monitors a Google Drive folder for newly uploaded invoices. When a file is detected, it uses AI to extract key invoice information such as issuer, date, total amount, taxes, currency, and description.

The extracted data is automatically cleaned, structured, and stored in Google Sheets, creating a centralized and searchable invoice database.

How it works

The workflow starts when a new file is added to a Google Drive folder Each file is processed individually and classified based on its type (PDF or image) The file is then downloaded and analyzed using an AI model optimized for document or image understanding Key invoice fields such as issuer, date, total amount, taxes, currency, and description are extracted and normalized into structured fields The AI output is appended to a Google Sheets table — a short wait step ensures reliable sequential writes when multiple invoices are processed at the same time

How to set up

Select the Google Drive folder where invoices will be uploaded Connect your OpenAI credentials for document and image analysis Choose the Google Sheets file that will store the extracted invoice data Activate the workflow and upload an invoice to test it

Requirements

Google Drive account Google Sheets account OpenAI API credentials n8n instance (cloud or self-hosted)

How to customize the workflow

You can adjust the fields extracted from invoices, add validation rules, connect the data to accounting tools, or extend the workflow with reporting and notification steps.