HubSpot integration for Google Sheets

Trusted by +1,400 marketers

Import all your HubSpot data

All the fields from HubSpot CRM & Marketing hourly, daily, weekly.

Contacts

Emails, phone, stage, owner

Deals

Deal Stage, Owner, Source

Calls

Call duration, body, outcome

Campaigns

Campaign name, opens, open rate, clicks

Analytics

Pageviews, form views, form submissions

Company

Name, Source, Size

Visualize +700 fields

+200 metrics

+500 dimensions

Includes custom fields

How to connect HubSpot data to Google Sheets

Set up once, and let your data be refreshed everyday

To integrate HubSpot data into Google Sheets, follow these steps: 

  • Step 1: Install the Google Sheets add-on.
  • Step 2: Connect your HubSpot accounts
  • Step 3: Set up a query defining accounts, date range, metrics, and dimensions. 
  • Step 4: Save your queries and schedule data refreshes hourly, weekly, or daily.
    Complete tutorial: Import HubSpot data on Google Sheets.

Blend your cross-channel data

to get accurate marketing KPIs and a single source of truth.

Blend HubSpot with GA4

Map your funnel from traffic acquisition through conversion by matching GA4 and HubSpot

Get CAC, CPA accurately

Blend your contacts and deals data with your ad spend to truly know your conversion and the cost to acquire them

Clean and tag

Your content, campaign names, fix your UTMs, and solve annoying data discrepancies fast

Save your contacts on Sheets

Back up your CRM data on Google Sheets and blend it with other data sources

Monitor your HubSpot performance

To reach your goals, align your team, and tell when things are working or not.

Set alerts and notifications

connect with Zapier or Make.com to send email or Slack alerts

Visualize your funnel

Blend PPC, CRM, OR GA4 data togehter

Filter and segment

by ad account, client, campaign, audience

Set and visualize goals

By adding columns to track progress towards objectives

Share and present reports and unlock AI

to influence your team or clients

Connect to Google Slides, Canva, or Graphy

For beautiful presentations with real-time data

Sync with Google Looker Studio or Power BI

and present your data on interactive dashboards, without the stability/speed limitations of connectors

Let AI give insights from your data

Use Open AI or Bard to give you analysis summaries

How Porter is different

Unlimited, free support via chat, email, and calls

We hire marketers to do customer support or book calls with our founders to personally:

  • Set up or fix reports
  • Train you (and your team) on Looker Studio
  • Give you recommendations

+100 free templates and tutorials

Learn everything about marketing reporting and how to win with your marketing data—or nothing, with templates.

Simple, fair pricing

  • Only pay for accounts connected to your reports 
  • 14-day 100% refund + keep the service free*  
  • Free custom reporting service, training, and premium templates for annual plans

Unsolicited, actual customers’ words

Porter makes your marketing team faster

Speed is doing the right things fast. Make it your competitive advantage with no-code data.