From Hubspot to BigQuery: managed, scheduled, no code.
Creating a pipeline that sends data from Hubspot to BigQuery data warehouses takes only a few minutes with Kondado. And the whole integration from Hubspot to BigQuery is managed and executed by our platform. With Kondado, you can focus on extracting value from Hubspot data and combining it with other data in your BigQuery data warehouse
Sending Hubspot data to BigQuery enables powerful analytics across your marketing, sales, and service operations without complex engineering work. Kondado provides direct replication of your Hubspot data to BigQuery on a configurable schedule, eliminating manual CSV exports and time-consuming data preparation. Simply select from the 24 available pipelines covering contacts, deals, email events, and marketing campaigns, set your preferred update frequency ranging from every 5 minutes to daily, and start analyzing consolidated customer data immediately alongside other business sources for comprehensive insights.
Kondado automatically replicates data from Hubspot to BigQuery on a configurable schedule ranging from every 5 minutes to daily, providing analysts with fresh CRM, marketing automation, and customer service data for advanced analytics and custom reporting across the entire customer journey.
Once your data arrives in BigQuery, you can combine the Contacts and Deals pipelines to build comprehensive customer lifetime value models and sales funnel analysis. The Email Events pipeline provides granular engagement data for optimizing marketing automation performance, while the Companies pipeline enables sophisticated account-based marketing strategies with enriched firmographic details. These datasets support custom dashboards in Looker Studio, Power BI, or other visualization tools connected to your BigQuery warehouse, allowing you to create reports that span the complete customer journey from lead acquisition to retention.
Try out all the features for free for 14 days
Replicated to BigQuery
Hubspot data available for BigQuery
Tables Kondado writes into your BigQuery, on a schedule you control.
24
available pipelines
805
extractable fields
BigQuery
Destination
Available integrations
Companies
Includes information such as id, name, and properties related to contacts and deals.
Contact lists
Presents contact lists with details on membership and relevant properties.
Contacts
Brings contact information such as id, email, name, and created date.
Contacts: form submissions
Includes form submissions with fields such as conversion id, content type, and form id.
Contacts: lists membership
Displays the association of contacts to specific lists and their properties.
Custom object
Represents custom objects with fields such as id and specific properties.
Deals
Contains information about deals, including id, value, and related contacts.
Email events
Records email events with details on sending, opens, and clicks.
Engagements: Calls
Includes call details such as id, dispositions, and related objects.
Engagements: Emails
Presents email details including id and related objects.
Engagements: Meetings
This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.
Engagements: Notes
Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.
Engagements: Tasks
Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.
Feedback Submissions
Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.
Leads
Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.
Line Items
Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.
Marketing Emails
Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.
Owners
Owners table contains fields such as id, name, email, and created_at, essential for user management.
Payments
Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.
Pipelines
Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.
Products
Table contains information about products, including fields such as id, name, price, and description.
Properties Metadata
Table presents metadata of properties, including fields such as name, type, and description.
Property History
Table logs changes to properties, with fields such as id, created_at, and previous_value.
Tickets
Table includes information about tickets, with fields such as id, status, priority, and created_at.
Sync data automatically — no code, no manual exports.
1
Connect Your Hubspot Account
Enter your Hubspot API credentials in Kondado to establish a direct connection to your CRM and marketing data. The platform will authenticate and display the available pipelines from your Hubspot instance.
2
Configure BigQuery Destination
Provide your BigQuery project and dataset details where the replicated data should be stored. Kondado will validate the connection to ensure proper write permissions for your Google Cloud environment.
3
Select Pipelines and Schedule
Choose which of the 24 available pipelines to replicate, such as Contacts, Deals, or Email Events, then set your preferred update frequency from every 5 minutes to daily. Once activated, Kondado will automatically begin replicating your selected Hubspot data to BigQuery on the schedule you defined.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending Hubspot data to BigQuery automatically
How does Kondado replicate Hubspot data to BigQuery?▼
Kondado connects directly to your Hubspot account using your API credentials and extracts data from selected pipelines. The platform then loads this information into your BigQuery dataset on your chosen schedule, maintaining data structure and relationships. This automated process requires no manual intervention once configured, ensuring your analytics warehouse stays current with your latest CRM and marketing activities.
What Hubspot pipelines are available for replication to BigQuery?▼
Kondado offers 24 distinct pipelines including Contacts, Companies, Deals, Email Events, and Engagements across calls, meetings, and tasks. You can also replicate Line Items, Products, Tickets, and Marketing Emails to support comprehensive revenue and service analytics. Each pipeline contains specific fields relevant to that data type, totaling over 805 available fields for analysis in your data warehouse.
How often does Hubspot data update in BigQuery?▼
You can configure updates to run every 5 minutes, 15 minutes, hourly, or daily depending on your business requirements and data freshness needs. The configurable schedule ensures your BigQuery dataset reflects recent Hubspot activities without overwhelming your API limits. Once set, the replication runs automatically, delivering fresh data for your reports and dashboards according to your specified timeline.
Can I combine Hubspot data with other sources in BigQuery?▼
Yes, once replicated to BigQuery, your Hubspot data can be joined with information from additional sources such as PostgreSQL, advertising platforms, or e-commerce systems. This consolidation enables cross-channel attribution analysis and unified customer views across marketing, sales, and support touchpoints. BigQuery's processing power handles complex joins between disparate datasets for comprehensive business intelligence.
What format does Hubspot data take when replicated to BigQuery?▼
Hubspot data arrives in BigQuery as structured datasets with preserved data types, including timestamps, strings, numerics, and nested JSON fields where applicable. The replication maintains the original schema relationships from your Hubspot account, allowing for straightforward SQL querying and joins. Each pipeline becomes a separate table in your designated BigQuery dataset, organized for immediate use in analytics and reporting workflows.
Do I need coding skills to send Hubspot data to BigQuery?▼
No coding is required to configure the replication, as Kondado provides a visual interface for selecting pipelines and setting schedules. While SQL knowledge helps when querying the data in BigQuery or creating reports in Looker Studio, the initial setup and ongoing automation operate through point-and-click configuration. Technical and non-technical users alike can manage the data flow without writing extraction scripts or API calls.
Can I replicate historical Hubspot data to BigQuery?▼
Yes, during initial setup you can specify how much historical data to backfill into your BigQuery warehouse, ranging from recent months to several years of historical records. The platform retrieves existing data before switching to your configured incremental schedule for ongoing updates. This ensures your analytics foundation includes sufficient historical context for trend analysis and year-over-year comparisons from day one.
How do I analyze Hubspot data once it is in BigQuery?▼
You can query the data directly using SQL in the BigQuery console or connect business intelligence tools like Power BI, Looker Studio, or Google Sheets to create visualizations and reports. Many users build custom attribution models, cohort analysis, and sales performance dashboards by joining Hubspot data with other business data. The data supports everything from executive summaries to granular operational reports across marketing, sales, and customer service metrics.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
