HubSpot Writebacks: How to Upload Data to HubSpot

Last Modified: November 1, 2023 - 4 min read

Hannah Recker
how to upload data to hubspot

While HubSpot is a powerful Customer Relationship Management (CRM) platform, many Go-to-market (GTM) professionals find themselves regularly importing HubSpot data into Google Sheets.

Spreadsheets are simply more flexible and versatile than HubSpot’s UI, allowing GTM teams to explore their data and quickly create the reports and dashboards they need.

Uploading data back to HubSpot from their spreadsheet, however, is a different story.

If users wanted to  export their data from Google Sheets to HubSpot they had two options:

Manually update data in HubSpot or use an unreliable connector to push data updates back into HubSpot.

But spoiler alert: there’s a better solution for pushing data from Google Sheets into HubSpot! This guide will go through how to automatically update HubSpot from Google Sheets.

Let’s get started!

Step-by-Step Walkthrough: How to Update HubSpot from Google Sheets

Coefficient is a free Google Sheets add-on that allows users to seamlessly import HubSpot data into their spreadsheets.

Go-to-market professionals can use Coefficient to streamline any of your HubSpot analysis and reporting workflows. Check out Coefficient’s Templates Gallery for pre-built dashboards for HubSpot, like the Win-Loss Analysis template below.

Coefficient's win-loss analysis template

And that’s not all!

With Coefficient, you can update data from Google Sheets directly to HubSpot in a few clicks!

Here’s a step-by-step tutorial to show you how.

Prefer a visual guide? Watch the video below.

Step 1: Install Coefficient

Coefficient’s intuitive, no-code HubSpot connector allows you to push back data to HubSpot.

But first, you’ll need to install it from the Google Workspace Marketplace.

Start by opening a new spreadsheet.

Navigate to the top navigation and click Extensions> Add-ons > Get add-ons.

install coefficient from the google workspace marketplace

This will direct you to the Google Workspace Marketplace.

Type in “Coefficient” in the search bar and select the Coefficient app.

search for coefficient in the menu bar

Accept the prompts to install.

Accept the prompts to install coefficient

Once installation is finished, return to Extensions on the Google Sheets menu.

Coefficient will appear in the is now available as an add-on.

Once installation is finished, return to Extensions on the Google Sheets menu.

Launch the app. Now Coefficient will run on the sidebar of your Google Sheet.

Step 2: Import HubSpot Data

Next, we need to import HubSpot data into Google Sheets.

Select Import From… on the Coefficient sidebar.

Click import from

Choose HubSpot as your data source.

Choose HubSpot as your data source.

Click From Objects & Fields.

Click From Objects & Fields.

Select an object to import.

Select an object to import.

Next, choose the Object fields you want to include in your import (e.g. Company Name, Lead Status, New Lead, etc.)  

choose the Object fields you want to include in your import

If you want, you can add filters and sort your data.

If you want, you can add filters and sort your data.

Otherwise, name your importand click Import to continue.

Your data will auto-populate inside Google Sheets in seconds.

name your import and click import

Step 3: Export to HubSpot

Now, let’s export the data back to HubSpot.

Coefficient Excel Google Sheets Connectors
Try the Free Spreadsheet Extension Over 425,000 Pros Are Raving About

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Get Started

Navigate to the bottom of the Coefficient sidebar.

Click Configure… under the Export to HubSpot section.

Click Configure… under the Export to HubSpot section.

Choose the tab you want to export from and the header row (in this case, Row 2).

Click Next.

Choose the tab you want to export from and the header row

Choose the HubSpot object you want to export your source data to. In this example, we are updating the Contact List… Object with new data in row 23.

Choose the HubSpot object you want to export your source data to.

Also select the appropriate List. For this example, ‘Writeback Demo List.’

Select the appropriate List.

Next, open up the Action dropdown. You’ll notice three options:

  • Sync Contacts: Updates HubSpot to match the sheet  
  • Add Contacts: Adds contacts to a list
  • Remove Contacts: Removes contacts from a list

Select Add Contacts and click Next to continue.

open up the Action dropdown.

Finally, you’ll select a Contact ID under the Field Mappings section.

Under the Field Mappings section, you’ll map select a column in your spreadsheet to map so the contact records are the same.

You can choose to map it to the Contact ID or email address.

Select Email from the dropdown and click Save.

Select Email from the dropdown and click Save.

Verify your selections and click Export…

verify your data

Coefficient will ask you if you want to update specific rows on the sheet or all the rows on the sheet.

Select All rows on sheet and click Next…  

Coefficient will ask you if you want to update specific rows on the sheet or all the rows on the sheet.

Coefficient will notify you if your export was successful.

Coefficient will notify you if your export was successful.

Navigate back to your spreadsheet to confirm.

Navigate back to your spreadsheet to confirm.

Congratulations! You’ve successfully updated HubSpot from Google Sheets.

Upload Data to HubSpot From Google Sheets with Coefficient

Why manually update your HubSpot data if you don’t have to?

With Coefficient, you can update HubSpot records and upload those changes back to HubSpot without ever leaving your spreadsheet.

Get started for free and automatically upload HubSpot data in just a few clicks.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 500,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
500,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 50,000 Companies