Can I import leads to existing HubSpot lists automatically?

Not directly in this Zap. You'd need a second automation that adds new contacts with your event tag to specific lists based on criteria.

What happens if I edit an existing row in my sheet?

The Zap triggers again and tries to create a duplicate contact. HubSpot will merge by email, but it's cleaner to only add new rows at the bottom.

Can I map custom HubSpot properties for event-specific data?

Yes, but create the custom property in HubSpot first. Then refresh Zapier's field list to see new properties in the mapping step.

How do I handle leads without email addresses?

This workflow requires emails since HubSpot uses them for deduplication. Consider using HubSpot's Company object instead for business card leads without individual emails.

Beginner~8 min setupProductivity & CRMVerified April 2026

How to Import Event Leads from Google Sheets to HubSpot with Zapier

Automatically create HubSpot contacts with event tags whenever you add leads to a 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

Teams importing under 200 event leads monthly who want reliable automation without coding

Not ideal for

High-volume events with 500+ leads or teams needing complex data transformation before import

Sync type

polling

Use case type

import

Real-World Example

💡

A 12-person B2B software company uses this after trade shows and webinars. Their sales team previously spent 30+ minutes manually entering leads from business cards and signup sheets into HubSpot. Now they paste leads into a Google Sheet on-site and contacts appear in HubSpot tagged with the event name within minutes. This lets reps start follow-up calls the same day instead of waiting for manual data entry.

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 Sheets with column headers for lead data (First Name, Last Name, Email, Company)

HubSpot account with contact creation permissions

At least one test lead row in your spreadsheet

Zapier account (free tier works for small events)

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Email	`email`	Primary email address from lead capture form
First Name	`firstname`	Contact's first name for personalization
Event Source	`lead_source`	Static tag identifying which event generated this lead

4 optional fields▸ show

Last Name	`lastname`	Contact's surname for full name display
Company	`company`	Organization name where contact works
Phone Number	`phone`	Primary phone for outreach calls
Job Title	`jobtitle`	Contact's role for lead qualification

Step-by-Step Setup

Dashboard > Create Zap > Google Sheets

Create your trigger in Zapier

Set up the Google Sheets trigger to watch for new leads. This will fire whenever you add a row to your event spreadsheet.

1Click 'Create Zap' from your Zapier dashboard
2Search for 'Google Sheets' and select it as your trigger app
3Choose 'New Spreadsheet Row' as the trigger event
4Click 'Continue' to proceed to authentication

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

Zapier

click +

search apps

Google Sheets

Create your trigger in Zapier

Google Sheets

module added

Trigger > Google Sheets > Account

Connect your Google account

Authenticate your Google account so Zapier can access your spreadsheets. You'll need edit permissions on the target sheet.

1Click 'Sign in to Google Sheets'
2Select your Google account from the popup
3Click 'Allow' to grant Zapier spreadsheet permissions
4Verify the green 'Connected' status appears

✓ What you should see: Green checkmark next to your Google account email with 'Connected' status.

⚠

Common mistake — Don't use a personal Gmail account for business workflows — Google Workspace accounts have better API limits.

Zapier settings

Connection

Choose a connection…Add

click Add

Google Sheets

Authorize Zapier

popup window

✓

Connected

green checkmark

Trigger > Google Sheets > Spreadsheet

Select your event leads spreadsheet

Choose the specific Google Sheet where you'll paste event leads. This must be an existing spreadsheet with column headers.

1Click the 'Spreadsheet' dropdown menu
2Select your event leads Google Sheet from the list
3Choose the specific worksheet tab (usually 'Sheet1')
4Click 'Continue' to move to the test step

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

⚠

Common mistake — The spreadsheet must have data in row 1 as headers — empty sheets will cause the test to fail.

Trigger > Google Sheets > Test

Test the Google Sheets trigger

Zapier will pull a sample row from your spreadsheet to use for mapping. Add a test lead first if your sheet is empty.

1Click 'Test trigger' to fetch sample data
2Review the sample row data that appears
3Verify all your column headers are captured correctly
4Click 'Continue with selected record' if the data looks right

✓ What you should see: Sample lead data displays with column names like 'First Name', 'Email', 'Company' visible.

⚠

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

Zapier

▶ Turn on & test

executed

✓

Google Sheets

✓

HubSpot

🔔 notification

received

Action > HubSpot > Create Contact

Add HubSpot as your action app

Set up HubSpot to receive the lead data. You'll create new contacts with an event tag for each row.

1Click the '+' button to add an action step
2Search for 'HubSpot' in the app directory
3Select HubSpot from the results
4Choose 'Create Contact' as your action event

✓ What you should see: HubSpot appears as step 2 with 'Create Contact' selected as the action.

Action > HubSpot > Account

Connect your HubSpot account

Authenticate with HubSpot to allow contact creation. You need write permissions on contacts and custom properties.

1Click 'Sign in to HubSpot'
2Enter your HubSpot login credentials
3Select your HubSpot portal if you have multiple
4Click 'Allow access' to grant permissions

✓ What you should see: HubSpot account shows as connected with your portal name displayed.

⚠

Common mistake — Use an admin account for setup — marketing-only users can't access all contact properties in Zapier.

Action > HubSpot > Contact Fields

Map lead fields to HubSpot properties

Connect your spreadsheet columns to HubSpot contact fields. This determines what data gets imported for each lead.

1Click in the 'Email' field and select your email column from Google Sheets
2Map 'First Name' and 'Last Name' to their respective spreadsheet columns
3Set 'Company' to your company column if you have one
4Add your phone number column to the 'Phone Number' field

✓ What you should see: Each HubSpot field shows your Google Sheets column name in purple pills.

⚠

Common mistake — Email is required in HubSpot — if your sheet doesn't have emails, this workflow won't work.

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 > HubSpot > Custom Properties

Add the event tag to contacts

Tag all imported leads with your event name for easy segmentation. Create a custom property if you don't have one.

1Scroll down to find 'Lead Source' or create a custom 'Event' property
2Click 'Use a Custom Value' instead of mapping from sheets
3Type your event name like 'Trade Show 2024' or 'Webinar Jan 2024'
4Verify the tag appears in the field

✓ What you should see: The event tag shows as a static value that will be applied to all contacts.

⚠

Common mistake — Don't map this to a sheet column unless each lead has different event data — use the same tag for the whole batch.

Action > HubSpot > Test

Test the HubSpot contact creation

Run a test to verify the lead imports correctly with all fields mapped. This creates a real contact in HubSpot.

1Click 'Test action' to send sample data to HubSpot
2Wait for the success message to appear
3Review the contact details that were created
4Check that your event tag was applied correctly

✓ What you should see: Success message shows with the new HubSpot contact ID and mapped field values.

⚠

Common mistake — This creates a real contact in HubSpot using your sample data — delete it if you don't want test contacts in your CRM.

Zap Settings > Name & Status

Turn on your Zap

Activate the automation so it runs whenever you add leads to your spreadsheet. Give it a descriptive name first.

1Click the pencil icon to edit the Zap name
2Name it something like 'Event Leads to HubSpot - [Event Name]'
3Click the toggle switch to turn the Zap on
4Confirm activation when prompted

✓ What you should see: Zap shows as 'On' with a green status indicator and your custom name.

⚠

Common mistake — Name it specifically — you'll have multiple event imports and generic names make troubleshooting harder.

Drop this into a Zapier Code step.

Copy this template{{trim(firstname)}} {{trim(lastname)}}

▸ Show code

{{trim(firstname)}} {{trim(lastname)}}

... expand to see full code

{{trim(firstname)}} {{trim(lastname)}}

Scaling Beyond 200+ leads per event+ Records

If your volume exceeds 200+ leads per event records, apply these adjustments.

Switch to Make for batch processing

Make can process multiple rows in a single execution, avoiding Zapier's per-task charges. At 500+ leads, Make's $9/month unlimited plan beats Zapier's $50+ monthly cost.

Use Google Sheets' import functions

Instead of manual pasting, use IMPORTDATA or Google Forms to populate your sheet. This spreads row creation over time and avoids API rate limits from bulk additions.

Going live

Production Checklist

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

Test with a real lead row, not just sample data

Applies when: Always

Verify event tag appears correctly in HubSpot contact records

Applies when: Always

Clean spreadsheet data format before large imports

Applies when: High volume

Set up HubSpot duplicate management rules for email matching

Applies when: Always

Create a backup of your Google Sheet before bulk imports

Applies when: High volume

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 you're importing under 200 leads per event and your team doesn't code. The guided setup takes 15 minutes and handles duplicate detection through HubSpot's email matching. The trigger fires within 2-3 minutes of adding a row to your sheet. Skip Zapier if you're importing 500+ leads regularly — Make's unlimited operations plan at $9/month handles high volume better than Zapier's task-based pricing.

Cost

This workflow uses 1 task per lead imported. At 100 leads per event with 2 events monthly, that's 200 tasks — well within Zapier's free 100 tasks plus a $20/month Starter plan. Make would cost $9/month for unlimited operations on the same volume. N8n is free but requires hosting. For occasional events under 200 leads, Zapier's $20/month is simpler than managing N8n infrastructure.

Tradeoffs

Make handles batch operations better — you can import 100 leads in one execution instead of 100 separate runs. N8n offers better data transformation if your sheet format doesn't match HubSpot's requirements exactly. But Zapier wins on reliability — Google Sheets integration rarely breaks and HubSpot's webhook delivery is rock solid. Make's Google Sheets module occasionally misses new rows during high-frequency additions.

Google Sheets API has a 100 requests per 100 seconds rate limit that can cause delays when importing large batches quickly. If you paste 50+ leads at once, Zapier may throttle and process them over 10-15 minutes instead of immediately. HubSpot's contact creation API returns cryptic error messages for malformed phone numbers — clean your data format before import. The automation won't catch leads added above existing rows, only new rows at the bottom of your sheet.

Ideas for what to build next

→
Add Slack notifications for new event leads — Create a second Zap that posts to #sales when HubSpot contacts are created with your event tag.
→
Set up automated follow-up sequences — Use HubSpot workflows to enroll event-tagged contacts in email nurture campaigns based on their lead source.