You can't use this until you register with us!


Use data from BigQuery to update information in HubSpot.

Purchasing Options

Available Actions

Update Contacts

Use data from BigQuery to update contacts in HubSpot.


Source Parameters
bq_creds required

Credentials to use to access the BigQuery Cloud Data Warehouse.

sql_query required

SQL query to find new and updated contacts in BigQuery.

updated_column required

Column that holds a timestamp of the last time the row was updated.

hubspot_id required

Column that holds the id associated with the contact in HubSpot.


Optional table name specified as project.dataset.table to store errors. If specified, invalid contacts will be skipped. Otherwise, invalid contacts trigger an execution failure.


Allow a blank string to passed as a property value.

pointer required

Datetime stamp indicating the last run time. Formatted as YYYY-MM-DD HH:MM:SS in UTC timezone.


SQL Query to use to determine the end point of the data to process.

Destination Parameters
hubspot_credentials required

API Key or Access Token to connect to HubSpot.