HubSpot to Google Sheets
Send HubSpot data to Google Sheets automatically
HubSpot
- Mammoth
Google Sheets
Deal Stage Amount Owner Brightline annual Closed won $18,400 Maya R. Kestrel Dental Contract sent $9,600 Sam O. Orchard Studio Qualified $4,200 Maya R. Fieldway Group Closed won $22,000 Lee T.
Shown on sample data.
Set up HubSpot to Google Sheets in three steps
- Step 1
Connect HubSpot
Sign in to HubSpot from Mammoth. There are no API keys to copy.
- DealsContactsCompaniesTicketsStep 2
Pick your fields
Tick the CRM tables and columns you want, or describe the data in plain words.
Updated
Step 3Send it to Google Sheets
Pick a new or existing spreadsheet and a tab. Mammoth writes the rows after every refresh.
Choose how Google Sheets updates
Your HubSpot data refreshes every day, or only when you ask. You can set a different schedule.
| Deal | Stage | Amount | Owner |
|---|---|---|---|
| Brightline annual | Closed won | $18,400 | Maya R. |
| Kestrel Dental | Contract sent | $9,600 | Sam O. |
| Orchard Studio | Qualified | $4,200 | Maya R. |
Clears the tab, then writes every row again.
Best for a current view, like this month's numbers.
| Deal | Stage | Amount | Owner |
|---|---|---|---|
| Brightline annual | Closed won | $18,400 | Maya R. |
| Kestrel Dental | Contract sent | $9,600 | Sam O. |
| Fieldway Group | Closed won | $22,000 | Lee T. |
Adds new rows under the ones already there.
Best for a running log, like results by week.
A spreadsheet holds up to 10 million cells. For bigger data, use a Live link or a CSV file.
Clean and combine your HubSpot data first
Mammoth gets the data ready before it goes to Google Sheets.
Add your other data
Join HubSpot with Salesforce, Google Ads, Shopify or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Days to close = Close date − Create dateAdd the columns you need
Work out days to close, deal age or quarter so they arrive ready to use.
What teams use HubSpot in Google Sheets for
Deal pipeline tracker
Open deals by stage and owner, current every morning.
Lead lists for the team
New contacts by source, added to the sheet as they arrive.
Commission tracking
Closed won deals by rep, ready for the monthly payout.
Ways to get HubSpot data into Google Sheets
Mammoth
For clean HubSpot data in a sheet, joined with your other sources.
- ✓Updates on a schedule
- ✓Clean the data before it reaches the sheet
- ✓Join Salesforce, ads or store data
- ✓Send the same data to Excel, Power BI or a warehouse
HubSpot's record export
For a one-off file of your records, as CSV or Excel.
- ✕Updates on a schedule
- ~Clean the data before it reaches the sheetBy hand
- ✕Join Salesforce, ads or store data
- ~Send the same data to Excel, Power BI or a warehouseDownload a file
Copy and paste by hand
For a quick look at a few records.
- ✕Updates on a schedule
- ~Clean the data before it reaches the sheetBy hand
- ~Join Salesforce, ads or store dataPasted in by hand
- ✕Send the same data to Excel, Power BI or a warehouse
Or turn the same data into a HubSpot dashboard
Describe the dashboard in one sentence and Mammoth builds it from your data.
The template: paste this into Mammoth
HubSpot deal pipeline: open pipeline value, deals won, revenue won, win rate, average deal size and deals created as KPIs, revenue won by month, open pipeline value by deal stage, and revenue won by deal owner

Common questions about HubSpot to Google Sheets
How do I connect HubSpot to Google Sheets?
Does Google Sheets update automatically?
Can I add new rows instead of overwriting the sheet?
Is there a size limit?
What do I need in HubSpot?
Step-by-step setup is in our docs for HubSpot and Google Sheets.
Keep Google Sheets up to date with HubSpot data.
Start free, connect HubSpot, and send it to Google Sheets.
- ✓ 14-day Pro trial
- ✓ No credit card
- ✓ Viewers always free