Skip to main content
This guide demonstrates how to import contacts from your HubSpot account into Google Sheets using Superjoin. This workflow is ideal for marketers, sales teams, and anyone who needs real-time HubSpot contact data in their spreadsheets. You’ll learn how to import, filter, and schedule automatic updates for your customer data.

​
Open the Superjoin Sidebar

Start by opening the Superjoin sidebar in Google Sheets by clicking the Superjoin icon in your Google Sheets interface.
Superjoin icon in Google Sheets toolbar

​
Locate Your HubSpot Source

Navigate to the Sources section in the sidebar. You’ll see your connected HubSpot account listed here.
Sources section showing connected HubSpot account

​
Open Data Preview

Click on your HubSpot source, then select Import into Google Sheets from the available options.
HubSpot source selected in Superjoin sidebar
Import into Google Sheets option highlighted

​
Select Data to Import

A data preview modal will open, allowing you to configure which HubSpot data to import. Select Contacts as the object type.
Object selection dropdown showing Contacts
Contacts object type selected in data preview
Next, add the specific columns you need. For this example, we’ll select:
  • Record ID
  • Create Date
  • Email Domain
Column selection interface showing available fields
Adding columns to import configuration
Record ID column selected
Create Date column selected
Email Domain column selected
All selected columns displayed in preview

​
Apply Filters (Optional)

To import only a subset of your contacts, configure filters. For example, to import only contacts with Gmail email addresses, set a filter for the email domain field to include “Gmail.”
Filter interface for email domain field
Selecting filter field
Choosing filter condition
Entering filter value Gmail
Filter applied showing Gmail contacts only

​
Review and Import Your Data

Review your selections in the data preview. When everything looks correct, click Import, enter a name for your sheet (e.g., “Gmail users”), and click Save and Import.
Data preview showing selected columns and filters
Import button highlighted in preview modal
Sheet name input dialog showing Gmail users
Click Cancel at any time if you need to abort the import process.

​
View Imported Data

After the import completes, a new sheet containing your filtered HubSpot contact data will appear in your Google Sheets file, ready for analysis or follow-ups.
Google Sheet displaying imported HubSpot contacts with Record ID, Create Date, and Email Domain columns
Your HubSpot contacts are now successfully imported into Google Sheets.

​
Automate with Scheduling (Optional)

Set up automatic refresh to keep your contact list current. Configure the sheet to update hourly, daily, weekly, or monthly. For example, schedule daily updates at 6:00 AM by adjusting the scheduling settings and clicking Schedule.
Schedule refresh settings menu
Refresh frequency options
Schedule confirmation showing daily updates at 6 AM
Scheduled refreshes ensure your spreadsheet always reflects the latest data from HubSpot without manual intervention.

​
Next Steps

You’ve successfully imported your HubSpot contacts into Google Sheets and configured optional automation for effortless updates. Your team now has access to current data without manual imports.

Connect More Sources

Integrate additional platforms like Salesforce or Stripe to centralize your data.

Explore Automation

Discover Superjoin’s workflow automation and reporting tools to boost productivity.