> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Import Deals from HubSpot to Google Sheets

> Step-by-step guide to import deals from HubSpot into Google Sheets using Superjoin

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](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/fac62c23-4c58-463c-bd4a-fa5fc8b1eea6.png)

Click Superjoin to launch the sidebar in Google Sheets

## Navigate to Sources and Choose HubSpot

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](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/e937fd86-f5be-4889-b9c9-6c978766603b.png)

Sources section showing available data connections

![HubSpot connection highlighted in sources list](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/358ae7eb-8534-4f71-8fbf-b1517fc516a5.png)

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](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/f63887b1-9341-4f41-9d03-8bbe2059adfe.png)

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](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/207ad1c3-1ab0-4814-9155-c251d5a81aa1.png)

Object selection dropdown in Data Preview

![Preview of deals data after selecting Deals object](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/ca463632-37b4-43f6-9386-55e58027044b.png)

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](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/a4a14b57-bf57-47aa-94a1-a76691de8c19.png)

Add filter to refine your deal data

![Filter selection interface](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/b8dffda7-a6b1-4a25-a0a9-48b5eb3823da.png)

![Deal Stage filter option](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/4f302181-7469-4088-987c-03faa9bcb628.png)

![Setting filter to Appointment scheduled](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/a44a6478-012d-4d17-97f7-78c586100944.png)

![Filtered data preview showing appointment scheduled deals](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/ee58ad2b-e33e-4f0f-8b43-df2da57e419a.png)

Filter applied showing only appointment scheduled deals

> [!TIP]
>
> 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](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/a0536ef5-ee76-4163-8fa5-df63792d9734.png)

Review final configuration before importing

![Sheet name input showing Deals](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/0494872f-1070-4bf8-b94b-540db5bd8fc1.png)

Name your sheet for easy identification

> [!NOTE]
>
> 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](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/d3cb8cb8-4c05-439a-bfbe-9215958ed6a5.png)

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](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/c7f362dd-0707-4f4c-ad8f-aab3be745dce.png)

Configure automatic refresh schedule

![Schedule confirmation showing daily updates at 6 AM](https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/e7471260-5565-4d1e-9276-f7c22acf94fa/985c0ae6-647d-4e70-a1e3-af05aefabb5b/images/6e906a1a-1001-46ab-a977-5d70e10c3c3a.png)

Schedule confirmed for daily updates at 6 AM

> [!TIP]
>
> Your HubSpot deals are now synced to Google Sheets and will update
> automatically every morning.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.