Getting your page ready

Getting your page ready...

0%

Thanks for visiting PipelineSync.

Home Solutions Pricing Integrations Resources About Book a free consultation

allentrinidad@pipelinesync.net

INTEGRATIONS • 7 MIN

HubSpot Data in Looker Studio: Your Options

For teams reporting on HubSpot in Google's BI tool, now called Data Studio again: the routes that work, from partner connectors to BigQuery and Sheets, and the limits that decide which one fits.

By the PipelineSync team Updated

PipelineSync field guide

How do you connect HubSpot to Looker Studio?

Through a partner connector or a data store in between, because neither Google nor HubSpot builds a HubSpot connector. Google's gallery lists third-party HubSpot connectors. Otherwise, send HubSpot data to BigQuery, on Data Hub Enterprise, or to Google Sheets, and connect those with Google's own connectors. Google renamed Looker Studio back to Data Studio in April 2026.

This guide follows Google's and HubSpot's documentation as of October 2026. HubSpot also has an unrelated feature called Data Studio for datasets, so in this guide Data Studio means Google's reporting tool unless we say otherwise.

Which route should you use for HubSpot reporting?

For a few marketing or sales reports, a partner connector is quickest, but it's a third-party service Google doesn't support. For governed, high-volume reporting, sync HubSpot to BigQuery and report from there. For small, simple feeds, write rows to Google Sheets with HubSpot workflows. Check first whether HubSpot's own dashboards can answer the question.

RouteNeeds, October 2026Good for
Partner connectorA third-party subscriptionQuick marketing and sales reports
BigQueryData Hub Enterprise (beta)Large, joined, governed data
Snowflake data shareData Hub EnterpriseTeams already on Snowflake
Google SheetsProfessional or Enterprise workflowsSmall, event-based feeds
HubSpot dashboardsYour current planMost CRM reporting

How does the BigQuery route work?

HubSpot's BigQuery integration syncs CRM data to your BigQuery project, and back if you choose. It needs Data Hub Enterprise and a Super Admin to install, and it was in beta in October 2026. Syncs run once, every six or 12 hours, daily, weekly or monthly. Then add BigQuery as a source in Data Studio and build reports.

  1. 01 HubSpotCRM data
  2. 02 BigQuery syncData Hub Enterprise
  3. 03 ModelViews and joins
  4. 04 Data StudioGoogle's connector
  5. 05 ReportRefreshed on schedule
The warehouse route. Each step is described above.

Sensitive data can't be synced to BigQuery. Google's BigQuery connector refreshes reports about every 12 hours by default.

What limits affect HubSpot reports in Looker Studio?

Connectors that read HubSpot's API share its limits: Marketplace apps get 110 requests every 10 seconds per account, and CRM search allows five requests a second and 10,000 results per query, which can cut off large reports. Data Studio caches data, so reports aren't live. Sheets fed by workflows can't exceed five million cells and may duplicate rows.

To show a finished report inside HubSpot, embed it on a dashboard with its embed code, on Professional or Enterprise hubs or Data Hub Professional; viewers can't refresh embedded data themselves.

Not sure which reporting route fits? Bring your reporting needs to a free 30-minute call and we will compare HubSpot dashboards, connectors and BigQuery.

HubSpot Looker Studio checklist

✓
HubSpot dashboards ruled out
✓
Route chosen
✓
Connector vendor reviewed
✓
Data volume vs API limits
✓
Refresh schedule agreed
✓
Sensitive data excluded
✓
Definitions match HubSpot
✓
Access controlled
✓
Report owner named
✓
Embedded in HubSpot if useful

Key takeaway: There's no first-party HubSpot connector for Looker Studio, now Data Studio. Use a partner connector for quick reports, BigQuery for serious reporting, and HubSpot's own dashboards wherever they're enough.

Frequently asked questions

Is there a HubSpot connector for Looker Studio?

Not from Google or HubSpot, when we checked in October 2026. Google's connector gallery listed many partner connectors for HubSpot from third-party vendors, which Google doesn't support. Alternatively, send HubSpot data to BigQuery or Google Sheets, which have Google-built connectors.

Is Looker Studio now called Data Studio?

Yes. Google renamed Looker Studio back to Data Studio in April 2026, and lookerstudio.google.com redirects to the new address. HubSpot also has its own, unrelated feature called Data Studio for building datasets, so check which one a guide or setting means.

How do you get HubSpot data into BigQuery?

HubSpot's BigQuery integration, in beta when we checked in October 2026, syncs data both ways and needs Data Hub Enterprise; a Super Admin installs it. Syncs to BigQuery can run once, every six or 12 hours, daily, weekly or monthly, and sensitive data can't be synced. Then connect BigQuery to Looker Studio.

Can you show a Looker Studio report in HubSpot?

Yes. On Marketing, Sales, Service or Content Hub Professional or Enterprise, or Data Hub Professional, you can embed external content such as a published Looker Studio report on a HubSpot dashboard using its embed code. Viewers can't manually refresh data in an embedded report.

What limits affect HubSpot reporting in Looker Studio?

HubSpot's API limits apply to connectors that read it: 110 requests every 10 seconds for Marketplace apps, and five requests a second for CRM search, with at most 10,000 results per search. Looker Studio caches data, for example about every 12 hours for BigQuery by default, so reports aren't live.

Sources

HubSpot documentation behind the feature and tier notes above, checked October 2026. HubSpot changes features and tiers often, so check your own portal too.