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.
What you can do with HubSpot and Google Sheets
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.
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.
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.
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.
Everything that syncs
Each card is something you can sync between HubSpot and Google Sheets.
-
Contacts Two-way
-
Companies Two-way
-
Deals Two-way
-
Tickets Two-way
-
Tasks Two-way
-
Notes Two-way
-
Meetings Two-way
-
Quotes Two-way
-
Line Items Two-way
-
Products Two-way
-
Taxes Two-way
-
Appointments Two-way
-
Custom Objects Two-way
-
Calls Into Google Sheets
-
Emails Into Google Sheets
-
Communications Into Google Sheets
-
All Tables Two-way
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
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.
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.
- Triggers on a new or updated spreadsheet row
- Moves data one way per Zap; Zapier says it doesn't support two-way syncing
- The free plan allows two-step Zaps and 100 tasks a month (Zapier)
-
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.
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.