Hubspot Google Sheets Integration

Sometimes you just want your deals, contacts or other CRM data synced to google sheets. SyncWith’s hubspot to google sheets integration makes this super simple.
Typical use cases:
  • I want my deals with value, close date and deal stage synced
  • I want deal name, value, pipeline and close dates synced
  • I want to sync all my CRM contacts to google sheets
  • Give me a list of the last 7d and 30d new deals - update it daily

What we’ll cover in this article

  • How to sync hubspot deals to google sheets
  • How to sync hubspot contacts to google sheets
  • How to sync hubspot tasks to google sheets
  • Common errors when connecting hubspot to google sheets
  • Example hubspot integration with google sheets

Don’t have SyncWith?

  • SyncWith is a Google Sheets Add On
  • SyncWith allows you to move data from any API into Google Sheets including SaaS tools like Hubspot, Salesforce, Mailchimp and 1000s more
  • ⭐️⭐️⭐️⭐️⭐️ Reviewed by hundreds of Google businesses
  • Check out our Google Workspace Listing and see why we’re the highest rated API add on with over 100,000 installs. Install today and get your data into Sheets in minutes.

How Does SyncWith Work?

notion image
 

Connect Hubspot Deals to Google Sheets

Select the Hubspot Deals Endpoint

To connect the Hubspot API to Google Sheets we’ll be using the SyncWith plugin. SyncWith makes it super easy to connect 1000s of APIs and databases to Google Sheets. It’s trusted by over 100,000 businesses and it’s easy to use. It’s free to try for business users.
Once you have the SyncWith addon installed you can search for hubspot and you’ll see all the endpoints available:
  • contacts
  • deals
  • owners
  • companies
  • forms
  • pieplines
  • etc.
In this case we’ll select HubSpot - CRM Deals.
notion image
After selecting the Hubspot Deals endpoint we must select what we want to do - list, create, read, update, etc.
In most use cases we simply want to export and sync a list of Hubspot Deals to Google Sheets, in this case we choose List
notion image
notion image

Authorize SyncWith’s Google Sheet Hubspot Integration

Now that we’ve selected the correct endpoint we’ll need to authorize SyncWith to access the data within Hubspot using either a hubspot user login or an API Key.
You’ll use OAuth to login, simply choose HubSpot login (OAuth) and use your Hubspot login.
notion image
You’ll be sent to Hubspot.com to sign inand select an account you wish to be authorized, you’ll see a prompt like the following:
notion image
You’ll be asked to confirm data privleges allowing SyncWith to pull the data from Hubspot and push it into Google Sheets:
notion image
Click Connect app to proceed.

Configuring Your Request to Get a List of Deals

While you can set query parameters to limit the results returned you don’t have to.
Your connection should look like this:
notion image
 
  • Connection given a name, eg Hubspot Deals
  • Your authentication details

Previewing the Results

  • Now we hit the preview button
notion image
  • The preview button will bring up a modal window that allows you to see the results hubspot sends back
notion image
 
  • We can see the JSON passed back that contains the properties of each deal, but this isn’t helpful
  • Click the + expand button to expand the properties so there is one per column
notion image
  • Now we have one row per property:
notion image
  • you can delete or rename the columns using the edit and garbage icons
notion image

Inserting the data into Google Sheets

  • Click insert to insert into a new sheet - the sheet will be given the same name as the connection name - eg Hubspot Deals
  • You can also choose Insert at selected cell - which will insert the data starting in the cell currently selected in the sheet
  • Now we have our Hubspot deals sync’d to our Google Sheet:
notion image
  • You can see in the screen shot that we didn’t edit the default column names so they’re a bit akward: properties.dealname, properties.dealstage - you can open the connection, preview and edit this if you’d like
  • There is a status row with a checkbox  ✅ that lets you manually refresh the data, but you can also set up a scheduled refresh by editing the connection scheduling, eg schedule daily:
notion image

Get the Template

  • Basic google spreadsheet that you can copy to pull deals, contacts and tasks
  • Hubspot to Google Sheets integration already setup
  • Click USE TEMPLATE
  • Install the add-on if not installed
  • Edit the connections to change the deals or contacts connection to use your hubspot account
    • Extensions > SyncWith > Launch Sidebar

Exporting Contacts to Google Sheets

We’re going to follow the same process we did with deals, the only major difference is we’ll use a different endpoint in the google sheets hubspot integration.
If you haven’t please take a look at the deals walkthrough above as it will show authorization and other things that we won’t recover here.

Select the Hubspot Contacts Endpoint

  • Launch the sidebar
  • Search for hubspot
  • Select the HubSPot - CRM Contacts endpoint
notion image
  • In this example we’re simply going to list all contacts so we’ll select List
notion image
  • You’ll need to authenticated to Hubspot if you haven’t already
  • The query parameters listed are options we can go right ahead and hit preview
notion image

Previewing the Results

  • The preview button will bring up a modal window that allows you to see the results hubspot sends back
notion image
 
  • We can see the JSON passed back that contains the properties of each contact, but this isn’t helpful - we really want one column per property - SyncWith lets you easily expand the JSON until it fits the format you like
  • Click the + expand button to expand the properties so there is one per column
notion image
  • Now we have one row per property:
notion image
  • you can delete or rename the columns using the edit and garbage icons
notion image
  • For example properties.hs_object_id is probably not important to you if you don’t need the ID of the contact, with some column deletions and name editing we get:
notion image

Inserting the data into Google Sheets

  • Click insert to insert into a new sheet - the sheet will be given the same name as the connection name - eg My Hubspot Contacts
  • You can also choose Insert at selected cell - which will insert the data starting in the cell currently selected in the sheet
  • Now we have our Hubspot contacts sync’d to our Google Sheet:
notion image
  • You can see in the screen shot that we’ve edited the the default column names and deleted a bunch of the columns we don’t need.
  • There is a status row with a checkbox  ✅ that lets you manually refresh the data, but you can also set up a scheduled refresh by editing the connection scheduling, eg sync your contacts daily:
notion image

Get the Template

  • Basic google sheet that you can copy to pull deals, contacts and tasks
  • Click USE TEMPLATE
  • Install the add-on if not installed
  • Edit the connections to change the deals or contacts connection to use your hubspot account
    • Extensions > SyncWith > Launch Sidebar

Exporting Hubspot Tasks to Google Sheets

We’re going to follow the same process we did with deals and contacts, the only major difference is we’ll use a different endpoint in the google sheets hubspot integration.
If you haven’t please take a look at the deals walkthrough above as it will show authorization and other things that we won’t recover here.

Select the Hubspot Tasks Endpoint

  1. Launch the sidebar
  1. Cut and paste the Tasks endpoint: https://api.hubapi.com/crm/v3/objects/tasks
  1. Add a query parameter called properties this is required to specify which fields from the task object we want, we need to provide them comma seperated
hs_timestamp,hubspot_owner_id,hs_task_subject,hs_task_status,hs_task_body,hs_task_priority,hs_task_type
notion image
  1. Hit Preview
  1. As we did above (for deals and contacts) expand the properties
  1. Rename the Columns / Delete the unwanted columns
  1. Click Insert
  1. You’ll now have a new sheet in the spreadsheet for all the tasks
notion image

Get the Template

  • Basic google sheet that you can copy to pull deals, contacts and tasks
  • Click USE TEMPLATE
  • Install the add-on if not installed
  • Edit the connections to change the deals or contacts connection to use your hubspot account
    • Extensions > SyncWith > Launch Sidebar

Looking to sync other types of Hubspot data into Google Sheets?

  • When searching for hubspot you’ll be able to see more endpoints you can utilize such as Company, Blog Posts, Products, Line Items, etc. Follow a similar approach as outlined above for deals and contacts should work
  • Let us know at support if you’re having issues with any other Hubspot endpoints and we’ll update this article or improve the user experience.

More Hubspot Content and Tutorials