> ## 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.

<Frame caption="Click Superjoin to launch the sidebar in Google Sheets">
  <img src="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" alt="Superjoin button in Google Sheets toolbar" />
</Frame>

## 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.

<Frame caption="Sources section showing available data connections">
  <img src="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" alt="Sources section in Superjoin sidebar" />
</Frame>

<Frame caption="Select your connected HubSpot account">
  <img src="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" alt="HubSpot connection highlighted in sources list" />
</Frame>

## Open Data Preview

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

<Frame caption="Import into Google Sheets option">
  <img src="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" alt="Import into Google Sheets button highlighted" />
</Frame>

## 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.

<Frame caption="Object selection dropdown in Data Preview">
  <img src="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" alt="Objects dropdown showing available object types" />
</Frame>

<Frame caption="Deals object selected with data preview">
  <img src="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" alt="Preview of deals data after selecting Deals object" />
</Frame>

## 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.

<Frame caption="Add filter to refine your deal data">
  <img src="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" alt="Filter button in data preview" />
</Frame>

<Frame>
  <img src="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" alt="Filter selection interface" />
</Frame>

<Frame>
  <img src="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" alt="Deal Stage filter option" />
</Frame>

<Frame>
  <img src="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" alt="Setting filter to Appointment scheduled" />
</Frame>

<Frame caption="Filter applied showing only appointment scheduled deals">
  <img src="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" alt="Filtered data preview showing appointment scheduled deals" />
</Frame>

<Tip>Filtering before import keeps your Sheets focused and actionable.</Tip>

## 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.

<Frame caption="Review final configuration before importing">
  <img src="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" alt="Final data preview before import" />
</Frame>

<Frame caption="Name your sheet for easy identification">
  <img src="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" alt="Sheet name input showing Deals" />
</Frame>

<Info>
  Superjoin bypasses HubSpot's 10,000 record limit, allowing you to import up to
  200,000 records at once.
</Info>

<Frame caption="Import in progress showing deal data">
  <img src="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" alt="Google Sheet displaying imported HubSpot deals" />
</Frame>

## 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.

<Frame caption="Configure automatic refresh schedule">
  <img src="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" alt="Schedule refresh settings menu" />
</Frame>

<Frame caption="Schedule confirmed for daily updates at 6 AM">
  <img src="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" alt="Schedule confirmation showing daily updates at 6 AM" />
</Frame>

<Check>
  Your HubSpot deals are now synced to Google Sheets and will update
  automatically every morning.
</Check>
