Google Sheets · Peppol · VIES

Peppol ID and VAT checks in Google Sheets

Check your whole customer list in Google Sheets at once: is each customer on the Peppol network, under which Peppol ID and access point, and is its EU VAT number valid in VIES. Three spreadsheet functions and one sidebar, free, with no GoRoute account. The answers are read live from the Peppol registers by GoRoute, a certified Peppol Access Point and SMP provider (POP000991).

Free. No sign-in. Up to 300 rows in one formula, any number from the sidebar.

Your sheet

=PEPPOL_LOOKUP("BE", B2)

GoRoute

Yes · 0208:0403019261 · receives Invoice (BIS 3) and Credit note (BIS 3) through its access point

What can you check?

Every function takes one value or a whole range, so a customer list is checked in one formula. The lookups are the ones GoRoute's own API and connectors make before every send.

You type You get Size
=PEPPOL_LOOKUP("0208:0403019261") Yes or No, the Peppol ID, the name on Peppol, the access point (provider and seat ID) and the document types it receives One cell or a range
=PEPPOL_LOOKUP("BE", B2:B200) The same for a whole column of VAT or company numbers, one row of answers per customer Up to 300 rows a formula
=PEPPOL_ID("BE", "BE0403019261") The live Peppol ID, or the one the rules give, marked No when it is not on Peppol One cell or a range
=VAT_CHECK("DE811907980") Valid or Invalid in VIES, with the name and address where the member state publishes them One cell or a range
Check selected rows Any number of rows, 25 at a time, written into new columns with headers Sidebar

The last argument of each function picks the answers you want, for example =PEPPOL_LOOKUP("BE", B2, "status, access_point"). Answers are kept for up to six hours, so a sheet that recalculates does not ask again.

Who is it for?

Any business that has to know whether its customers receive e-invoices over Peppol. In Belgium, B2B e-invoicing has applied between VAT-registered businesses since 1 January 2026 and has been enforced since the tolerance period ended on 31 March 2026 (einvoice.belgium.be). Before the first invoice goes out, a seller needs each customer's Peppol ID.

1. Paste your customer list

Names, countries and VAT or company numbers, as your accounting software exports them.

2. Check selected rows

Choose the number and country columns, tick Peppol and VAT, and the answers fill new columns.

3. Send the e-invoices

To the customers on Peppol, straight from Google Sheets with GoRoute E-Invoicing for Google Workspace.

Prefer to check from your own systems? The same lookup is in the GoRoute API, and the GoRoute connectors run it before every invoice they send.

Price, your data and terms

The add-on is free of charge and needs no account. It reads only the cells you check in the spreadsheet you use it in, and sends GoRoute only the identifiers in them. How Google user data is used is set out in section 3.9 of the Privacy Policy, and the add-on terms say who provides it.

Found customers on Peppol?

Send them e-invoices from the same spreadsheet: checked against the official rules and delivered over Peppol by a certified Access Point.

Peppol and VAT checks in Google Sheets: common questions

What businesses ask before checking a customer list

What does the add-on check?

Two things for every row of a customer list. First, whether the customer is on the Peppol network: its Peppol ID, the access point that receives for it, and the document types it accepts, such as invoices and credit notes. Second, whether its EU VAT number is valid in VIES, the European Commission's VAT number validation service, with the name and address where the member state publishes them.

Do I need to know my customers' Peppol IDs?

No. Give the country and the VAT or company number and GoRoute works out the identifiers a business of that country is registered under, then asks the Peppol network which one is live. For a Belgian customer that is the enterprise number under scheme 0208, then the VAT number under 9925. When none is live, the add-on shows the identifier the rules give and marks the customer as not on Peppol.

Where do the answers come from?

From the registers themselves, read live. GoRoute is a certified Peppol Access Point and SMP provider (POP000991): it asks the Peppol SML and the customer's SMP for every Peppol ID, the Peppol Directory to find candidates, and VIES for VAT numbers. "Unknown, try again" means a register did not answer in time; it is never shown as a no.

Do I need a GoRoute account?

No. The add-on works without an account, a password or an API key. It asks Google for three permissions only: to read and write the spreadsheet you use it in, to show its sidebar, and to reach GoRoute over the internet.

What does the add-on send to GoRoute?

Only the numbers in the cells you check: Peppol IDs, VAT and company numbers, and countries. Never your name, your email address, other cells or the spreadsheet itself. GoRoute processes the checks on its servers in the United States, keeps the public answers in a cache for at most a day and its technical logs for 30 days, and does not link the numbers you asked about to you.

Why does it matter in Belgium?

Since 1 January 2026 Belgian VAT-registered businesses must send each other structured e-invoices, and since the tolerance period ended on 31 March 2026 the rule is enforced. A seller needs to know which customers already receive over Peppol and under which identifier, before the first invoice goes out.