Easily enrich VAT numbers with information about a company’s name, address and contact in just a few steps.
1. Connect the integrations
2. Find a company’s name and address from the VAT
Now we are ready to build our app. Add the list of VATs to be validated in column A and using the
FIND_COMPANY_VAT_VATSEARCH function get the company details.
A1: VAT id
C1: Company Name
The VAT number of column A must have the country prefix in order to be enriched. If you need to add a prefix to all of the VAT numbers, use CONCAT() or CONCATENATE() to get the job done.
3. Enrich the VAT with company’s phone number
With the company name and address we will now use a couple of Google Maps formulas to find the phone number of the company.
F1: Place request
F2: =PLACE_SEARCH_GOOGLE(C2&" “&E2)
G1: Place id
H1: Detail request
I1: 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