Enrich contacts from Google Sheets and create Salesforce leads
This play triggers whenever a new or updated row appears in Google Sheets, enriches the contact using Lusha Connect, and creates a Salesforce lead with standardized, enriched data. It’s ideal for teams using Sheets as an intake layer for events, lists, partners, or manual imports—while keeping Salesforce clean and consistent.
Why this works
Google Sheets are often used as a temporary holding place for leads—but moving that data into Salesforce usually means manual work and inconsistent fields.
This play enriches leads before they ever hit Salesforce. Every contact is validated, enriched, and mapped automatically, so downstream routing, scoring, and outreach workflows work as expected from day one.
What you get
- Automatic trigger on new or updated Google Sheets rows
- Contact enrichment via Lusha (title, company, seniority, LinkedIn, phone where available)
- Optional company context derived from email domain
- Clean Salesforce lead creation with standardized fields
- Faster lead activation without manual imports
How to set it up
Connect all required accounts
Before testing the Zap, connect each app in Zapier:
- Google Sheets: connect the Google account that owns the spreadsheet
- Lusha Connect: authenticate with your Lusha API credentials
- Salesforce: connect the Salesforce org where leads should be created
Configure the Google Sheets trigger
Select:
- The Spreadsheet
- The Worksheet
Confirm the row includes:
- Email address (required)
- First name / Last name
- Company (optional)
- Any custom fields you want passed into Salesforce
Configure Lusha enrichment
Map identifiers from the sheet:
- Work email (preferred)
- Email domain → derive company data
- Name + company (fallback)
Common enrichment fields:
- Job title
- Seniority
- Department
- Company name
- LinkedIn URL
- Phone (where available)
Tip: Only enrich and write fields that are empty to avoid overwriting trusted data.
(Optional) Add validation or filtering
Before creating Salesforce leads:
- Continue only if email exists
- Skip personal email domains (gmail.com, yahoo.com)
- Optional: continue only if enrichment succeeded
This keeps Salesforce clean and reduces noise.
Configure Salesforce lead creation
In the Create Lead action:
- Map Email (unique identifier)
- Map enriched fields:
- Name
- Company
- Title
- Phone
- LinkedIn URL
- Any custom Salesforce fields used for routing or scoring
Tip: If duplicates are a concern, switch to Find or Create Lead logic where available.
Test end-to-end
Add or update a row in Google Sheets and confirm:
- Trigger fires correctly
- Lusha returns enrichment data
- Salesforce lead is created with clean, populated fields
What to do next
- Add lead assignment rules: Route enriched leads to the right owner based on region, role, or company size.
- Score leads automatically: Use enriched seniority and firmographics to prioritize follow-up.
- Control enrichment usage: Skip rows already processed or enriched recently to save credits.
- Expand intake sources: Use the same pattern for event lists, webinar exports, or partner uploads.
- Measure impact: Compare conversion rates and time-to-first-touch for enriched vs. non-enriched sheet leads.
The goal: Sheets are a great intake tool—but Salesforce should stay clean. This play ensures every row becomes an enriched, standardized Salesforce lead automatically, so your team can move fast without manual cleanup.
No FAQ items available at this time.
Ready to build this?
Get started with Lusha and set up this play in minutes.
