Skip to main content
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.

​
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

  • Your sheet contains a unique identifier per contact: Record ID or email
  • Superjoin is installed and connected to HubSpot

​
Step-by-step

1

Prepare contact data with Record ID or email

To update contacts, include at least the Record ID or email in your sheet. If you import via Superjoin, add the Record ID field for accurate matching.
When importing from HubSpot, add Record ID in the data source dialog so Superjoin can uniquely identify contacts.
2

Set up an Update query

Create a query to export updates from your sheet to HubSpot.
1

Open Superjoin Queries

Go to Queries in the Superjoin sidebar.
2

Create a new Update query

Click Create New Query to start a new export task.
3

Choose the data source

Select the Google Sheet containing your updated contact information.
4

Export to HubSpot

Click Export to HubSpot.
3

Map fields and configure export settings

The export wizard guides you through mapping fields and configuration.
If your sheet was imported via Superjoin, most fields map automatically (e.g., name, email, Record ID).
If you use a custom sheet (not imported via Superjoin), map each column to a HubSpot field manually.
1

Advanced settings

Define result columns from the last column onward to capture row-by-row update info. Decide whether to export empty cells:
  • Export empty cells: empty values overwrite existing values in HubSpot
  • Ignore empty cells: recommended for partial updates
4

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.
Click Next to proceed and confirm the row count (e.g., 407 rows).
5

Review update results

After the export runs, Superjoin adds result columns to your sheet showing row-by-row outcomes.
  • Each row shows whether the associated HubSpot record was updated successfully
  • The Record ID remains linked for instant navigation to the HubSpot contact

​
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
You’re now equipped to keep HubSpot contact data up-to-date right from your spreadsheet—saving time and reducing manual errors.
⌘I