Set up and use the HubSpot connector for Google Sheets

Using the HubSpot for Sheets – CRM Connector, you can import data from Google Sheets into HubSpot and access the HubSpot side panel to easily view CRM records in real time.

Install the HubSpot for Sheets - CRM Connector 

To install the connector from the Google Marketplace:

1. Navigate to the HubSpot connector for Sheets in the Google Marketplace.
2. In the top right, click Install.
3. In the dialog box, log into your Google account.
4. Review the requested access permissions, then click Allow. Once installed, the add-in will show on all Google Sheets for the connected account. 

Connect the HubSpot for Sheets - CRM Connector to HubSpot

1. In a Google Sheet, click Extensions in the toolbar. 
2. Click HubSpot for Sheets - CRM Connector > Launch. 
3. In the dialog box, select your user and account. 
4. Click Connect to HubSpot, which will take you to Google to review data access details.
5. Review the requested access permissions, then click Allow. Once installed, the add-in will show on all Google Sheets for the connected account. 

Sync Google Sheet data to HubSpot 

1. In a Google Sheet, click Extensions in the toolbar. 
2. Click HubSpot for Sheets - CRM Connector > Launch. 
3. In the pop-up box, select the data you'd like to import: 
   • Enter a name for your import. 
   • In the Import section, select from the following import options: 
     • All rows: import every row in your file to HubSpot.
     • Specific range: import only a selected range (e.g., A2:F15, A17:F20).
   • Click the header row dropdown menu and select a header row in which each column header corresponds to a property in HubSpot. You can confirm if a default property already exists to match your header or create a custom property prior to importing. Learn more about property requirements.
     
     
4. Click Next: Prepare your data. 
5. In the table, review the sheet headings that'll be mapped to HubSpot properties.

   If a heading matches an existing HubSpot property, it'll be selected by default. If there’s no exact match, HubSpot’s Breeze AI will suggest a property based on the heading’s name and values. To view more details about a property, hover over its name.

6. To edit a mapping, under the HubSpot field name column, click the dropdown menu and select the HubSpot property you want to map. 
   
   
7. Click Next: Import contacts. 
8. Once imported, you'll be able to access HubSpot data in the right panel of your Google Sheet.