Easily enrich VAT numbers with information about a company’s name, address and contact in just a few steps.
1. Get your Vatlayer API key
2. Connect the Google Maps Integration
3. Use VATLayer to find a company’s name and address from the VAT
Now we are ready to build our app. Add your API Key, the VAT to be validate and use the GET() function to get information about the company.
A1: API Key
A4: PT503504564 (a company’s VAT)
C3: Company name
The VAT number of column A must have the country prefix in order to be enriched by Vatlayer. If you need to add a prefix to all of the VAT numbers, use CONCAT() or CONCATENATE() to help get the job done.
3. Enrich the VAT with company’s phone number
With the VAT and Company name, we will now use a couple of Google Maps formulas to find the phone number of the company.
E3: Place request
E4: =PLACE_SEARCH_GOOGLE(C4&" Portugal")
F3: Place id
G3: Detail request
G3: Phone number
Done! Now you add new VATs on column A and simply drag the remaining formulas down to automatically find theirs names, addresses and phone numbers