Google Workspace (Sheets, Gmail, Drive)
GoRoute E-Invoicing for Google Workspace is an add-on for Google Sheets, Gmail and Google Drive. A row in a spreadsheet becomes an e-invoice: GoRoute checks it against the official EN 16931 and Peppol rules and delivers it over the Peppol network, or by email from your own Gmail with the e-invoice inside the PDF. Received e-invoices are read in Gmail and Drive. The add-on speaks English, German, French and Dutch, following your Google language.
For an overview, see the Google Workspace page on goroute.ai.
Getting startedโ
- Install the GoRoute E-Invoicing add-on from the Google Workspace Marketplace, or ask your Workspace administrator to install it there for your whole domain.
- Open a spreadsheet and choose Extensions โบ GoRoute E-Invoicing โบ Start. You sign in with your Google account: there is no separate GoRoute password. If your email address already has a GoRoute login, GoRoute first sends a confirmation link to it, so nobody can take over an existing organisation with a Google account of the same address.
- Set up your company: legal name, country, address and, if it has one, its VAT number. The add-on inserts the Invoices, Lines, Customers and Products sheets in your language.
The sheetsโ
| Sheet | What goes in it |
|---|---|
| Invoices | One row per invoice, with its first line on the same row. Status and messages are written back by the add-on |
| Lines | Further lines of an invoice, joined to it by the invoice number |
| Customers | Your customers. A row on the Invoices sheet that names one is completed from it (empty cells only) |
| Products | Your price list. A line whose description is on it takes its price and tax rate when the row has none |
| Received | Written by the add-on: the e-invoices you receive, newest first, with a "Booked" tick of your own |
Headers, tab names and the drop-down choices are in your language, and are read in every language, so a sheet made by a colleague in German works for you in English.
Check, send and emailโ
- Check selected rows runs GoRoute's rules. Each fault is noted on its own cell.
- Send selected rows shows what will go over Peppol and what by email, then sends. A customer on the Peppol network receives the invoice there; anyone else is sent it by email as a ZUGFeRD or Factur-X PDF with the e-invoice inside (Peppol BIS outside the countries that use those). Where a customer has neither a Peppol ID nor a VAT number, its email address is enough.
- Email sends the invoice from your own Gmail address with the PDF attached, or as a Drive link. Column names between
percent signs (
%Customer%,%Invoice number%) are replaced by the row's values. Google's daily limit for your account is shown before anything goes. - Save PDF to Drive saves the invoice PDF to your Drive.
Sending and receiving over Peppolโ
Files and email work as soon as you sign in. To send and receive over the Peppol network, GoRoute confirms the company first: give your VAT number at set-up or later, and GoRoute checks it in the official register, usually within one business day. Then press Switch Peppol on. If another provider already hosts your Peppol ID, you can send over Peppol straight away; invoices sent to you keep arriving there until that provider releases the ID, after which the same button moves receiving to GoRoute.
Peppol is offered for companies in Germany, Austria, Belgium, the Netherlands, Luxembourg, Ireland, the United Kingdom, Norway, Sweden, Finland, Estonia, Latvia, Lithuania, Australia and New Zealand.
Countries with no e-invoice formatโ
For a company in a country with no e-invoice format GoRoute serves, such as the United States, a row becomes a plain PDF invoice: your own invoice number, your own name for your tax ("Sales tax", "GST") or no tax line at all, and no VAT fields. The sheets leave out the columns only an e-invoice needs. See Plain invoices for the API behind it.
Gmail and Driveโ
- Gmail: open an email with an XML or PDF e-invoice attached; the GoRoute panel lists the attachments and reads the one you choose. The home panel also offers a draft with the PDF of an invoice you created, which you then send yourself.
- Drive: select one e-invoice file. The add-on asks you to allow it to open that one file, then reads it.
The add-on never scans your mailbox or your Drive: it reads only the email you open and the file you select.
Plansโ
| Plan | Price | What it includes |
|---|---|---|
| Free | EUR 0 | 50 documents a month, Peppol included, one invoice at a time |
| Solo | EUR 8.90 a month or EUR 89 a year | 250 documents a month over Peppol, unlimited files and email, several invoices at once |
| Company | EUR 27.90 a month or EUR 279 a year | 1,000 documents a month over Peppol, colleagues from your Workspace domain, emailing many invoices at once |
GoRoute charges no VAT on these prices. A customer already on a GoRoute plan has the add-on's paid features with it.
Colleaguesโ
On the Company plan, the owner of the organisation can let colleagues who sign in with a Google Workspace account of the company's own domain join it, as members or read-only (the switch is in the add-on, under Plan). The domain is the one Google states for the signed-in account; a personal Google account cannot be used for it.
Permissionsโ
| Permission | Why |
|---|---|
| See, edit, create and delete the spreadsheet the add-on is used in | Read invoice rows and write statuses back |
| Run as a sidebar inside Google apps | Show the add-on |
| Send email as you | Email an invoice from your own address, when you press Email |
| Read the email you open, and compose drafts | Read an e-invoice attachment; open a draft with an invoice attached |
| See and create the specific Drive files you use with the add-on | Save PDFs to Drive; read a file you select |
| Connect to an external service | Talk to GoRoute |
| See your primary Google Account email address, and associate you with your personal info on Google | Sign you in to GoRoute |
None of these is a restricted Google permission. GoRoute is a Peppol Certified Access Point (POP000991); invoice data is processed under its ISO 27001-certified management system. See the trust page.
Supportโ
Write to support@goroute.ai with the invoice number or the row, and the message the add-on showed. To report a fault, say what you pressed and what you expected. Answers come from GoRoute's support team.