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

Description

Use data from BigQuery to update information in HubSpot.

Purchasing Options

BigQuery to HubSpot Loader - $99.99 / month

Available Actions

Update Contacts

Use data from BigQuery to update contacts in HubSpot.

Variables

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.

errors_table_name

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.

pointer required

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

end_point_query

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.