HubSpot

Google Sheets + HubSpot Integration: Sync, Import & Automate CRM Data

Connect Google Sheets with HubSpot CRM using Sheet Director to automatically sync, import, and manage data between applications. You can pull data from HubSpot into Google Sheets, push updates back to HubSpot, or maintain real-time synchronization between both platforms.

This integration helps sales, marketing, and operations teams:

Automate CRM data updates
Eliminate manual data entry
Build real-time dashboards in Google Sheets

What is Sheet Director?

Sheet Director is a Google Workspace add-on that enables seamless bi-directional data flow between Google Sheets and HubSpot CRM, along with other business applications like QuickBooks, Zoho, and Google apps.

With Sheet Director, you can:

Query HubSpot data into Google Sheets
Post new records from Sheets to HubSpot
Synchronize data automatically across both Google Sheets and HubSpot.

This makes it a powerful tool for businesses looking to automate CRM workflows and centralize data management in spreadsheets.

It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on.

What is HubSpot, and why integrate it with Google Sheets?

HubSpot CRM is a widely used customer relationship management platform that helps businesses manage contacts, deals, marketing campaigns, and customer interactions efficiently.

By integrating HubSpot with Google Sheets, you can:

Export CRM data for reporting and analysis
Update contacts and deals in bulk
Create custom dashboards and reports
Automate repetitive sales and marketing workflows

This integration bridges the gap between structured CRM data and flexible spreadsheet analysis.

Jivrus Technologies products integrate seamlessly with a wide range of other platforms, including HubSpot.

Sheet Director, one of Jivrus Technologies product is now available in HubSpot Marketplace also

Visit Integration Mastery with HubSpot

HubSpot to Google Sheets: Use Case(s)

Pull HubSpot Data into Google Sheets - Query
Push Data from Google Sheets to HubSpot - Post
Synchronize Data between HubSpot and Google Sheets - Synchronize

HubSpot

Sheet Director

Google Sheets

Demo Video: How to integrate Google Sheets and HubSpot

How to Connect HubSpot to Google Sheets using Sheet Director

Choosing App and Service:

Select HubSpot as your application
Select service as Query / Post.

HubSpot Configuration:

Click the " Connect with HubSpot" button to authorize with HubSpot.

How to Query HubSpot Data into Google Sheets

If HubSpot is connected, the following screen successfully appears.
Select the required HubSpot entity (Contacts, Deals, etc.)
Choose the fields you want to extract.

Filters & Sorting

Configure Filter and Sort by to filter and sort the executed data.

Destination Settings:

Configure the destination settings to save the executed data.

Scheduler Settings:

Switch on Run automatically to execute services automatically in background.

Notification Settings:

Configure the Notification settings to setup the email templates and add attachments.

Sample Output

How to Upload Data from Google Sheets to HubSpot

You can push data from Google Sheets into HubSpot using the Post service:

Select the HubSpot entity (Contacts, Deals, etc.)
Choose either Apply Template or Setup Manually

Source Sheet

Choose the sheet that contains post records.
Enter the Start at cell value

(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)

Select the Status column
If status column is not there, simply click the +button to add the status header on your sheet(A status column will be created in Spreadsheet)
Select the Result column
If result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in Spreadsheet)

Mapping

After selecting the entity, it will ask for intelligent mapping
If you need to do intelligent mapping, click on yes
Intelligent mapping will map the matching fields automatically
You can do manual mapping by selecting the column drop-down
You can delete the field by clicking on the delete icon on top of each field map
You can't delete mandatory* fields

Click on execute will ask for confirmation
Click save to save the service

It will show number of records ready to post
Click post now to post the records on HubSpot

Sample Output

It will show the count of number of records posted successfully and failed to post.

Custom Properties Support

Does Sheet Director support HubSpot custom properties?

Yes, Sheet Director supports HubSpot custom properties for both Query and Post services, except for file upload data types.

You can:

Fetch specific custom properties into Google Sheets
Map custom fields when posting data
Create new properties directly in HubSpot

This allows businesses to work with custom CRM fields and advanced data structures.

To create your own custom property, go to the HubSpot dashboard and click Settings > Properties > Create Property

FAQ

How to Fix HubSpot Connection Error: “You don’t have permission”?

If you see this error: Couldn't complete the connection. You don’t have permission to connect this integration

It usually means your HubSpot account lacks required permissions.

Fix:

Ensure you have App Marketplace access
Request admin permissions if needed
Reconnect the integration

To resolve this error, the user connecting the integration must have App Marketplace permissions, which ensures they can connect and install apps from the HubSpot App Marketplace for your HubSpot account.

How to Synchronize Data Between HubSpot and Google Sheets

Synchronization ensures both systems stay updated automatically.

Select service as Synchronize.

Click on Connect with HubSpot to authorize with HubSpot.

Select the Entity required.
Mention the required Fields.

Select the required Fields.
Select the required Operator.
Select the required Value.
Mention the required Max results.

Synchronize settings:

Synchronization Keys:

The keys will be used for matching rows in Google Sheets with data in HubSpot.

Conflict Resolution:

When Synchronization happens, there could be a conflict of data between Google Sheets and HubSpot.

HubSpot Wins
Sheet Wins

HubSpot Wins: Latest data from HubSpot will be updated into Google Sheet.

Sheet Wins: Latest data from Google Sheet will be updated into HubSpot.

Note: The major requirement in synchronization is the synchronize keys. If any of the keys is not having a value in the Google Sheet then Sheet Director will create it first and then the service will be executed.

HubSpot Wins

Here, the HubSpot data is edited, and on execution, this data will be updated in the Google Sheet.

Choose the spreadsheet to store data.
Select the required cell value.
Select the Status column
If status column is not there, simply click the +button to add the status header on your sheet(A status column will be created in Spreadsheet)
Select the Result column
If result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in Spreadsheet)

Click Execute to execute the data.

The number of records that are ready to be synchronized will be shown.
It will also show all the data that are ready to be updated.
Also, the number of data that needs to be updated into HubSpot will also be updated.
Click on Sync Now to sync all the data and update it into Google Sheet.
Click on the Refresh icon to refresh the data.

If the data are synced successfully the following screen appears.
Click on Close to close the configuration.

Sample Output

The Status column in the Google Sheet shows the status of the data.
The newly updated data will be marked as Synced Successfully.
The old data that already exists will be marked as Already Synchronized.

Sheet Wins

Select Sheet Wins.
The latest updated data from Google Sheet will be updated into HubSpot.

Select the sheet to store output.
Select the Status column
If status column is not there, simply click the +button to add the status header on your sheet(A status column will be created in Spreadsheet)
Select the Result column
If result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in Spreadsheet)

Click Execute to execute the data.

The number of records that are ready to be synchronized will be shown.
It will also show all the data that are ready to be updated.
Also, the number of data that needs to be updated into HubSpot will also be updated.
Click on Sync Now to sync all the data and update it into Google Sheet.
Click on the Refresh icon to refresh the data.