User Guide — Sheets → Factur-X
What is it?
A Google Workspace add-on that transforms your Google Sheets rows into Factur-X invoices (PDF/A-3 + XML EN 16931) — the mandatory format for French SMBs from 1/9/2027.
Installation
- Open Google Workspace Marketplace
- Search for “Sheets Factur-X”
- Click “Install” and authorize permissions (access to current spreadsheet and Google Drive)
Initial setup
Step 1 — Configure the issuer profile
Open the sidebar → “Issuer Profile” section:
| Field | Format | Example |
|---|---|---|
| Company name | Free text | ACME SAS |
| SIRET | 14 digits | 12345678900012 |
| VAT number | FR + 11 digits | FR12345678901 |
| IBAN | European IBAN | FR76 3000 6000 0123… |
| VAT franchise art. 293 B | Checkbox | ✓ for micro-enterprises |
Step 2 — Map columns
Menu → “Map Columns”: associate each column in your Sheets with a Factur-X field.
| Factur-X field | Description |
|---|---|
buyerName | Customer name |
buyerSiret | Customer SIRET (optional, recommended for B2B) |
description | Service/product description |
quantity | Quantity |
unitPrice | Unit price (excluding VAT) |
vatRate | VAT rate (e.g. 20, 5.5, 0) |
This mapping is saved per spreadsheet — you only do it once.
Step 3 — Generate drafts
- Enter row numbers (e.g.
2,3,5or2-10) - Click “Generate Drafts”
- Review each invoice in the control screen
Step 4 — Validate and issue
Check the verified invoices → “Validate and Issue” → confirmation.
The numbering is assigned at this exact moment. PDFs + XML files are archived in /Factures Factur-X/YYYY/ on your Drive.
Pricing plans
| Plan | Price | Monthly quota |
|---|---|---|
| Free | €0 | 5 invoices/month |
| Solo | €9/month | 30 invoices/month |
| Pro | €19/month | Unlimited + batch |
What the add-on does NOT do (v1)
- Automatic transmission to approved platforms (PA): transmission remains an explicit user action via the “Transmit PA” button
- Automatic sending to the client: you remain the issuer, you send it yourself
- Accounting software integration: export PDF/XML from your Drive