HubSpot

Sync contacts, companies, and deals from your CRM.

Configuration

HubSpot uses OAuth for authentication. No API key needed.

Click "Add Connection" and select HubSpot
Enter a name for your connection
Click "Connect with HubSpot"
Authorize rawquery in the HubSpot popup
You're connected!

Synced Tables

The schema name is the connection name you choose when creating the connection. For example, if you name your connection "crm":

Table	Description
your_name.contacts	People in your CRM
your_name.companies	Company records
your_name.deals	Sales pipeline deals

Example Queries

Contacts by Lifecycle Stage

sql

SELECT
  lifecyclestage,
  COUNT(*) AS count
FROM crm.contacts
GROUP BY lifecyclestage
ORDER BY count DESC

SELECT
  lifecyclestage,
  COUNT(*) AS count
FROM crm.contacts
GROUP BY lifecyclestage
ORDER BY count DESC

Pipeline Value by Stage

sql

SELECT
  dealstage,
  COUNT(*) AS deal_count,
  SUM(amount) AS total_value
FROM crm.deals
WHERE hs_is_closed = false
GROUP BY dealstage
ORDER BY total_value DESC

SELECT
  dealstage,
  COUNT(*) AS deal_count,
  SUM(amount) AS total_value
FROM crm.deals
WHERE hs_is_closed = false
GROUP BY dealstage
ORDER BY total_value DESC

Join Contacts with Companies

sql

SELECT
  c.email,
  c.firstname,
  c.lastname,
  co.name AS company_name,
  co.industry
FROM crm.contacts c
JOIN crm.companies co ON c.associatedcompanyid = co.id
WHERE co.industry = 'Technology'

SELECT
  c.email,
  c.firstname,
  c.lastname,
  co.name AS company_name,
  co.industry
FROM crm.contacts c
JOIN crm.companies co ON c.associatedcompanyid = co.id
WHERE co.industry = 'Technology'