PICKED FROM N8N.IO · FINANCE & ADMIN

Invoices arrive by Gmail attachment, a Google Drive folder or an upload form. The workflow reads the PDF text, has OpenAI pull out the invoice fields, and emails an approver. Approved invoices are added to Google Sheets, and rejected ones trigger a rejection email.

Template by Billy Christi · 14.3k views on n8n.io · listed there as “Automated PDF invoice processing & approval flow using OpenAI and Google Sheets”

THE WORKFLOW14 NODES
◆OpenAI Chat Model{}Structured OutputParser▲Invoice FolderMonitor▲Download InvoicePDF✦Invoice Parser AIAgent▦Insert InvoiceData@Send Invoice forApproval@Monitor EmailAttachments▤Upload Invoice(PDF) Form▭Extract Text fromDrive PDF▭Extract Text fromEmail PDF▭Extract Text fromForm PDF⑂Check ApprovalDecision@Send RejectionAlert
DIFFICULTY
Advanced
NODES
14
USES AI
Yes
PUBLISHED
May 2025

001 / WHAT HAPPENS

  1. 01

    Three triggers watch Gmail attachments, a Drive folder and an upload form for new invoice PDFs.

  2. 02

    The text is extracted from each PDF using a file extraction step.

  3. 03

    An OpenAI agent pulls out the invoice details in a set format.

  4. 04

    An approval email is sent and the decision is checked.

  5. 05

    Approved invoices are added to Google Sheets, while rejected ones send a rejection email.

WHO IT SUITS

Suits a small finance team that receives invoices through several channels and wants a human sign-off before anything is recorded.

CONNECTS

  • Gmail
  • Google Drive
  • Google Sheets
  • OpenAI
  • n8n Form

002 / BEFORE YOU USE IT HERE

  • !Customer or staff details sent to an overseas AI provider such as OpenAI is a cross-border disclosure under APP 8 of the Privacy Act, so say so in your privacy policy.
  • !Check the extracted amounts, GST and ABN fields against real invoices, because the AI prompt may not capture Australian tax details.
  • !Scanned or image-only PDFs may return no text, so test with the invoices your suppliers actually send.
  • !Sheet columns, folder IDs and approver emails are set for the original author and must be replaced.

LOCAL SWAP

Swap the Google Sheets node for the Xero node to create bills in Xero instead of rows in a sheet.

Need n8n and the AI hosted in Australia? →

004 / QUESTIONS

Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.

Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.

We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.

Book a free call→