HubSpot to Google Sheets automatically
Automatically export HubSpot to Google Sheets: deals, contacts, companies, and custom properties. No code.
LightLead exports HubSpot deals to Google Sheets: name, amount, pipeline, stage, dates, and owner. Contacts and companies attach via associations, and any non-sensitive deal/contact/company property is available in the report.
Read more
What gets exported
- Deals: dealname, amount, pipeline, dealstage, closedate, hubspot_owner_id
- Contact: first name, last name, email, phone
- Company: name, domain
- Any deal/contact/company property except sensitive and highly_sensitive
- Multiple independent pipelines with stages sorted by displayOrder
Fields & metrics
- Entities: deal, contact, company (via associations)
- Fields: deal.hs_object_id, deal.dealname, deal.amount, deal.pipeline, deal.dealstage, deal.closedate
- Properties: all from /crm/properties except sensitive/highly_sensitive
- Metrics: deal.amount (currency)
Auto-refresh
Reports refresh on a schedule — hourly, daily, or weekly. New properties appear after the next discovery; deleted stages preserve history.
Example sheet
| Deal | Stage | Amount | Contact | Company | Closed |
|---|---|---|---|---|---|
| Deal 1 | Closed Won | $5,000 | Ivan P. | Acme | 2026-07-22 |
| Deal 2 | In Progress | $1,200 | Maria K. | Globex | — |
The values illustrate the report structure. Real data comes from your HubSpot portal.
Setup in 4 steps
- Start with LightLead and go to Integrations → CRM → HubSpot
- Authorize via OAuth
- LightLead discovers pipelines, stages, and properties
- Add a report: fields, filters, and schedule
Specifics & limitations
- Properties with dataSensitivity sensitive/highly_sensitive are excluded from reports
- Up to 100 records per search request; an exhausted window can return payload_too_large
- 429 and upstream_5xx errors retry automatically
- Pagination is cursor-based (after)
- Read-only: no writes, real-time, files, notes, or tasks
Who it fits
- HubSpot marketing and sales: pipelines and deal stages
- Integrators: client custom properties in reports
- E-commerce: linking deal amounts to ads
Pricing
LightLead starts free (1 Meta Ads account + Instagram Insights). CRM and Ads → CRM attribution start with the Solo plan at $19/month; multiple CRMs come with Agency plans from $49/month.
FAQ
How do I connect HubSpot to Google Sheets?
Start with LightLead, authorize via OAuth, and pick the source. Data appears in the sheet after you add a report.
Why are sensitive properties missing?
Properties with dataSensitivity sensitive/highly_sensitive are excluded from reports for data safety.
How do I export contacts and companies?
They attach to a deal via associations — no separate parallel fetch is needed.
How often do reports update?
On a schedule: hourly, daily, or weekly.
What does payload_too_large mean?
A very wide search window cannot fit in one response — narrow the period.
Full HubSpot connector reference: https://docs.lightlead.space/integrations/crm/hubspot/
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report