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 CRM Sheet Sync 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

ABCD IDDeal NameDeal StageDeal owner 101RenewalQualified To BuyDana Whitfield102UpgradeClosed WonSam Okafor103PilotContract SentLee Marchetti Updated within about a minute
Example, made-up values
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.

Before 103PilotQualified To BuyLee Marchetti Within about a minute After 103PilotContract SentLee Marchetti

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.

Pipeline is any of Sales Pipeline and Owner is any of Dana Whitfield and Deal Stage is none of Closed Won, Closed Lost
Example conditions
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

Filter by amountor date range Tickets andline items Custom objects HubSpot reports Write backto HubSpot Fill a sheet youalready have

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

1 Sign in withGoogle 2 ConnectHubSpot 3 Choose Dealsand columns

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.