Get company's addresses, names and contacts from VAT number

Hey,

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

First, you will need to create a Vatlayer account. After that is done go to the dashboard and get your API Key.

2. Connect the Google Maps Integration

Then, connect our Google Maps integration. Here is the guide on how to get your Google API key and connect the 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
B1: “YOUR_API_KEY”
A3: VAT
A4: PT503504564 (a company’s VAT)
B3: Request
B4: =GET(“http://apilayer.net/api/validate?access_key="&$B$1&"&vat_number=”&A4)
C3: Company name
C4: =PARSE(B4,"[‘company_name’]")
D3: Address
D4: =PARSE(B4,"[‘company_address’]")

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
F4: =PARSE(E4,"[‘results’][0].[‘place_id’]")
G3: Detail request
G4: =PLACE_DETAIL_GOOGLE(F4)
G3: Phone number
H4: =PARSE(G4,"[‘result’].[‘formatted_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 :muscle:

Happy building,
Henrique

1 Like