• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

6 min read

How to update HubSpot contacts from a Google Sheet

By Krystina Martinez · January 24, 2023
Hero image of the Google Sheets app icon connected to the HubSpot app icon on a light yellow background.

Your customer relationship management (CRM) tool is your source of truth for sales, leads, and customer information. With all that information to track, sometimes it's easier to check that information in a spreadsheet first before it goes into your CRM. 

Using a spreadsheet as a part of your lead management process doesn't have to slow down the sales pipeline. With Zapier, you can automatically create and update CRM contacts from a spreadsheet—so you don't have to sacrifice speed for accurate customer records. 

In this tutorial, we'll show you how to create a Zap—what we call our automated workflows—that will automatically create or update HubSpot contacts from a Google Sheet.

This workflow requires a multi-step Zap, which is available on a paid Zapier plan or during a free trial. Learn more about multi-step Zaps.

Before you begin

We'll be using HubSpot and Google Sheets for this tutorial, but the general idea will apply if you use a different spreadsheet app or CRM tool. 

If you're using Google Sheets, make sure you have a spreadsheet with your columns labeled. This Zap will not work unless your columns are labeled. Your spreadsheet should include contact information you'd track in HubSpot, such as an email address or phone number. 

If you anticipate that a cell in your Google Sheet will change between two values often—for example, if a cell changes from yes to no, then back to yes—include a separate timestamp column in your spreadsheet. 

Additionally, you'll need administrator privileges in HubSpot in order to connect to Zapier, so check your HubSpot settings to verify your permission level.

Note: You can quickly enter a timestamp while working in Google Sheets using the following keyboard shortcuts: Ctrl + Alt + Shift + ; to insert date and time on Windows machines; or Cmd + Alt + Shift + ; to insert date and time on a Mac. Using the formula =TODAY in Google Sheets will not trigger the Zap, because it changes automatically, rather than by manipulating other cells in the spreadsheet.

How to update HubSpot contacts from a Google Sheet

If you're new to search actions—available with certain Zapier integrations—this tutorial will be a gentle intro. Search actions can help prevent duplicate records and update existing data, cutting down on the actual human time you spend on managing leads. 

If you're the DIY-type, you can create your own Zap from scratch with our point-and-click editor, but we also have quick templates to get you started. 

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Update or create HubSpot contacts from a Google Sheet

Update or create HubSpot contacts from a Google Sheet
  • Google Sheets logo
  • Filter by Zapier logo
  • HubSpot logo
Google Sheets + Filter by Zapier + HubSpot
Here's how to set it up: 
  1. Connect a Google Sheet and customize your trigger

  2. Connect to HubSpot and customize your search action

  3. Test your filter step

  4. Connect to HubSpot and customize your update action

Set up your Google Sheets trigger

First, set up your trigger—the event that starts a Zap. 

If you're creating a Zap from scratch, select Google Sheets as the app, New or Updated Spreadsheet Row as your Event, and click Continue. (If you're using our Zap template, you'll skip this part.)

Note: If you're using a spreadsheet located in a Team Drive, use the New or Updated Spreadsheet Row (Team Drive) trigger instead.

Next, connect your Google Sheets account to Zapier. If you haven't connected Google Sheets to Zapier before, sign into your Google account when prompted. Otherwise, select your Google Sheets account from the dropdown menu and click Continue

For each app you connect, Zapier will ask for a general set of permissions which allows you to be flexible with your Zaps. The only actions Zapier takes on your app accounts are those a given Zap needs to accomplish what you've set up.

Now, select the spreadsheet and specific worksheet you'd like to use. If you want Zapier to watch out for changes in a specific column, click on the dropdown under Trigger Column and select the Google Sheet column you want to use. 

If you want your Zap to pay attention to new spreadsheet rows, leave the Trigger Column set to any_column

Click on the dropdowns to select the Google Sheet, worksheet, and column that will trigger the Zap.

Click Continue

Next, test your trigger. Zapier will look for a recent spreadsheet row in your Google Sheet, according to how you set up your trigger earlier. You'll use whatever Zapier finds to set up the rest of your Zap. 

Click the Test trigger button.

Once you see a success message, check the results and make sure you have the data you want. If something looks off, make adjustments to your trigger criteria if needed and retest until you get the information you want. 

Once you're happy with the results, click Continue. 

Review your test data for the Google Sheets rows Zapier found.

Review your test data for the Google Sheets rows Zapier found.

Set up your HubSpot search action

Next, set up your HubSpot search action, which will check for existing contacts that match your Google Sheets trigger. 

Check out our guide on how to get the most out of Zapier search steps.

If you're creating a Zap from scratch, search for and select HubSpot as your app, Find Contact as your event, and click Continue. (The Zap editor will do this for you if you're using our Zap template.)

Next, connect your HubSpot account or select an existing HubSpot account from the dropdown and click Continue

Now you need to specify what you want Zapier to look for within your HubSpot contacts. 

Click on the dropdown beneath First search property value, then search for and select the HubSpot contact property you want your search to focus on. 

Select a HubSpot property from the dropdown menu.

I find it easier to pick a contact property that is less prone to human error, such as an email address or a phone number. For example, if your spreadsheet contains leads from forms or newsletter signups, the chances are low that your lead will enter their email address incorrectly. While most people don't misspell their name or company affiliation, those can change!

Once you've selected your HubSpot contact property, Zapier will ask for a search value, which is the actual information your Zap will be looking for. 

In order to pass information from your Google Sheet to HubSpot, you need to map a dynamic value to the First search property value field. Click on the dropdown and map a field from your Google Sheet trigger. 

Click on a field and select a dynamic value listed from your Google Sheet trigger.

A dynamic value is any data from a previous Zap step that you've mapped to a field in the Zap editor. When you map a dynamic value—such as a contact name—what you see in the editor is a placeholder. Field mapping dynamic values are how you pass data from one app to another. Once your Zap is turned on, Zapier will send the information that the field contains every time your Zap runs.

In the example below, I've mapped the Email column from my Google Sheet as my search value since I want this Zap to search my HubSpot contacts by email. 

Select a HubSpot contact property to search and the value from Google Sheets Zapier will look for.

HubSpot gives you the option to set backup properties and values to search in case your first search fails. If you'd like to set this up, repeat the same steps above to set up your backup search properties. 

In the example below, my Zap will search for my lead's company information in HubSpot if it doesn't find anything in the Email contact property.  

For your backup search, select a HubSpot property and a Google Sheets value to look for.

Optional: Customize your new HubSpot record

If you're using our Zap template, you'll notice that Create HubSpot Contact if it doesn't exist yet? is checked. 

Check the checkbox next to "Create HubSpot Contact if it doesn't exist yet."

Certain apps, like HubSpot, allow you to search for existing data and create new items in the same step, which saves you setup time.

Since this option is checked, the Zap editor will prompt you to customize what you want in your new contact record in the event you don't have an existing HubSpot contact. 

To pass information from your Google Sheet to HubSpot, map fields from your Google Sheets trigger to the corresponding HubSpot contact properties. You don't need to fill out every field listed in the Zap editor—just the ones you need. 

Select dynamic values from Google Sheets to populate HubSpot contact properties.

Once you've customized what will go in your new contact record, click Continue

Now test your search action. Zapier will search for an existing HubSpot contact. If one doesn't exist, it will create a new contact if you've set it up to do so. 

Click the "Test action" button.

When you see a success message, check your test data carefully. 

If Zapier found a HubSpot contact, _zap_data_was_found will be true. If Zapier didn't find anything, this will be false. And if you've set up your search action to do so, it will create a new contact record as well if your test is false.  

Check test data for the Zap search status.

Click Continue

Test your filter

If you're using our Zap template, a filter step will already be set up for you. This filter ensures that this Zap will only continue to the next step if Zapier finds an existing HubSpot contact. 

The filter will check the "Zap Data Was Found" field in the search step for a "true" value.

If you're setting up this Zap from scratch, click on the Choose field… dropdown and select Zap Data Was Found from your search step. 

Select "Zap Data Was Found" from the search step for the filter field.

Then, click on the Choose condition… dropdown and select (Boolean) Is true

You can add additional filters, if you'd like. In the example below, I added an additional filter to ensure that this Zap only continues on new non-empty spreadsheet rows. 

The filter contains two rules.

Click Continue to test your filter. If your filter behaves how you expected it to, click Continue again. If not, adjust your filters and retest until you get the result you expected.

Test the filter and check the results.

Note: You can replace this filter step with Pathsavailable on Zapier's Professional plans and higher—if you want your Zap to update your HubSpot contacts in a specific manner depending on Google Sheet information. Learn more about using Paths with search steps to create conditional workflows.

Set up your update action

Now you'll set up the final step in this Zap. If Zapier finds an existing contact in HubSpot, this action will update that contact record. 

If you're creating this Zap from scratch, search for and select HubSpot as your action app, Update Contact as your action event, and click Continue

Next, select your HubSpot account from the dropdown menu and click Continue

The Zap editor will prompt you for an Object ID. This is the piece of information Zapier needs in order to know which HubSpot contact to update. 

Click on the field beneath Object ID and click on the down caret next to your search step.

Click on the "Object ID" field and select the previous search step.

 Learn more about using search steps to update existing records.

Then, select the ID value.

Select the "ID" value.

Remember, dynamic values are how you pass information from one app to another. The value will change depending on the information your Zap receives. Do not enter static text in the required fields, unless you want your Zap to update the same record each time. 

Now you can customize the rest of this step according to the contact properties you want to update in HubSpot. When you're done, click Continue

Finally, test your update action.

Test the action.

Once you see a success message in the Zap editor, check your contact record in HubSpot. 

Check your newly-updated contact in HubSpot.

If everything looks good, you're ready to use your Zap!

Automation for speedy (and accurate) lead management

You don't have to choose between speed and accuracy in your lead management processes. Automation with Zapier lets you benefit from the easy scannability of a spreadsheet and the advanced tools from your CRM—without slowing down your sales pipeline. 

Update or create HubSpot contacts from a Google Sheet

Update or create HubSpot contacts from a Google Sheet
  • Google Sheets logo
  • Filter by Zapier logo
  • HubSpot logo
Google Sheets + Filter by Zapier + HubSpot

Zapier is the leader in workflow automation—integrating with thousands of apps from partners like Google, Salesforce, and Microsoft. Use interfaces, data tables, and logic to build secure, automated systems for your business-critical workflows across your organization's technology stack. Learn more.

Related reading:

  • More ways to automate HubSpot

  • Automatically add new leads to a spreadsheet

  • Automate Google Sheets

  • How to get Slack notifications for HubSpot form responses

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'