Skip to content

HubSpot to Google Sheets

Send HubSpot data to Google Sheets automatically

Connect HubSpot to Mammoth, pick the fields you want and send them to Google Sheets. Mammoth keeps Google Sheets up to date on a schedule, so nobody exports a report by hand.
  1. HubSpot
  2. Mammoth
  3. Google Sheets
    DealStageAmountOwner
    Brightline annualClosed won$18,400Maya R.
    Kestrel DentalContract sent$9,600Sam O.
    Orchard StudioQualified$4,200Maya R.
    Fieldway GroupClosed won$22,000Lee T.

Shown on sample data.

Set up HubSpot to Google Sheets in three steps

  1. Step 1

    Connect HubSpot

    Sign in to HubSpot from Mammoth. There are no API keys to copy.

  2. DealsContactsCompaniesTickets
    Step 2

    Pick your fields

    Tick the CRM tables and columns you want, or describe the data in plain words.

  3. Updated
    Step 3

    Send it to Google Sheets

    Pick a new or existing spreadsheet and a tab. Mammoth writes the rows after every refresh.

Start free and connect HubSpot14-day Pro trial · No credit card

Choose how Google Sheets updates

Your HubSpot data refreshes every day, or only when you ask. You can set a different schedule.

Google Sheets
DealStageAmountOwner
Brightline annualClosed won$18,400Maya R.
Kestrel DentalContract sent$9,600Sam O.
Orchard StudioQualified$4,200Maya R.
Replace

Clears the tab, then writes every row again.

Best for a current view, like this month's numbers.

Google Sheets
DealStageAmountOwner
Brightline annualClosed won$18,400Maya R.
Kestrel DentalContract sent$9,600Sam O.
Fieldway GroupClosed won$22,000Lee T.
Append

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.

Join

Add your other data

Join HubSpot with Salesforce, Google Ads, Shopify or 100+ other sources.

48 duplicate contacts mergedCountry names set to one format
Clean

Fix the data first

Remove duplicates, fill blanks and fix formats. The same fixes run every time.

Days to close = Close date − Create date
Calculate

Add 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

HubSpot dashboard built in Mammoth, showing Open pipeline, Deals won, Revenue won, Win rate, Average deal size, Deals created
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

See the free HubSpot dashboard template

Common questions about HubSpot to Google Sheets

How do I connect HubSpot to Google Sheets?
Connect HubSpot to Mammoth and pick the fields you want. Then export them to Google Sheets, and Mammoth keeps it up to date.
Does Google Sheets update automatically?
Yes. Your HubSpot data refreshes every day, or only when you ask. You can set a different schedule. After each refresh, Mammoth sends the new data to Google Sheets.
Can I add new rows instead of overwriting the sheet?
Yes. Choose Append and Mammoth adds rows under the data already in the tab. Replace clears the tab first.
Is there a size limit?
Google Sheets holds up to 10 million cells in a spreadsheet. For more than that, use a Live link or a CSV file.
What do I need in HubSpot?
A HubSpot user who can see the data you want. Mammoth reads the CRM tables that user can see.

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