Template: make incoming e-invoices readable and record them in a spreadsheet

An n8n workflow reads the e-invoices in your mailbox and writes the invoice data to a spreadsheet. For each XRechnung, you receive a readable view as an HTML file by email.

Last updated

Operations parse_invoice, render_invoice
Platforms n8n
Input XRechnung (UBL or CII) and ZUGFeRD or Factur-X PDF as an email attachment

As of October 2026.

Since Jan 1, 2025, businesses in Germany must be able to receive e-invoices (e-invoicing mandate in Germany). An XRechnung is an XML file that is hard to read without extra software.

What the template does

The workflow checks the mailbox via IMAP. Each XML or PDF attachment becomes a row in Google Sheets: sender, invoice number, dates, seller, totals and IBAN.

For each XML invoice, invowerk creates a readable view. It goes to your accounting address as an HTML file. A ZUGFeRD PDF is already readable and only gets the spreadsheet row.

A PDF without embedded invoice data also gets a row, with the reason in the status column. The spreadsheet shows what the invoice contains. It is not a check against the validation rules.

Steps

  1. In n8n, install the community node @invowerk-dev/n8n-nodes-invowerk.
  2. Import the workflow and add your API key.
  3. Connect your mailbox (IMAP), ideally a separate folder for invoices.
  4. Create the spreadsheet with the columns from the instructions.
  5. Connect Google Sheets and SMTP and enter the accounting address.

To test it, send yourself the sample invoice.

Template on GitHub

Workflow and instructions: invowerk-dev/invowerk-integrations, templates/eingehende-e-rechnung-lesbar

Get an API key

Create an API key