HubSpot and Google Sheets integration

Whalesync syncs HubSpot and Google Sheets both ways. Each tab you pick holds one HubSpot object, such as contacts, deals, or products, and a value typed into a row updates the record in HubSpot.

HubSpot
Google Sheets
Use cases

What you can do with HubSpot and Google Sheets

Event marketing

Turn the booth sign-up sheet into contacts

At the booth, the team types each visitor into a shared sheet, with the event's name in an Event column. Filter the mapping on that column, and every row becomes a HubSpot contact while the rest of your contacts stay out of the sheet. A visitor already in HubSpot gets no second record: HubSpot refuses the duplicate email, and the row shows up as a sync issue to check. As sales works the leads, their lead status fills in on the sheet.

Syncs Contacts
Each row is a HubSpot contact. Event is a custom HubSpot property the filter reads, and Lead status is HubSpot's own dropdown.
RevOps

Run the forecast from a pivot table

Sync HubSpot deals into a Deals tab, with stage, amount, and close date, and each deal's company linked to a row in a Companies tab. Build the pivot tables and charts on a tab of their own that reads from Deals, so the sync never writes over a formula. The Monday forecast then reads the pipeline as it is, with no export to refresh first.

Syncs DealsCompanies
Deal name, stage, amount, and close date come from HubSpot. A stage typed into the sheet has to match a stage in the deal's pipeline.
Finance

Keep the price list in a sheet

Finance already sets prices in a spreadsheet. Sync it with HubSpot's product library, and a new price typed into the sheet updates the product in HubSpot, so the library reps pick from carries the price finance set. A new row becomes a new product, with its SKU and unit cost.

Syncs Products
Each row is a product in HubSpot's product library. Name, SKU, unit price, and unit cost sync both ways.
CRM admins

Clean up company records in bulk

Sync companies into a sheet, filter it down to the rows with gaps, and fill them in from your research. Each cell you fix updates the company in HubSpot, and a city typed three ways becomes one with find and replace.

Syncs Companies
Each row is a HubSpot company and each column one of its properties, so a fix made in the sheet is a change to the company in HubSpot.
What syncs

Everything that syncs

Each card is something you can sync between HubSpot and Google Sheets.

  • HubSpot Contacts Two-way
  • HubSpot Companies Two-way
  • HubSpot Deals Two-way
  • HubSpot Tickets Two-way
  • HubSpot Tasks Two-way
  • HubSpot Notes Two-way
  • HubSpot Meetings Two-way
  • HubSpot Quotes Two-way
  • HubSpot Line Items Two-way
  • HubSpot Products Two-way
  • HubSpot Taxes Two-way
  • HubSpot Appointments Two-way
  • HubSpot Custom Objects Two-way
  • HubSpot Calls Into Google Sheets
  • HubSpot Emails Into Google Sheets
  • HubSpot Communications Into Google Sheets
  • Google Sheets All Tables Two-way
Live Export

Just need a copy of HubSpot in Google Sheets?

Live Export keeps a one-way copy of your HubSpot data in Google Sheets, on a schedule, for the reports, pivot tables, and dashboards that only read it. It's on every plan, with a record allowance of its own.

  • Two-way sync

    Best when your team works in both apps, and an edit in either belongs in the other.

    • Maps fields between tables you choose, in HubSpot and Google Sheets
    • Picks changes up by itself, with no schedule to set
    • Counts toward your plan's records in sync
  • Live Export

    Best when you only read HubSpot data in Google Sheets, and nothing you change there should go back.

    • Creates a tab for each HubSpot table you pick, in a new spreadsheet or one you already have
    • Runs daily, hourly, or every 10 minutes, depending on your plan, and whenever you click Run now
    • Writes only what changed on each run, over any edits to what it copied
    • Copies Contacts, Companies, Deals, Tickets, Line Items, Products, Quotes, Notes, Tasks, Emails, Calls, Meetings, Communications, Appointments, Services, Leads, and your custom objects
Step-by-step guide

How to sync Google Sheets to HubSpot in 5 minutes

Step 1: Create your Whalesync account

Sign up for Whalesync, click New sync, and choose HubSpot and Google Sheets as the two apps.

Step 2: Connect Google Sheets

Sign in with the Google account that can edit the spreadsheet, paste the spreadsheet's URL, and pick the tabs to sync with the Google Sheets connector. Each tab needs one header row in row 1, with no merged cells, and Whalesync reads a column's type from how its header cell is formatted, so format a price column as currency and a date column as a date, header included. Setup adds a Whalesync ID column at the left of each tab: leave it alone, and include it in any range you sort.

Step 3: Connect HubSpot

Authorize the HubSpot connector and choose the HubSpot account to sync. Whalesync suggests backing up HubSpot before the first sync. Any property a column will fill, such as an Event property for a sign-up sheet, has to exist in HubSpot first, because Whalesync can't create HubSpot properties.

Step 4: Map your tables and fields

Pair each tab with a HubSpot object: a sign-up tab with Contacts, an accounts tab with Companies, a pipeline tab with Deals, or a price list with Products. If a tab doesn't exist yet, Whalesync can create it with a column for each property. Whalesync's AI automapping pairs columns with HubSpot properties by their names and types when the mapping opens; check its pairs and map the rest by hand. A value in a dropdown column, such as Lead status or Deal stage, has to match the label HubSpot shows. To keep a deal's company, map the association to a link column pointing at the Companies tab.

Step 5: Turn on the sync

If the tab and HubSpot share records already, pick a match field, such as email for contacts or company domain for companies, and choose which app wins where a matched pair disagrees. Add a filter if the tab should hold only some records. Whalesync previews how many rows and records it will create on each side; then activate the sync.

Compare

3 ways to connect HubSpot and Google Sheets

  • Google Sheets Workflows for HubSpot

    Best when you have a Professional hub and only need HubSpot records copied into a sheet as they change.

    • Built by HubSpot: workflow actions add or update rows, from HubSpot to Sheets only
    • Workflows need a Professional or Enterprise hub (HubSpot)
    • Each action fills up to 20 cells in a row
  • Zapier

    Best when a new row should set off a chain of steps, such as creating a contact and posting to Slack.

  • Whalesync

    Best when people edit both the sheet and HubSpot, and each has to show the other's changes.

    • One sync covers contacts, companies, deals, and products, both ways
    • Associations become link columns between tabs
    • Priced by the rows in sync, with unlimited edits

Google Sheets Workflows for HubSpot and Zapier checked against their own pages in November 2026.

FAQ

Frequently asked questions

Does HubSpot integrate with Google Sheets?

Yes, in a few ways. HubSpot's own workflow actions send record data to a sheet, one way, on Professional and Enterprise hubs, and its HubSpot for Google Sheets extension imports a sheet into HubSpot. Zapier runs one-way automations between the two, and Whalesync keeps a tab and a HubSpot object in sync both ways.

Can I export HubSpot contacts to Google Sheets automatically?

Yes. Pair HubSpot Contacts with a tab, and Whalesync writes a row for each contact and keeps it current, adding rows as new contacts arrive. To sync only some of them, add a filter on a mapped property, such as lifecycle stage. If the sheet only reads them, Live Export copies Contacts one way instead, into a tab of its own, as often as every 10 minutes depending on your plan.

Can I update HubSpot records from a Google Sheet?

Yes. A change to a mapped cell updates the record in HubSpot. Dropdowns take HubSpot's option labels exactly: an unknown deal stage is stopped as a sync issue, but an unknown value in most other dropdowns clears the property, so copy the labels as HubSpot shows them.

Can I use formulas in a synced Google Sheet?

Yes, in columns Whalesync doesn't sync, and on tabs of their own. Whalesync writes only the cells whose values changed, so a formula outside the synced columns stays as it is. A formula in a synced column is replaced by a value when HubSpot sends a change to that field. Pivot tables and charts on another tab are never touched.

Is the HubSpot Google Sheets sync real-time?

HubSpot changes to standard contact, company, deal, and ticket properties reach the sheet within seconds, because HubSpot sends a webhook for them. Google Sheets sends none, so Whalesync rereads the sheet every few minutes, and an edit there arrives after the next read, which takes longer on a big sheet. HubSpot custom properties and products arrive on Whalesync's next pass over HubSpot.

Do HubSpot associations sync to Google Sheets?

Yes. An association, such as a deal's company, becomes a link column holding the IDs of rows in another tab, and that tab has to be in the sync too. When Whalesync creates the link column, it adds a lookup column beside it that shows the linked row's name.

More integrations

Other apps to connect

Connect your tools in minutes