Hubspot to Looker Studio: setup guide

Looker Studio is a powerful free tool to visualize and analyze your marketing and sales data. If you use HubSpot for CRM, marketing automation, and sales, connecting it to Looker Studio lets you centralize contacts, deals, pipelines, and campaign performance in one place.

There are two main ways to connect your HubSpot data to Looker Studio:

• Automatically, using a partner connector like Catchr.
• Manually, using Google Sheets as an intermediary.

Why connect HubSpot to Looker Studio

Connecting HubSpot to Looker Studio helps you analyze your funnel end-to-end, track revenue and pipeline health, and automate reporting. Instead of switching between HubSpot dashboards, spreadsheets, and BI tools, you can visualize everything in one interactive report.

With Looker Studio, you can:

• Monitor pipeline value, deal velocity, win rate, and MRR/ARR.
• Track lead generation, lifecycle stages, and campaign attribution.
• Combine HubSpot with Google Ads, Meta Ads, GA4, or revenue data for a complete growth view.
• Automate reporting and share live dashboards with teams and clients.

In short, connecting HubSpot to Looker Studio gives you a unified, real-time view of marketing and sales performance.

Method 1: Connect HubSpot to Looker Studio using Catchr (recommended)

For most teams, the automated connection is the most efficient and scalable solution. It uses the HubSpot API to sync your CRM and marketing data directly into Looker Studio.

How it works

Partner connectors like Catchr act as a bridge between HubSpot and Looker Studio. Once authorized, Catchr connects to your HubSpot portal and automatically imports contacts, companies, deals, activities, and marketing metrics into Looker Studio.

Your metrics and dimensions refresh daily, so reports stay up to date, no exports or manual updates required.

Steps

1. Create a new data source on Looker Studio
   • Go to the Looker Studio homepage.
   • Click on Create → Data source.

2. Search for Hubspot
   • In the search bar, type Hubspot.
   • From the list, select a certified connector such as Catchr.

3. Authorize your Catchr and Hubspot accounts in Looker Studio
   • Click Authorize to link your Catchr account with Looker Studio.
   • Then, authorize again to sign in to Hubspot and allow access to your accounts.

4. Choose your account(s)
   • Select one or multiple accounts to include in your report.
   • (Optional) Start from a prebuilt Looker Studio template to save time.

5. Click Create report
   • Click Create Report to finish the setup.
   • Your HubSpot data, including contacts, companies, deals, pipelines, and marketing metrics, will automatically load into Looker Studio and refresh daily.

Common Use Cases

Connecting HubSpot to Looker Studio allows you to track both marketing and sales in real time and build automated dashboards.

• Revenue teams monitor pipeline, forecast vs. target, win rate, and deal velocity.
• Marketing teams track lead generation, campaign ROI, and lifecycle progression.
• Agencies build multi-client, white-labeled dashboards with standardized KPIs.
• RevOps blend HubSpot with billing or product analytics to analyze LTV, churn, and cohort revenue.

To help you get started faster, Catchr provides ready-to-use Looker Studio template for HubSpot.

‍

Method 2: Connect HubSpot to Looker Studio using Google Sheets

If you prefer a free, manual approach, you can use Google Sheets as an intermediary between HubSpot and Looker Studio. This method is simple but requires regular exports or an external automation tool (like Zapier or Make) to refresh data automatically.

How it works

You’ll export HubSpot objects (e.g., Contacts, Deals, Companies, Campaigns) as CSV from HubSpot and import them into Google Sheets. Then, connect that spreadsheet to Looker Studio using the Google Sheets connector.

Steps

1. Export your HubSpot data to Google Sheets
   • From your HubSpot dashboard, go to CRM.
   • Select the data you want to export from the available categories (e.g., Contacts, Companies, or Deals).
   • Click Export, then confirm by clicking Export again in the next window.
   • The file will start downloading. You can track the export process and, once completed, click the notification “Your export X has been delivered” to download it. You will also receive the file by email.
   • Open the downloaded file and import it into Google Sheets.

2. Create a new data source in Looker Studio
   • Go to the Looker Studio homepage.
   • Click on Create → Data source.

3. Connect the Google Sheets connector
   • In the connector list, search for Google Sheets.
   • Select it and, if prompted, authorize access to your Google account.

4. Choose your Hubspot Google Sheets
   • Select the spreadsheet and worksheet containing your Hubspot export.
   • Click Connect to link your data to Looker Studio.

5. Create your Hubspot report
   • Click Create Report to start building your dashboard.

Which method should you choose?

If you want dashboards that automatically refresh and always reflect your latest HubSpot data, Catchr is the most reliable option, especially for agencies or multi-portal setups. Google Sheets remains a good alternative for one-off or manual reports.

FAQ: HubSpot and Looker Studio

Can I connect multiple HubSpot portals?

‍Yes. Catchr supports multiple HubSpot portals within a single Looker Studio report.

Are HubSpot data updates automatic?

‍Yes, with Catchr your data refreshes daily. Google Sheets, however, requires manual exports or automation tools.

Can I combine HubSpot with other platforms?

‍Absolutely. You can blend HubSpot with Google Ads, Meta Ads, GA4, or billing/product analytics for a complete funnel view.

What data can I pull from HubSpot?

‍You can access CRM and marketing data such as contacts, companies, deals, pipelines, line items, emails/campaigns, and engagement metrics. See Catchr’s documentation for the full Hubspot field list.

Is the Catchr HubSpot connector free?

‍Catchr offers a free trial to connect your HubSpot account to Looker Studio. After the trial, a paid plan is required to keep your data automatically synchronized and access advanced features.

Make HubSpot work with Looker Studio

Connecting HubSpot to Looker Studio helps you track your pipeline, analyze key KPIs, and make better, data-driven decisions. Whether you use the manual Google Sheets method or automate everything with Catchr, you’ll turn your HubSpot data into actionable insights that drive growth.