Integrates Google Sheets with HubSpot

Connect your Google Spreadsheets directly to HubSpot through secure OAuth protocol and HubSpot API

View Live HubSpot Data in Google Sheets

Export Companies, Deals, Contacts, Owners, Blogs, Subscriptions, etc.

Update & Import Data into HubSpot

Update/Insert your Contacts, Companies, Deals right from Google Sheets and sync with Hubspot

Share & Collaborate in Google Drive

Easily share spreadsheets in Google Drive. Your non-HubSpot users can see live data! Work as a team on a spreadsheet and track changes.

Design Dashboards

Create powerful reports and charts with your live HubSpot data in Google Sheets. Or connect your Google Sheets to Google Data Studio to design beautiful and interactive dashboards!

Publish Charts

Publish/Embed charts on your Website so your clients can see live reports! Read more>>


    

How to sign into HubSpot

Open Google Sheets -> Go to Add-ons -> G-Accon for HubSpot -> HubSpot Sign In

Upon pressing "Connect to HubSpot" button, you will be redirected to HubSpot.com for authorization. Please select organization if you have access to multiple organizations and press button "Allow access for 30 mins".

You should be redirected back to Google Sheets and see page with "You've been successfully authenticated with HubSpot.com."


Getting data from HubSpot

Upon logged in, go to Add-ons -> G-Accon for HubSpot -> Get HubSpot Data, select the table and the fields that you would like to export into Google Sheets. You could also select or unselect all of the fields. Then simply press the "Execute" red button.


Additional Settings

You can add some optional pull settings for generating the HubSpot data. For example, indicate the Start Cell Address, retrieve headers, generate data on a new sheet, enforce pick list values and create a Data Table around pulled data.


How to filter your report data

To add specific filters to your HubSpot data, select the "Filter By Field" or "Filter By IDs" option and then add some filter values.


Ordering results

Depending on the content of your data, you might want to order it in particular way. To add the "Order Results By" option, select the required field you want to sort by and then ascending or descending type.