Skip to main content
This guide shows you how to import HubSpot deals into Google Sheets using Superjoin and set up automatic updates to keep your data fresh. This workflow is perfect for sales and operations teams who need real-time deal tracking without manual exports. You’ll learn how to sync filtered HubSpot deal data into Sheets, bypass HubSpot’s 10,000 record limit (import up to 200,000 records), and automate daily data refreshes for always up-to-date reports.

​
Launch Superjoin in Google Sheets

Open your Google Sheet and click the Superjoin button to launch the assistant sidebar. This is your starting point for all data workflows with Superjoin.
Superjoin button in Google Sheets toolbar

Click Superjoin to launch the sidebar in Google Sheets

In the Superjoin sidebar, click the Sources section to view all available data connections. Locate your connected HubSpot account and click it to proceed.
Sources section in Superjoin sidebar

Sources section showing available data connections

HubSpot connection highlighted in sources list

Select your connected HubSpot account

​
Open Data Preview

Click the Import into Google Sheets action to open the Data Preview screen, where you can review and configure your import.
Import into Google Sheets button highlighted

Import into Google Sheets option

​
Select Objects and Review Preview

In the Data Preview, navigate to the Objects field and select Deals. Superjoin instantly displays a preview of your deals data so you can confirm what will be imported.
Objects dropdown showing available object types

Object selection dropdown in Data Preview

Preview of deals data after selecting Deals object

Deals object selected with data preview

​
Filter Deals (Optional)

To refine your import, click Filter. For example, you may want only deals in a specific stage or pipeline. Choose your desired criteria—such as Deal Stage and set it to Appointment scheduled in the Sales pipeline—then apply your filter to ensure only relevant deals are imported.
Filter button in data preview

Add filter to refine your deal data

Filter selection interface
Deal Stage filter option
Setting filter to Appointment scheduled
Filtered data preview showing appointment scheduled deals

Filter applied showing only appointment scheduled deals

Filtering before import keeps your Sheets focused and actionable.

​
Import Filtered Data

Once your filters are set, click Import. You’ll be prompted to name your sheet—enter something intuitive (such as “Deals”)—then click Save and Import. Superjoin will pull all matching deals from HubSpot and create a new tab in your Google Sheet.
Final data preview before import

Review final configuration before importing

Sheet name input showing Deals

Name your sheet for easy identification

Superjoin bypasses HubSpot’s 10,000 record limit, allowing you to import up to 200,000 records at once.
Google Sheet displaying imported HubSpot deals

Import in progress showing deal data

​
Automate Data Refresh with Scheduling

After import, you can automate refreshing your deal data on a schedule. Choose from hourly, daily, weekly, or monthly options. For example, to get updated deals every day at 6:00 AM, set your schedule to daily and select 6:00 AM, then click Schedule to activate automation.
Schedule refresh settings menu

Configure automatic refresh schedule

Schedule confirmation showing daily updates at 6 AM

Schedule confirmed for daily updates at 6 AM

Your HubSpot deals are now synced to Google Sheets and will update automatically every morning.
⌘I