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.

allow_blank_strings

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.

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.