Can I import leads from multiple events using the same Zap?

Yes, just paste new event data into additional rows in the same spreadsheet. Add an event name column and map it to Lead Source Detail to track which event each lead came from.

What happens if I accidentally paste the same attendee data twice?

Zapier will create duplicate leads in Salesforce since it processes each new row. Enable Salesforce duplicate rules or manually delete duplicate rows from your spreadsheet before they trigger.

Can I update existing leads if attendees return to future events?

This Zap only creates new leads. To update existing records, you'd need a separate Zap using Salesforce's 'Update Record' action with email as the lookup field.

How do I handle international phone numbers and addresses?

Map international data to Salesforce's standard fields but add data validation in your spreadsheet first. Salesforce expects specific formats for phone numbers and state/country values.

Will this work if my Salesforce has custom required fields?

You'll need to map values to any custom required fields or the Zap will error. Check your Salesforce lead page layout to identify required fields beyond the standard ones.

Beginner~8 min setupProductivity & CRMVerified April 2026

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

Automatically import attendee data from Google Sheets into Salesforce as leads after trade shows and events.

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

Sales teams that import trade show leads monthly and want simple point-and-click setup.

Not ideal for

High-volume imports over 500 leads/month or teams needing complex data transformation.

Sync type

polling

Use case type

import

Real-World Example

💡

A 25-person SaaS company imports 150 leads after quarterly trade shows by pasting attendee badge scan data into Google Sheets. Before automation, their sales ops person manually created each lead in Salesforce, taking 3 hours per event. Now leads appear in Salesforce within minutes and get auto-assigned to reps based on territory rules.

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.

A Google Sheets spreadsheet with attendee data including name, email, company, and phone columns

Salesforce admin access or permissions to create leads

A Zapier account (free tier supports up to 100 leads/month)

Sample attendee data in your spreadsheet for testing the connection

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Last Name	`LastName`	Contact's surname — required field in Salesforce leads
Company	`Company`	Organization name from badge or registration data

6 optional fields▸ show

First Name	`FirstName`	Contact's given name for personalized outreach
Email	`Email`	Primary email address for lead nurturing campaigns
Phone	`Phone`	Business phone number for sales calls
Title	`Title`	Job title to qualify decision-making authority
Lead Source	`LeadSource`	Set to 'Trade Show' to track event ROI
Lead Source Detail	`LeadSource_Detail__c`	Specific event name for granular tracking

Step-by-Step Setup

Dashboard > Create Zap > Trigger

Create New Zap and Connect Google Sheets

Start a new Zap and select Google Sheets as your trigger app. You'll connect your Google account and choose the spreadsheet where you paste attendee data.

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

✓ What you should see: You should see Google Sheets selected as your trigger with the event option highlighted.

Trigger > Account

Authenticate Google Sheets Account

Connect your Google account to Zapier so it can access your spreadsheets. Make sure you use the account that owns the event attendee spreadsheet.

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

✓ What you should see: You should see a green checkmark and 'Connected' status next to your Google account email.

⚠

Common mistake — Don't connect a different Google account than the one that owns your attendee spreadsheet — Zapier won't see the file.

Trigger > App & Event

Select Your Event Attendee Spreadsheet

Choose the specific Google Sheet where you paste trade show attendee data. Pick the worksheet tab that contains the lead information.

1Select your attendee spreadsheet from the 'Spreadsheet' dropdown
2Choose the correct worksheet tab from the 'Worksheet' dropdown
3Select 'New Rows Only' for the trigger option
4Click 'Continue' to proceed

✓ What you should see: Your spreadsheet and worksheet names should appear in the dropdown fields with your selections confirmed.

⚠

Common mistake — Select 'New Rows Only' not 'New or Updated' — updated rows will create duplicate leads in Salesforce.

Trigger > Test

Test Google Sheets Trigger

Zapier pulls a sample row from your spreadsheet to test the connection. This sample data will be used to map fields to Salesforce later.

1Click 'Test trigger' button
2Review the sample data that appears
3Verify all your column headers are showing correctly
4Click 'Continue with selected record'

✓ What you should see: You should see a sample row with all your spreadsheet columns like Name, Email, Company, Phone displayed as separate fields.

⚠

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

✓

Salesforce

🔔 notification

received

Action > App & Event

Add Salesforce as Action App

Set up Salesforce as your action app to receive the lead data. Choose the create lead action to add new prospects to your CRM.

1Click the '+' button to add an action step
2Search for and select 'Salesforce'
3Choose 'Create Record' as the action event
4Select 'Lead' as the record type

✓ What you should see: Salesforce should appear as your action app with 'Create Record' and 'Lead' selected in the dropdown menus.

Action > Account

Connect Your Salesforce Account

Authenticate your Salesforce account so Zapier can create leads. Use your main Salesforce login credentials, not a integration-only user.

1Click 'Sign in to Salesforce'
2Enter your Salesforce username and password
3Click 'Log In' in the Salesforce popup
4Click 'Allow' to grant Zapier access

✓ What you should see: You should see your Salesforce org name and a green 'Connected' status indicator.

⚠

Common mistake — Make sure you're logging into the correct Salesforce org — if you have multiple orgs, double-check the login URL.

Zapier settings

Connection

Choose a connection…Add

click Add

Google Sheets

Authorize Zapier

popup window

✓

Connected

green checkmark

Action > Set up action

Map Lead Fields from Spreadsheet

Connect your Google Sheets columns to Salesforce lead fields. Map the essential fields like name, email, company, and phone number for complete lead records.

1Map 'Last Name' to your spreadsheet's Name column
2Map 'Email' to your Email column
3Map 'Company' to your Company column
4Map 'Phone' to your Phone column
5Set 'Lead Source' to 'Trade Show' or your event name

✓ What you should see: Each Salesforce field should show the corresponding Google Sheets column name in blue pill format.

⚠

Common mistake — Last Name is required in Salesforce — if your spreadsheet has full names, use a Formatter step to split first/last names.

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

Set Lead Source and Campaign Details

Add context about where these leads came from. Set the lead source and add campaign information to track ROI from your trade show investment.

1Set 'Lead Source' dropdown to 'Trade Show'
2Enter your event name in 'Lead Source Detail' field
3Select your campaign from 'Campaign' dropdown if using campaigns
4Add any custom field values for event tracking

✓ What you should see: Lead source fields should show 'Trade Show' and your specific event details filled in.

Action > Set up action

Configure Lead Assignment Rules

Set up how new leads get assigned to sales reps. You can use Salesforce's default assignment rules or assign to a specific user.

1Check 'Use Assignment Rules' if you want automatic assignment
2Or select a specific user from 'Owner' dropdown
3Set 'Lead Status' to 'Open - Not Contacted' or your default status
4Leave 'Trigger Auto-Response Rules' checked for follow-up emails

✓ What you should see: Assignment and status settings should reflect your sales team's lead routing preferences.

⚠

Common mistake — Don't assign all leads to yourself unless you're the only sales person — use assignment rules to distribute fairly.

Action > Test

Test Salesforce Lead Creation

Run a test to create a sample lead in Salesforce. This verifies your field mapping works and the lead appears correctly in your CRM.

1Click 'Test step' button
2Wait for the test to complete
3Click the Salesforce record link to view the created lead
4Verify all fields populated correctly in Salesforce

✓ What you should see: You should see a success message with a link to view the newly created lead record in Salesforce.

⚠

Common mistake — The test creates a real lead in Salesforce — delete it after verification to avoid cluttering your database.

Final > Publish

Name and Activate Your Zap

Give your Zap a descriptive name so you can find it later. Turn it on to start automatically importing leads when you add new rows to your spreadsheet.

1Click 'Continue' to go to the final screen
2Enter a name like 'Trade Show Leads to Salesforce'
3Toggle the Zap status to 'On'
4Click 'Publish Zap' to activate

✓ What you should see: Your Zap should show as 'On' with a green status indicator and ready to process new spreadsheet rows.

Drop this into a Zapier Code step.

Copy this template{{zap_meta_human_now}} | {{inputData__Company}} Lead

▸ Show code

{{zap_meta_human_now}} | {{inputData__Company}} Lead

... expand to see full code

{{zap_meta_human_now}} | {{inputData__Company}} Lead

Scaling Beyond 300+ leads per event+ Records

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

Batch Process Large Imports

Break large spreadsheets into chunks of 50-100 rows and import them separately. This prevents API throttling and makes error debugging easier when issues occur.

Upgrade Zapier Plan Early

The free tier's 100 tasks/month disappears fast with lead imports. Upgrade to Starter ($19.99) before your event to avoid workflow interruptions mid-import.

Going live

Production Checklist

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

Test with 3-5 real attendee records before importing full spreadsheet

Applies when: Always

Verify lead assignment rules distribute leads correctly across sales team

Applies when: Always

Set up error notifications to catch API failures or missing required fields

Applies when: Always

Enable duplicate detection rules in Salesforce to prevent duplicate imports

Applies when: Always

Configure Zap to pause on errors rather than skip bad records

Applies when: High volume

Set up monitoring dashboard to track import success rates

Applies when: Enterprise

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 import leads sporadically after events. Setup takes 15 minutes and new rows trigger within 2 minutes. The guided interface makes field mapping dead simple — just click dropdowns to connect spreadsheet columns to Salesforce fields. Skip Zapier if you're importing 500+ leads monthly since you'll blow past the free tier fast.

Cost

This workflow uses 1 task per lead imported. At 200 leads/month from quarterly trade shows, that's 200 tasks monthly. The Starter plan at $19.99/month gives you 750 tasks, so you're covered with room to grow. Make would cost $9/month for 1,000 operations but requires more technical setup. N8n is free but you need to host it yourself.

Tradeoffs

Make handles larger datasets better — it can process 500 rows at once while Zapier imports one row at a time. N8n gives you custom JavaScript transforms if your lead data needs heavy cleanup before hitting Salesforce. But Zapier's pre-built Salesforce integration handles lead assignment rules and duplicate detection automatically, which the others make you configure manually.

Google Sheets API sometimes lags on new row detection — you might wait 5-15 minutes for triggers in busy spreadsheets. If you paste 100+ rows at once, Zapier processes them individually which can take 30+ minutes to complete. Salesforce's API limits you to 100 API calls per rolling 20 seconds, so large imports will throttle and queue up tasks for later processing.

Ideas for what to build next

→
Add Lead Scoring Automation — Create a follow-up Zap that scores new trade show leads based on company size and title, then assigns them to appropriate sales tiers.
→
Set Up Nurture Campaign Triggers — Connect leads to your marketing automation platform to start email sequences based on the specific trade show they attended.
→
Create Event ROI Tracking — Build a dashboard Zap that counts leads per event and calculates conversion rates to measure trade show performance.