Integration of HubSpot with BigQuery

📢 Introduction

This module integrates with the HubSpot API, enabling you to collect CRM data and store it in Google Cloud BigQuery. Gain deeper insights into your data and optimize the performance of your CRM efforts with real-time data collection.

📝 Configuration Guide

Follow the steps below to connect HubSpot with BigQuery. Once the setup is complete, your ad data will be automatically transferred to your BigQuery project.

💡 Tip: Make sure you have admin access to your HubSpot account before starting the configuration.

🔧 Module Setup

Go to the Collect section in the menu > Click Create Data Collect.

Select HubSpot from the list of available integrations.

Enter the Collector Name, e.g., "HubSpot Collect".

🔑 Authorization

💡 Tip: If you have previously authorized the HubSpot module and do not require additional permissions, you can skip this step.

Click Authorize.

Log in and grant the necessary permissions.

Select the appropriate account from the dropdown list.

⏳ Historical Data and Scheduling

The HubSpot module automatically retrieves the entire historical data from your CRM — there's no need to select a date range.

A data synchronization schedule will be created automatically. More information on this topic can be found here.

📊 Data Schema

Expand the tables below to view the full data schema collected from HubSpot.