Export HubSpot deals to Google Sheets
To export HubSpot deals to Google Sheets and keep them current, choose Deals in CRM Sheet Sync and tick your columns. You get one row per deal, updated about every minute.
Sync or export, feature by feature
| Feature |
| HubSpot export |
|---|---|---|
| How often it updates | About every minute, every 30 seconds on Pro | Only when you export again |
| Stays current by itself | Yes | No It is a copy of that moment |
| Where the deals go | A Google Sheet in your Drive | A file: CSV, XLS or XLSX |
| What it costs | Standard: €19 a month plus tax per HubSpot accountPro: €49 a month plus tax per HubSpot account | No extra tool |
| Limits | Up to 10 sheets, 50 on Pro | Up to 300 exports in 24 hours |
What goes in the sheet
Columns and limits
Column A is the record ID. Company shows the primary company. Contacts show their names, up to 10, then “+N more”.
Once your deals are in the sheet, count them by stage and owner: Build a pipeline report in Google Sheets with COUNTIFS and SUMIFS.
When a deal moves stage
Only that deal’s row changes.
In our test, five stage changes reached the sheet in 5 to 38 seconds. The sheet is not real time.
What else changes the sheet
A deleted or merged deal clears its row within about a minute. Every night we rebuild each sheet from HubSpot.
Keep only the deals you need
Add up to 5 conditions. A deal must match all of them.
Filter rules
For the amount or a date, you can keep deals where it has a value, or where it is empty. A deal with no stage is kept by “is none of”. A deal that stops matching is cleared at the next check.
What is not in this version
The free trial covers up to 2 sheets of up to 1,000 rows each, once per HubSpot account. Paid plans do not have this limit.
Set it up
Why choose CRM Sheet Sync
-
We don’t keep your CRM data
Your records pass through to the sheet. We store none of them.
-
Every property, no column limit
Add every HubSpot property you want as a column. We set no limit.
-
You know when it breaks
If a connection drops, the app says so, with a button to fix it.
7 days free. No card to start.