Template: create and send an XRechnung from a spreadsheet row
An n8n workflow turns every new row in Google Sheets into an XRechnung and emails it to the buyer. invowerk creates the XML and checks it against the validation rules before returning it.
Last updated
| Operations | generate_invoice |
|---|---|
| Platforms | n8n |
| Result | XRechnung in UBL as an XML attachment to an email |
As of October 2026.
For anyone who keeps invoices as rows in a spreadsheet and has to deliver an XRechnung, for example to a public authority. One row is one invoice with one line item.
What the template does
The workflow starts on every new row. A code step calculates quantity times price, the VAT and the totals. invowerk writes these amounts into an XRechnung (UBL syntax) and checks it against EN 16931 and the XRechnung rules.
invowerk does not return an invoice with an error; the step then stops. invowerk does not recalculate the amounts: you check yourself whether prices and tax rate are correct.
Steps
- In n8n, install the community node
@invowerk-dev/n8n-nodes-invowerk. - Import the workflow and add your API key.
- Create the spreadsheet with the columns from the instructions, such as
invoice_number,buyer_reference(Leitweg-ID) andunit_price. - Enter your company details and your IBAN in the code step.
- Connect Google Sheets and Gmail.
A sample row is included, so you see the result before the first email goes out.
Template on GitHub
Workflow and instructions: invowerk-dev/invowerk-integrations, templates/zeile-zu-xrechnung