Google Sheets + VIES API
Update new Google Sheets rows with data from VIES API
Based only on new EU VAT numbers saved in a Google Sheets spreadsheet, automatically update a company record containing basic data (EU VAT validity and company address) with VIES API.
Based only on new EU VAT numbers saved in a Google Sheets spreadsheet, automatically update a company record containing basic data (EU VAT validity and company address) with VIES API.
- When this happens...New or Updated Spreadsheet Row (Team Drive)
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
- automatically do this...Get Data From VIES
Function to confirm the activity of the EU VAT number assigned by any of the European Union Member States and download company data from VAT Information and Exchange System (VIES)
- then do this...Lookup Spreadsheet Row
Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.
- then do this!Update Spreadsheet Row
Update a row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
