Create a Factur-X e-invoice from a new Google Sheets row, archive it to Google Drive and email it with Gmail
Create a Factur-X e-invoice from a new Google Sheets row, archive it to Google Drive and email it with Gmail
Apps used in template
About
France and Germany now require structured e-invoices for B2B, and most invoicing tools still produce an ordinary PDF that will not pass. This template closes the gap, without code.
Add a row to your invoice sheet and PDF Generator API turns it into a Factur-X e-invoice: one PDF/A-3 file a person can read, with EN 16931 CII XML embedded that an accounting system can parse. Google Drive archives a copy, Gmail sends it to the buyer. The same file satisfies Factur-X in France and ZUGFeRD in Germany.
Prepare your sheet. Row 1 is a header row, columns A to N:
Invoice number, Issue date, Due date, Buyer name, Buyer VAT ID, Buyer street, Buyer city, Buyer postal code, Buyer country, Buyer email, Description, Quantity, Unit price, VAT rate
Dates as YYYY-MM-DD, amounts with a dot decimal separator, country as a two letter code like FR or DE. One row is one invoice, one line item.
You also need a PDF Generator API template, which controls how the invoice looks. If you have none, copy the free ZUGFeRD and Factur-X template (https://pdfgeneratorapi.com/templates/free-templates/german-invoice-template-zugferd) and pick it during setup. One not mapped to e-invoice fields produces a blank PDF.
Apps used: Google Sheets, PDF Generator API, Google Drive, Gmail.
Guide: PDF Generator API with Make (https://support.pdfgeneratorapi.com/en/article/how-to-integrate-with-makecom-17hmhz6/)
Created by Actual Reports, the team behind PDF Generator API. Questions: [email protected]
Trusted by thousands of fast-scaling organizations around the globe
Similar templates for inspiration
Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.
Create your own workflow
Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Clears a specified range of values from a spreadsheet.
Clears a specific cell.
Clears values from a specific row.
Makes a copy of an existing file.
FAQ
Start by registering for Make. As a new Make user, you’ll automatically be assigned a free account. Once your account is set up, you can start creating your first scenarios. We recommend starting with our step-by-step video tutorial.
A scenario represents a workflow or a project of your own creation, and it is made up of a series of modules that automate apps and services. Creating a scenario allows you to transfer and transform data between apps and services via these modules to automate anything and improve the way you work.
Modules are the main building blocks of automation in Make. Modules represent actions that Make performs with an app, like creating, updating, or deleting data.
Mapping links the modules in your scenario. When you map an item, you connect the data retrieved by one module to another module to perform the desired action. For example, you can map email addresses and subject lines to create a spreadsheet using this data.
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 350,000+ customers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
Philipp Weidenbach
Head of Operations at Teleclinic
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
Cayden Phipps
COO at Shop Accelerator Martech
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
Erkki Markus
Product Owner at Smaily
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."
Andreas Stryz
CTO & Co-founder at FINN
"I can't count the number of hours I've saved by using Make. Every single day is simpler because of Make's automation."
Kimberly D
Owner of Media Production