Step-by-Step Walkthrough: How to connect HubSpot to Google Sheets?

Here’s a step-by-step overview of how to connect HubSpot to Google Sheets using StackIt’s new connector.

Step 1: Click Extensions from the Google Sheets menu. Select Add-ons and choose to Get Add-ons. This will bring you to the Google Workspace Marketplace.

Step 2: Look for StackIt in the Google Marketplace pop-up window and install the app by following the prompts.

Step 3: Once you are on Google Sheets, go to the Extensions tab, you will see StackIt there. Launch StackIt from there.
If StackIt is not visible, wait for 10 seconds for Google Sheets to load completely.

You should see StackIt running as a Google Sheets side panel on the right side of your screen. Click on "Connect your first source"

Step 4: Select HubSpot from the list of data sources.

Step 5: Go through all the directions and prompts to connect your HubSpot account to Google Sheets.

Step 6: Now select the objects from the list you want to import from. Let's say we want Deals data.

Step 7: Next, select the fields to add before importing HubSpot data and visually preview your data before importing.

Step 8: When you click Import, the data you want to export from HubSpot should auto-populate your Google spreadsheet like this:

StackIt lets you refresh your imported data instantly with one click or set it to auto-refresh on a pre-set schedule.This way, you won’t need to manually update your HubSpot data in Google Sheets to reflect changes from the source.