n8nflow.net logo

Extract Invoice Data from PDFs to JSON with Gemini AI and XML Transformation

by Mauricio Perera•Updated: Last update 20 days ago•Source: n8n.io

Getting Started

This n8n workflow converts invoices in PDF format into a structured, ready-to-use JSON , using AI and XML transformation — without writing any code.

🚀 How it works

  1. Upload form → The user uploads a PDF file.

  2. Text extraction → The PDF content is extracted as plain text.

  3. XML schema definition → A standard invoice structure is defined with fields such as:

    • Invoice number
    • Customer and issuer details
    • Items with description, quantity, and price
    • Totals and taxes
    • Bank account details

  4. AI (Gemini) → The model rewrites the PDF text into a valid XML following the predefined schema.

  5. XML cleanup → Removes extra tags, line breaks, and unnecessary formatting.

  6. JSON conversion → The XML is transformed into a clean, structured JSON object, ready for integrations, APIs, or storage.

✨ Benefits

  • Transforms unstructured PDFs into normalized JSON data.
  • No coding required, only n8n nodes.
  • Scalable to different invoice formats with minimal adjustments.
  • Leverages AI to interpret complex textual content.

🛠️ Use cases

  • Automating invoice data capture.
  • Integration with ERPs, CRMs, or databases.
  • Generating financial reports from PDFs.