How to Connect HubSpot to Google Sheets – Query CRM Data with SQL

See everything Query Streams can do beyond this guide Get Started Free

Supports

+more

Live Data

Replace exports with on-demand SQL

Excel Sheets

BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova

Database REST API

One key per partner. No credentials shared.

Build an API

+more

Automation

Scheduled sync to 6+ platforms

Explore

+more

API to SQL

Query APIs with SQL, no code

Explore

+more

AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams transforms your HubSpot CRM into SQL-queryable tables, letting you import live contacts, companies, deals, tickets, and pipeline data directly into Google Sheets. No API coding, no manual exports—just write SQL and get real-time CRM analytics in your spreadsheet. Sign up free at QueryStreams.com and start querying your HubSpot account in minutes.

What HubSpot Data Can You Access?

Query Streams syncs your HubSpot API data to an encrypted local cache, exposing it as SQL-queryable tables. Every table includes a raw_data JSON column with the complete API response — including all custom properties.

Prerequisites

Setup Guide

Step 1: Install the Query Streams Network Agent

1. Log in to my.querystreams.com and go to Network Agents
2. Click Download Agent and run the installer
3. The agent installs as a Windows service and connects automatically
4. Your agent appears as Online in the portal within 30 seconds

Step 2: Create a HubSpot Private App

Private Apps give you a simple access token — no OAuth flow, no browser redirects, no refresh token rotation.

1. Log in to your HubSpot account
2. Click the gear icon → Integrations → Private Apps
3. Click Create a private app and give it a name (e.g., “Query Streams”)
4. Go to the Scopes tab and enable: crm.objects.contacts.read, crm.objects.companies.read, crm.objects.deals.read, crm.objects.owners.read, tickets, e-commerce
5. Click Create app, then Show token and copy the pat-xxx token

Step 3: Add the HubSpot Connector

1. Open the Network Agent interface at http://localhost:1823
2. Click Add Connection → select HubSpot
3. Paste your Private App Access Token (pat-xxx)
4. Click Test Connection — Query Streams validates your token and displays your HubSpot portal ID
5. Click Next — when prompted, keep Install Query Library queries enabled to get 20–50 pre-built HubSpot queries
6. Click Save — the initial sync starts immediately

Step 4: Configure Your Sync Schedule

All HubSpot tables sync automatically. Adjust frequencies per table based on how time-sensitive the data is:

Step 5: Install the Google Sheets Add-on and Run Queries

1. Open Google Sheets → Extensions → Add-ons → Get add-ons
2. Search for “Query Streams” and click Install
3. Grant the required permissions
4. Click Extensions → Query Streams → Open to launch the sidebar
5. Sign in with your Query Streams account
6. Click Saved Queries → open the HubSpot folder — pre-built queries are organized by Pipeline, Contacts, Companies, Sales, and Support
7. Select a query, adjust any filters, and click Run — live HubSpot data populates the sheet

Example HubSpot SQL Queries

Write custom queries in the Query Builder at my.querystreams.com and run them directly from Google Sheets.

SELECT
    p.label            AS pipeline,
    ps.label           AS stage,
    COUNT(d.id)        AS deal_count,
    SUM(d.amount)      AS total_value,
    AVG(d.amount)      AS avg_deal_size
FROM hubspot.deals d
JOIN hubspot.pipelines p       ON d.pipeline  = p.id
JOIN hubspot.pipeline_stages ps ON d.dealstage = ps.id
WHERE d.closedate >= CURRENT_DATE
  AND d.closedate <= CURRENT_DATE + INTERVAL '90 days'
GROUP BY p.label, ps.label, ps.display_order
ORDER BY ps.display_order;

SELECT
    o.first_name || ' ' || o.last_name AS rep,
    COUNT(CASE WHEN json_extract_string(d.raw_data, '$.properties.hs_is_closed_won') = 'true' THEN 1 END) AS won,
    COUNT(CASE WHEN json_extract_string(d.raw_data, '$.properties.hs_is_closed') = 'true'
               AND json_extract_string(d.raw_data, '$.properties.hs_is_closed_won') = 'false' THEN 1 END) AS lost,
    ROUND(
        COUNT(CASE WHEN json_extract_string(d.raw_data, '$.properties.hs_is_closed_won') = 'true' THEN 1 END)::DECIMAL /
        NULLIF(COUNT(CASE WHEN json_extract_string(d.raw_data, '$.properties.hs_is_closed') = 'true' THEN 1 END), 0) * 100, 1
    ) AS win_rate_pct
FROM hubspot.deals d
JOIN hubspot.owners o ON d.hubspot_owner_id = o.id
WHERE d.updated_at >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY o.id, o.first_name, o.last_name
ORDER BY win_rate_pct DESC;

SELECT
    lifecyclestage,
    COUNT(*)                                                    AS contact_count,
    ROUND(COUNT(*)::DECIMAL / SUM(COUNT(*)) OVER () * 100, 1)  AS pct
FROM hubspot.contacts
WHERE lifecyclestage IS NOT NULL
GROUP BY lifecyclestage
ORDER BY
    CASE lifecyclestage
        WHEN 'subscriber'              THEN 1
        WHEN 'lead'                    THEN 2
        WHEN 'marketingqualifiedlead'  THEN 3
        WHEN 'salesqualifiedlead'      THEN 4
        WHEN 'opportunity'             THEN 5
        WHEN 'customer'                THEN 6
        ELSE 99
    END;

Share HubSpot Reports Without Sharing Credentials

Frequently Asked Questions

Related Guides

Category: API Connectors

Tags: HubSpot, Google Sheets, Google Sheets Add-on, CRM Data, HubSpot API, SQL Queries, Live Data, Contacts, Companies, Deals, Tickets, Pipeline, Sales Analytics, Query Streams

Meta Description: Connect HubSpot to Google Sheets with Query Streams. Import live contacts, companies, deals, and pipeline data using SQL queries. No API coding required.