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

# Updating Contacts in HubSpot with Superjoin

> Step-by-step guide to update contacts from Google Sheets into HubSpot using Superjoin

<Info>
  Bulk update HubSpot contacts directly from Google Sheets with Superjoin. Ideal for marketing, sales, and ops teams to keep CRM data accurate—without manual entry.
</Info>

## What you'll achieve

* Update existing HubSpot contacts by syncing data from your Google Sheet
* Automatically map and export fields, including Record IDs and emails
* Monitor row-by-row update results inside your spreadsheet

***

## Prerequisites

<Check>
  * Your sheet contains a unique identifier per contact: Record ID or email
  * Superjoin is installed and connected to HubSpot
</Check>

***

## Step-by-step

<Steps titleSize="h2">
  <Step title="Prepare contact data with Record ID or email">
    To update contacts, include at least the <b>Record ID</b> or <b>email</b> in your sheet. If you import via Superjoin, add the <b>Record ID</b> field for accurate matching.

    <Frame>
      <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/af5b626e-b71f-4677-bac7-778b2de97a63.png" />

      <Caption>Include a column for Record ID or email in your Google Sheet</Caption>
    </Frame>

    <Tip>When importing from HubSpot, add Record ID in the data source dialog so Superjoin can uniquely identify contacts.</Tip>
  </Step>

  <Step title="Set up an Update query">
    Create a query to export updates from your sheet to HubSpot.

    <Steps>
      <Step title="Open Superjoin Queries">
        Go to <b>Queries</b> in the Superjoin sidebar.

        <Frame>
          <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/dbbb94e8-0fd7-416f-9c59-e9389c44c535.png" />

          <Caption>Open the Queries section from the sidebar</Caption>
        </Frame>
      </Step>

      <Step title="Create a new Update query">
        Click <b>Create New Query</b> to start a new export task.

        <Frame>
          <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/25c4e097-81dc-4b04-95d3-d92aff696689.png" />

          <Caption>Start a new query for updating contact records</Caption>
        </Frame>
      </Step>

      <Step title="Choose the data source">
        Select the Google Sheet containing your updated contact information.

        <Frame>
          <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/bc77d07c-707c-4dbe-8223-987d18068b3f.png" />

          <Caption>Select your source spreadsheet for contact updates</Caption>
        </Frame>
      </Step>

      <Step title="Export to HubSpot">
        Click <b>Export to HubSpot</b>.

        <Frame>
          <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/d7a5e490-cc5a-4287-a90b-8d72745879ea.png" />

          <Caption>Initiate the export to HubSpot</Caption>
        </Frame>
      </Step>
    </Steps>
  </Step>

  <Step title="Map fields and configure export settings">
    The export wizard guides you through mapping fields and configuration.
    <Info>If your sheet was imported via Superjoin, most fields map automatically (e.g., name, email, Record ID).</Info>

    <Frame>
      <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/e05eee3d-e7f2-4393-92ac-8a64dd2c664b.png" />

      <Caption>Review and verify mappings in the wizard</Caption>
    </Frame>

    <Note>If you use a custom sheet (not imported via Superjoin), map each column to a HubSpot field manually.</Note>

    <Frame>
      <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/4891042e-5836-4b26-ae78-c8002e02322a.png" />

      <Caption>Save field mappings for the update process</Caption>
    </Frame>

    <Step title="Advanced settings">
      Define result columns from the last column onward to capture row-by-row update info. Decide whether to export empty cells:

      <ul>
        <li><b>Export empty cells</b>: empty values overwrite existing values in HubSpot</li>
        <li><b>Ignore empty cells</b>: recommended for partial updates</li>
      </ul>

      <Frame>
        <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/fb509935-588b-49dd-b26a-1e25053ea09c.png" />

        <Caption>Control how empty cells are handled during export</Caption>
      </Frame>
    </Step>
  </Step>

  <Step title="Select rows and initiate the update">
    Choose which rows to export or select the entire sheet. Exporting the full sheet also captures newly added rows automatically.

    <Frame>
      <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/fcfb7bb6-0647-4cf3-b673-85cbfb79aff4.png" />

      <Caption>Select individual rows or the entire sheet</Caption>
    </Frame>

    Click <b>Next</b> to proceed and confirm the row count (e.g., <b>407 rows</b>).

    <Frame>
      <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/9cf75d8b-1726-42e6-aa92-04d72d83c441.png" />

      <Caption>Status check before exporting rows to HubSpot</Caption>
    </Frame>
  </Step>

  <Step title="Review update results">
    After the export runs, Superjoin adds result columns to your sheet showing row-by-row outcomes.

    <ul>
      <li>Each row shows whether the associated HubSpot record was updated successfully</li>
      <li>The <b>Record ID</b> remains linked for instant navigation to the HubSpot contact</li>
    </ul>

    <Frame>
      <img src="https://usercontent.in.prod.clueso.io/6b101750-ec89-4e66-83bb-0b9079219f65/6a07ab24-43dc-4a06-9b51-a2c972d1416b/17cddbae-29f2-419c-a865-986649b0db7c/images/5b463fe6-5847-4de7-9cf5-503f98be0d67.png" />

      <Caption>Results columns include outcome and direct HubSpot links</Caption>
    </Frame>
  </Step>
</Steps>

***

## What's next?

With contacts updated from Google Sheets, you have a fast, repeatable workflow for CRM maintenance. Next, try:

* Automating scheduled syncs for ongoing updates
* Connecting additional objects like Companies or Deals for broader data management
* Using Superjoin formulas for advanced data cleaning

<Note>You’re now equipped to keep HubSpot contact data up-to-date right from your spreadsheet—saving time and reducing manual errors.</Note>
