Google Sheets + HubSpot + VIES API

Create companies in HubSpot with data from VIES using VIES API from new rows in Google Sheets (Team Drive)

Set up this app to streamline your company record management. Once it's active, with each new EU VAT number saved to a row in a specified Google Sheets spreadsheet in Team Drive, this Zap automatically creates a company record containing basic data in HubSpot CRM.

When this happens...
TriggerScheduled
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)
ActionSearch
then do this!
Create Company
Creates a Company in HubSpot.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- EU VAT NumberRequired
Action
Search
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Event Type
Trigger
Scheduled
Try It

- Type
Trigger
Scheduled
Try It
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It

- Blog UrlRequired
- Article StateRequired
Trigger
Scheduled
Try It
New Deal
Triggers when a new Deal is created.
Trigger
Instant
Try It
- Property NameRequired
- Properties to retrieveRequired
Trigger
Scheduled
Try It
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Property NameRequired
- Note
- Additional properties to retrieve
Trigger
Instant
Try It
- Note
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Note
- NameRequired
Action
Write
Create Contact
Creates a Contact in HubSpot.
Action
Write
- Note
- Halt task if any associations error occurred
- Engagement TypeRequired
- Assigned To
Action
Write
- Type of Custom ObjectRequired
Action
Write
Create Deal
Creates a Deal in HubSpot.
Action
Write
- Company IDRequired
- Note
- Additional properties to retrieve
Action
Write
- Type of Custom ObjectRequired
Action
Write
- Note
Action
Write
- Product IDRequired
- Note
- Additional properties to retrieve
Action
Write
Create Line_item
Creates a Line_item in HubSpot.
Action
Write
- Note
- Contact Email AddressRequired
- Event IDRequired
- Contact Value
Action
Write
Remove Associations
Removes associations between objects.
Action
Write
- Note
- FormRequired
- Note
- HubSpot usertoken
- IP address
- Page name
- Page URI
- Page ID
- SFDC campaign ID
- GoToWebinar key/ID
- Submission timestamp
- Skip validation
Action
Write
Update Company
Update a Company in HubSpot.
Action
Write
Update Deal
Update a Deal in HubSpot.
Action
Write
Update Product
Update a Product in HubSpot.
Action
Write
- Type of Custom ObjectRequired
Action
Write
- FolderRequired
- FilenameRequired
- Access levelRequired
- FileRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Note
- Additional properties to retrieve
Action
Search
- Type of Custom ObjectRequired
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Owner emailRequired
- Search among deactivated owners
Action
Search
- Owner IdRequired
- Search among deactivated owners
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Note
- NameRequired
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write
- Note
- NameRequired
- Note
- Company
- Contact
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write

- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Property NameRequired
Trigger
Instant
Try It
Email Subscriptions Timeline
Triggers when new email timeline subscription added for the portal.
Trigger
Scheduled
Try It
- FormRequired
Trigger
Instant
Try It
- Contact ListRequired
- Note
- Additional properties to retrieve
Trigger
Instant
Try It
- Type of Custom ObjectRequired
Trigger
Instant
Try It
- ChannelRequired
- Status
Trigger
Scheduled
Try It
- Note
- Additional properties to retrieve
Trigger
Scheduled
Try It
- Property NameRequired
Trigger
Scheduled
Try It
- Type of Custom ObjectRequired
Trigger
Instant
Try It
- Note
- List NameRequired
- Contact EmailRequired
- Halt my task if contact is already a member of the list
Action
Write
Create Company
Creates a Company in HubSpot.
Action
Write
Create Associations
Creates associations between objects.
Action
Write
- Note
- Social Media ChannelRequired
- Message ContentRequired
- When
- Save as draft
Action
Write
- Note
- Note
- NameRequired
- Company
- Contact
Action
Write
- Note
- Workflow NameRequired
- Contact's EmailRequired
Action
Write
- Contact IDRequired
- Note
- Additional properties to retrieve
Action
Write
- Deal IDRequired
- Note
- Additional properties to retrieve
Action
Write
- Line_item IDRequired
- Note
- Additional properties to retrieve
Action
Write
- Ticket IDRequired
- Note
- Additional properties to retrieve
Action
Write
- Note
- Blog URLRequired
- Blog AuthorRequired
- Publish This Post?Required
- Blog Post URLRequired
- Blog Post TitleRequired
- Blog Post ContentRequired
- Meta DescriptionRequired
- Featured image URL
Action
Write
Create Product
Creates a Product in HubSpot.
Action
Write
- Note
- List NameRequired
- Contact EmailRequired
- Halt my task if contact wasn't a member of the listRequired
Action
Write
Create Ticket
Creates a Ticket in HubSpot.
Action
Write
Update Contact
Update a Contact in HubSpot.
Action
Write
Update Line_item
Update a Line_item in HubSpot.
Action
Write
Update Ticket
Update a Ticket in HubSpot.
Action
Write
- Note
- EmailRequired
Action
Write
- Note
- Note
- Contact EmailRequired
Action
Write
- Note
- NameRequired
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Note
- NameRequired
Action
Search
Find Associations
Find associations between objects.
Action
Search
- Object TypeRequired
- Pipeline IdRequired
- Stage IdRequired
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Note
- Additional properties to retrieve
Action
Search
- Note
- Additional properties to retrieve
Action
Search or write
- Type of Custom ObjectRequired
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write
- Note
- Additional properties to retrieve
Action
Search or write