Import Companies from HubSpot to Google Sheets

This guide walks you through importing company data from HubSpot directly into Google Sheets using Superjoin. This workflow is perfect for marketing and sales teams who need up-to-date HubSpot company records in their spreadsheets for reporting, analysis, or automation—without any manual CSV exports or record limits. By the end, you’ll have a scheduled report in Sheets that stays synced with your HubSpot Companies data, filtered exactly as you need.

Open Superjoin and Navigate to Sources

Start by opening the Superjoin add-on in your Google Sheets. In the sidebar, navigate to the Sources section where you manage all your data connections—like HubSpot, Salesforce, or Stripe.

Launch Superjoin sidebar in Google Sheets

Sources section for managing data connections

Choose Your HubSpot Data Source

From the list of connected sources, select your active HubSpot connection. Once selected, click Import into Google Sheets to begin the data import process.

HubSpot source highlighted in sources list

Select your connected HubSpot source

Import into Google Sheets button highlighted

Click Import into Google Sheets to proceed

If you don’t see your HubSpot source, you may need to connect it first through the Superjoin setup.

Preview and Configure Your Data

A Data Preview pane appears, allowing you to pick which data object you want, choose specific fields to import, and add filters to narrow down your results. Select the object Companies, then add the Record ID field to ensure you include unique identifiers for each company.

Select Companies as the object type

Record ID field added to import configuration

Only select the fields you need to keep your sheet clean and maintain fast performance.

Apply Filters to Refine Your Import

Switch to the Filter tab to set up custom filters. For example, you can import only companies added in the last 120 days by filtering on the Create date field with the condition “in the last 120 days.” Apply your filter to preview the exact rows Superjoin will import.

Filter configuration for last 120 days

Once ready, click Apply Filter to lock in your criteria.

Filtered preview showing companies from last 120 days

Filter applied showing filtered company data

Import and Name Your Data

Click Import to start pulling the filtered companies data into your spreadsheet. Give the import a descriptive name, such as “companies last 120 days,” so you can easily identify it later.

Review configuration before import

Sheet name input showing companies last 120 days

Name your import for easy identification

Once you’ve named it, click Save.

Save to begin import process

Superjoin bypasses HubSpot’s usual 10,000 record limit, allowing you to import up to 200,000 company records at once.

If you need to stop the import at any time, simply click Cancel import.

Google Sheet populated with filtered HubSpot company data

Import complete showing company data in Google Sheets

Set Up Automatic Refresh Scheduling

To keep your report constantly updated, use Superjoin’s scheduling feature. You can refresh data hourly, daily, weekly, or monthly depending on your needs. For example, to update your company report every day at 6:00 AM, select daily and choose 6:00 AM as the time, then click Schedule to activate auto-refresh.