Verifactu for Google Sheets (Spain)
GoRoute Verifactu is an add-on for Google Sheets for businesses and the self-employed established in Spain. One row is one invoice. GoRoute creates its Verifactu record, chains it to the previous one with its hash, and sends it to the AEAT signed with your business's own qualified certificate. The AEAT's answer, its CSV, the record's hash and the QR check link come back into the row. The add-on is in Spanish, and in English for a Google account set to English.
Companies that pay corporate income tax need a compliant invoicing system from 1 January 2027, everyone else from 1 July 2027 (Royal Decree 1007/2023). GoRoute is software that sends your Verifactu records to the AEAT; it is not the AEAT and is not endorsed by it. Invoice data is processed by GoRoute on Amazon Web Services in the United States.
For an overview, see the Verifactu for Google Sheets page on goroute.ai. For Shopify stores, see Verifactu for Shopify.
Getting started
- Install GoRoute: Verifactu facturas from the Google Workspace Marketplace, or ask your Workspace administrator to install it for your whole domain. Then open a spreadsheet and choose Extensiones › GoRoute: Verifactu facturas › Abrir Verifactu. You sign in with your Google account; there is no separate password. Cerrar sesión, on every screen, signs you out of GoRoute, and you stay signed out until you press Iniciar sesión con Google.
- Choose the Entorno (environment):
- Producción — records go to the AEAT, with tax effect;
- Pruebas — records go to the AEAT's test service, with no tax effect. It is a separate GoRoute account.
- Configure su negocio (set up your business): legal name (or your full name if you are self-employed), NIF, address, whether the business is in the Canary Islands (IGIC instead of VAT), and two statements: you do not keep your VAT books through SII, and the business is not taxed in the Basque Country or Navarre. Verifactu does not apply in either case (TicketBAI, NaTicket, SII). The add-on inserts three sheets: Facturas, Líneas and Clientes.
- Certificado digital: choose your
.p12or.pfxfile, type its password and press Subir certificado. It must be a qualified certificate for your NIF: a personal certificate if you are self-employed, a representative certificate or an electronic seal for a company. The file and password go to GoRoute over HTTPS; GoRoute checks the certificate and stores it encrypted. Neither is kept in the spreadsheet. Quitar el certificado erases it. - Comprobar conexión sends one throwaway record to the AEAT's test service with your certificate. Factura de
prueba is the AEAT's own "facturar en pruebas": a
PRU-invoice in your chain, cancelled at once.
The Facturas sheet
| Column | Notes |
|---|---|
| Número de factura | Required; up to 60 characters, no quotes and no < > = |
| Fecha, Vencimiento | dd/mm/yyyy or a date cell |
| Tipo | Factura · Rectificativa (sustitución) · Abono (devolución) |
| Cliente, NIF del cliente, País del cliente | With the customer's NIF the invoice is a full invoice; without it, a simplified invoice up to your limit (EUR 3,000 for retail and the activities of the Invoicing Regulation art. 4, EUR 400 otherwise). A Spanish NIF is checked before anything is issued; a foreign VAT number is taken as typed |
| Email del cliente, Dirección, Población, Código postal | |
| Descripción, Cantidad, Precio unitario, Descuento %, IVA % | The first line. More lines go on the Líneas sheet with the same invoice number |
| Operación | Needed at 0 %: Sujeta, Exenta, Inversión del sujeto pasivo, Entrega intracomunitaria, Exportación, No sujeta |
| Moneda | EUR by default; another currency is recorded in euros at the ECB rate |
| Forma de pago, Nota | Printed on the invoice |
| Factura que corrige, Fecha de la factura que corrige | For a rectificativa or an abono |
| Estado AEAT, Mensaje, CSV de la AEAT, Huella, Cotejo en la AEAT (QR), PDF | Written by the add-on |
A row that names a customer from the Clientes sheet takes the empty cells from it.
Check and issue
- Select rows and press Comprobar filas seleccionadas. Each fault is noted on its own cell. Nothing is issued.
- Emitir filas seleccionadas … shows what will be issued (full invoices, simplified invoices, rectificativas, abonos) and who answers, then Emitir. Pressing it twice issues once.
- Actualizar estado reads the AEAT's answer: Registrada en la AEAT (in Producción), Aceptada por el servicio de pruebas de la AEAT (in Pruebas), Rechazada, or Retenida with the reason (an expired certificate, for example).
This row
Select one issued invoice on the Facturas sheet:
- Guardar el PDF en Drive saves the invoice PDF, with the QR and the VERI*FACTU legend, to your Drive and writes the link into the PDF column. The add-on can open only the files it creates.
- Enviar por email al cliente emails the PDF to the row's customer address from GoRoute's sender, with your own address as the reply-to.
- Corregir (factura rectificativa) … adds a new row under the invoice with its own number (
<number>-R1), today's date and the invoice it corrects. Change what was wrong, usually the VAT rate, and press Emitir. GoRoute records a corrective invoice by substitution (R1, or R5 for a simplified invoice) and reads the original's amounts from its own record. Offered only for a record the AEAT accepted. - Volver a emitir (registro rechazado) opens a row whose record the AEAT rejected, so you can correct it and issue it again. A record the AEAT accepted is never issued twice.
- Anular (emitida por error) … cancels an invoice that should never have been issued. The add-on first shows which invoice will be cancelled and warns that this cannot be undone; press Anular la factura to go ahead. GoRoute adds a cancellation record to your chain and sends it to the AEAT; the invoice's own record stays. Offered only once the AEAT has registered the invoice's record: a record still waiting for the AEAT's answer gets a sentence saying to wait, a held one asks you to resolve its message first, and a rejected one is sent to Volver a emitir instead. The row's status then shows the cancellation's state, and Actualizar estado refreshes it. Pressing it twice cancels once. In Producción the cancellation reaches the AEAT with tax effect. See Cancelling an invoice issued in error.
An issued invoice is never deleted or edited. An invoice issued by mistake is cancelled with Anular. A wrong amount or VAT rate is corrected with Corregir. A refund is still an Abono (devolución): set Tipo, the invoice it corrects and its date.
Records
Exportar los registros a una hoja writes every Verifactu record of a period into the Registros Verifactu sheet: sequence, type, number, date, hash, previous hash, AEAT state, CSV and error.
Permissions
The add-on asks for six Google permissions, none restricted: the spreadsheet it is used in
(spreadsheets.currentonly), its sidebar (script.container.ui), calls to GoRoute (script.external_request), your
email address and sign-in (userinfo.email, openid), and the PDFs it creates in your Drive (drive.file). It does not
read your email or any other file.
Your data
The add-on reads only the spreadsheet you use it in and, in Google Drive, only the PDFs it saves for you. Invoices are processed on GoRoute's platform on Amazon Web Services in the United States. Your digital certificate and its password are sent to GoRoute over an encrypted connection and the certificate is stored encrypted; it is used only to sign and send your records to the AEAT and is never written to the sheet. See section 3.8 of the privacy policy and the add-on terms. The add-on is free of charge, and a record for the AEAT is never stopped by a plan limit.
Support
Write to support@goroute.ai.