Last updated: 21 October 2026
VAT Checker for Sheets (the "Add-on") is a Google Sheets add-on published by a sole trader established in France (the "Publisher"). Contact: barterfrance@gmail.com.
The Add-on provides a custom function =VAT() (alias =TVA()) which takes a VAT number typed in a cell, queries the European Commission's VIES service (and, for French numbers when VIES is unavailable, the INSEE Sirene API) and writes the validity, registered name and address back into your spreadsheet.
=VAT(). The Add-on does not read any other cell.The Add-on requests only the Google permissions strictly needed: access to the current spreadsheet (spreadsheets.currentonly), connection to external services (script.external_request) and display of a sidebar (script.container.ui).
We do not store your spreadsheets. We do not store check results on our servers (a temporary 6-hour cache exists inside Google Apps Script, on Google's side, to avoid duplicate requests). We do not sell, rent or share any data. We use no advertising trackers.
Our use of information received from Google APIs adheres to the Google API Services User Data Policy, including the Limited Use requirements. Google data is used solely to provide the function described above.
The licence key and counter remain in your Apps Script properties while the Add-on is installed. Uninstalling the Add-on, or e-mailing us, is enough to delete them. Billing data is retained by Lemon Squeezy according to its legal obligations.
You have the right to access, rectify, erase and object. Write to barterfrance@gmail.com. You may lodge a complaint with the CNIL (cnil.fr) or your local data protection authority.
Any change will be published on this page with its date.