Use VIES VAT ID validator service in google scripts
banhill @ 2020 április 25, szombat
Recently I got a request from someone from accounting to help them check a couple of thousand VAT IDs. They are using google sheets for a lot of their tasks, so implementing check in google scripts and linking it to a sheet is convenient for them.
The script linked below uses the free VIES VAT service of the EU to validate the IDs.
https://gist.github.com/banhill/78c9bc2aa8ee0196882954437fe461d8