BigQuery to HubSpot Loader

Use data from BigQuery to update information in HubSpot.

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.

pointer required

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

Destination Parameters

hubspot_credentials required

API Key or Access Token to connect to HubSpot.

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