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

Description

Use information in HubSpot to update data in BigQuery.

Purchasing Options

HubSpot to BigQuery Loader - $99.99 / month

Available Actions

Update Contacts

Use contact information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

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


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Companies

Use company information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

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


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Deals

Use deal information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

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


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Products

Use product information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

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


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Tickets

Use ticket information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

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


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Quotes

Use quote information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

last_run required

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


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

insert_only required

Enable to append data retrieved directly to the table without any deduplication against existing rows beforehand.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Owners

Use owners information in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

truncate_table required

Enable to DELETE ALL EXISTING DATA from the BigQuery table prior to adding new data.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.


Update Form Submissions

Use form submissions in HubSpot to update data in BigQuery.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

col_names required

Shared Config containing mappings between BigQuery column names and HubSpot contact property names.

hubspot_form required

Unique guid of the HubSpot form used to create the submissions.


Destination Parameters
gcp_con required

Credentials to use to access the BigQuery Cloud Data Warehouse.

project required

Name of the project with the dataset where the data will be updated.

dataset required

Name of the dataset with the table where the data will be updated.

table required

Name of the table where the data will be updated.

truncate_table required

Enable to DELETE ALL EXISTING DATA from the BigQuery table prior to adding new data.

process_increment

This Task will process data in increments. Set a value in this field to determine the size of each increment.


List Available Object Properties

Displays the available properties, both custom and default, for the specified HubSpot object.

Variables

Source Parameters
hubspot_con required

API Key or Access Token to connect to HubSpot.

hubspot_objects required

Select the type of objects for which available properties should be displayed.