Will this import existing rows from my Google Sheet?

No, Zapier only processes NEW rows added after the Zap is published. To import existing data, add those rows again or use HubSpot's manual CSV import.

What happens if I edit a row that was already imported?

Editing existing rows sometimes triggers the Zap again, creating duplicate contacts in HubSpot. Only add new rows at the bottom of your sheet.

Can I import to specific HubSpot lists or pipelines?

Yes, map your spreadsheet data to HubSpot's lifecycle stage, lead status, or list membership fields during the field mapping step.

How quickly do new contacts appear in HubSpot?

Google Sheets polling happens every 2-15 minutes, so contacts typically import within that timeframe. Not instantaneous but fast enough for most use cases.

What if my spreadsheet has more than 100 contacts at once?

Zapier processes each row individually, so 100 new rows = 100 separate Zap runs. This burns through your task limit quickly and takes time to complete.

Beginner~8 min setupProductivity & CRMVerified April 2026

How to Import Contacts from Google Sheets to HubSpot with Zapier

Automatically create or update HubSpot contacts when new rows are added to your Google Sheet.

Steps and UI details are based on platform versions at time of writing — check each platform for the latest interface.

Zapier

Also on:Make N8n Power-automate Pipedream

Best for

Non-technical teams importing up to 500 contacts monthly who want reliable, simple automation.

Not ideal for

High-volume imports over 1000 contacts monthly or teams needing instant real-time sync.

Sync type

polling

Use case type

import

Real-World Example

💡

A 12-person B2B marketing agency uses this to import leads from event signup sheets into their HubSpot pipeline. Before automation, the marketing coordinator manually copied 50-80 new leads weekly, taking 2 hours and introducing typos. Now leads flow automatically within 10 minutes of being added to the shared Google Sheet.

What Will This Cost?

Drag the slider to your expected monthly volume.

Monthly workflow runs

/mo

505005K50K

Each platform counts differently — Zapier: 1 task per trigger. Make: 1 operation per module per record. n8n: 1 execution per run.

$30/mo if billed monthly

Pipedream

$29/mo

Basic plan

Prices shown for annual billing. Based on published pricing as of April 2026.

Estimated ROI

1000

min saved/mo

$583

labor value/mo

Free

no platform cost

Based on ~2 min manual effort per operation at $35/hr fully loaded labor cost.

Implementation

Before You Start

Make sure you have everything ready.

Google account with edit access to the contact spreadsheet

HubSpot account with contact creation permissions

Google Sheet with contact data in consistent column format

At least one test row of data in your spreadsheet

Email column in your spreadsheet (required for HubSpot contacts)

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Email Address	`email`	Primary email for contact identification and deduplication in HubSpot

7 optional fields▸ show

First Name	`firstname`	Contact's given name for personalization and segmentation
Last Name	`lastname`	Contact's family name for full contact identification
Company Name	`company`	Organization name for B2B lead qualification and reporting
Phone Number	`phone`	Contact phone in international format (+15551234567) for outreach
Website URL	`website`	Company or personal website for lead research and validation
Job Title	`jobtitle`	Contact's role for lead scoring and sales qualification
Lead Source	`hs_lead_status`	Origin of the contact (event, form, referral) for attribution tracking

Step-by-Step Setup

Dashboard > Create Zap > Trigger

Create New Zap

Start a new automation by creating a Zap that will connect Google Sheets to HubSpot. This sets up the basic workflow structure.

1Click 'Create Zap' from your Zapier dashboard
2Click on 'Trigger' in the first step
3Search for 'Google Sheets' and select it
4Choose 'New Spreadsheet Row' as your trigger event

✓ What you should see: You should see Google Sheets selected as your trigger app with 'New Spreadsheet Row' configured.

Trigger > App & Event > Account

Connect Google Sheets Account

Authorize Zapier to access your Google Sheets. This creates a secure connection to monitor your spreadsheet for new rows.

1Click 'Sign in to Google Sheets'
2Select your Google account from the popup
3Click 'Allow' to grant Zapier permissions
4Click 'Continue' once connected

✓ What you should see: A green checkmark appears next to your Google account with 'Connected' status.

⚠

Common mistake — Make sure you're logged into the Google account that owns the spreadsheet - switching accounts later breaks the connection.

Zapier settings

Connection

Choose a connection…Add

click Add

Google Sheets

Authorize Zapier

popup window

✓

Connected

green checkmark

Trigger > App & Event > Options

Select Your Spreadsheet

Choose the specific Google Sheet and worksheet tab that contains your contact data. Zapier will monitor this sheet for new rows.

1Click the 'Spreadsheet' dropdown
2Select your contact spreadsheet from the list
3Click the 'Worksheet' dropdown
4Choose the specific sheet tab with contact data
5Click 'Continue'

✓ What you should see: Your spreadsheet and worksheet names appear in the configuration fields.

Trigger > Test

Test Google Sheets Trigger

Zapier pulls a sample row from your sheet to understand the data structure. This validates your connection and shows available fields.

1Click 'Test trigger'
2Review the sample data that appears
3Verify all your contact columns are visible
4Click 'Continue with selected record'

✓ What you should see: Sample data showing column headers like 'Email', 'First Name', 'Company' with actual values from your sheet.

⚠

Common mistake — If no data appears, add a test row to your sheet first - Zapier needs existing data to map fields.

Zapier

▶ Turn on & test

executed

✓

Google Sheets

✓

HubSpot

🔔 notification

received

Action > App & Event

Add HubSpot Action

Set up the second step to create or update contacts in HubSpot when new rows are detected.

1Click the '+' button below your trigger
2Search for 'HubSpot' and select it
3Choose 'Create or Update Contact' as the action event
4Click 'Continue'

✓ What you should see: HubSpot appears as your action step with 'Create or Update Contact' selected.

⚠

Common mistake — Don't choose 'Create Contact' - that fails if the contact already exists. 'Create or Update' handles duplicates.

Action > App & Event > Account

Connect HubSpot Account

Authorize Zapier to access your HubSpot account and create contacts. This establishes the secure connection for data transfer.

1Click 'Sign in to HubSpot'
2Enter your HubSpot login credentials
3Click 'Authorize' to grant access
4Select your HubSpot account if multiple appear

✓ What you should see: HubSpot account shows as connected with a green checkmark.

Action > Set up action > Contact Properties

Map Email Field

Configure the email field mapping first since it's required for contact creation. This tells Zapier which spreadsheet column contains email addresses.

1Click in the 'Email' field under Contact Properties
2Select your email column from the Google Sheets data dropdown
3Verify the sample email appears in the field
4Leave this field exactly as mapped

✓ What you should see: The Email field shows your Google Sheet email column with a sample email address visible.

⚠

Common mistake — Email is required for contact creation - if this field is empty, the Zap will fail every time.

Google Sheets fields

Column A

Column B

Status

Notes

available as variables:

1.props.Column A

1.props.Column B

1.props.Email

1.props.Status

1.props.Notes

Action > Set up action > Contact Properties

Map Contact Name Fields

Connect your spreadsheet name columns to HubSpot's first and last name fields. This ensures proper contact identification in your CRM.

1Click in the 'First Name' field
2Select your first name column from the dropdown
3Click in the 'Last Name' field
4Map your last name column from the spreadsheet

✓ What you should see: First Name and Last Name fields show your mapped columns with sample data.

Action > Set up action > Contact Properties

Map Company and Phone Fields

Add company and phone number mappings if your spreadsheet includes this data. These fields enrich contact profiles in HubSpot.

1Scroll down to find 'Company' field
2Map your company column if available
3Find the 'Phone Number' field
4Map your phone column if present in the sheet

✓ What you should see: Company and Phone fields show your selected columns or remain blank if not available.

⚠

Common mistake — HubSpot expects phone numbers in international format (+1234567890) - local formats may not import correctly.

Action > Test

Test HubSpot Action

Run a test to create an actual contact in HubSpot using your sample data. This validates the complete workflow.

1Scroll down and click 'Test step'
2Wait for the test to complete
3Review the success message with contact details
4Click 'Continue' if the test passes

✓ What you should see: Success message showing 'Contact created in HubSpot' with the contact ID and mapped field values.

⚠

Common mistake — This creates a real contact in HubSpot - check your contacts list to verify it worked correctly.

Zap Editor > Title

Review and Name Your Zap

Give your automation a descriptive name and review the complete workflow before activation.

1Click the pencil icon next to 'Untitled Zap'
2Enter a name like 'Google Sheets to HubSpot Contacts'
3Review both trigger and action steps
4Verify all field mappings are correct

✓ What you should see: Your Zap has a clear name and shows the complete Google Sheets → HubSpot workflow.

Zap Editor > Publish

Publish Your Zap

Activate the automation to start monitoring your Google Sheet for new contact rows. The Zap will run automatically going forward.

1Click the 'Publish' button in the top right
2Confirm by clicking 'Publish Zap'
3Wait for the 'Zap is on' confirmation
4Test by adding a new row to your Google Sheet

✓ What you should see: Green 'On' status appears next to your Zap name, indicating it's actively monitoring for new rows.

⚠

Common mistake — The Zap only triggers on NEW rows added after publishing - existing rows won't be imported automatically.

Drop this into a Zapier Code step.

Copy this template{{contact_email|lower|trim}} in the email field to normalize addresses and prevent duplicate contacts from spacing or capitalization differences

▸ Show code

{{contact_email|lower|trim}} in the email field to normalize addresses and prevent duplicate contacts from spacing or capitalization differences

... expand to see full code

{{contact_email|lower|trim}} in the email field to normalize addresses and prevent duplicate contacts from spacing or capitalization differences

Scaling Beyond 500+ contacts/month+ Records

If your volume exceeds 500+ contacts/month records, apply these adjustments.

Switch to Make for better pricing

At 500+ tasks monthly, Make's $9 plan beats Zapier's $50 Professional plan. The field mapping is similar but Make handles batch operations more efficiently.

Use batch import instead of row-by-row

Consider HubSpot's native CSV import for large datasets. Import 1000+ contacts in minutes vs hours with Zapier's 1-contact-per-task limit.

Going live

Production Checklist

Before you turn this on for real, confirm each item.

Test with a real contact row, not Zapier's sample data

Applies when: Always

Verify email column contains only valid email addresses

Applies when: Always

Set up task usage alerts at 80% of your monthly limit

Applies when: High volume

Check HubSpot contact deduplication settings match your needs

Applies when: Always

Add error notification to Slack or email for failed imports

Applies when: Enterprise

Format phone numbers consistently before going live

Applies when: Always

Troubleshooting

Common errors and how to fix them.

Frequently Asked Questions

Common questions about this workflow.

Analysis

VerdictWhy Zapier for this workflow

Use Zapier for this if your team doesn't code and you need dead-simple setup. Takes 8 minutes to configure and the trigger fires within 2-15 minutes of a new row appearing. The guided interface walks non-technical users through field mapping without confusion. Pick Make instead if you're importing 1000+ contacts monthly — Zapier's task limits get expensive fast at high volume.

Cost

This workflow costs 1 task per contact imported. At 200 contacts/month, that's 200 tasks total, fitting comfortably in Zapier's Starter plan at $20/month. Make charges $9/month for 1000 operations, so it's $11 cheaper monthly at this volume. N8n is free but requires hosting setup. Zapier wins on simplicity despite higher costs.

Tradeoffs

Make handles batch imports better — you can process multiple rows in a single scenario run instead of 1 task per contact. N8n offers more advanced data transformation if your spreadsheet needs cleaning before import. But Zapier's error handling is cleaner for this use case. When a contact creation fails, Zapier shows exactly which row and field caused the problem. Make's error messages are cryptic for beginners.

Google Sheets API has a 5-minute polling delay, so new rows take 2-15 minutes to trigger the Zap. If you edit existing rows, Zapier sometimes treats them as new and creates duplicate contacts. HubSpot's contact deduplication relies on exact email matches — extra spaces or different capitalization create separate contacts. Test with real messy data, not clean samples.

Ideas for what to build next

→
Add Slack notifications for new contacts — Create a second Zap that posts to Slack when HubSpot contacts are created, keeping your sales team informed of new leads.
→
Set up contact scoring automation — Build a workflow that assigns HubSpot lead scores based on company size, job title, or other criteria from your spreadsheet data.
→
Create follow-up email sequences — Trigger HubSpot email workflows automatically when contacts are imported, sending welcome emails or nurture sequences based on lead source.