Find lookalike accounts on wins
This play automates prospect discovery and enrichment using Lusha and delivers the results directly into Google Sheets. It searches for contacts based on your ICP filters, enriches each prospect with verified contact data, and writes the enriched records into a structured spreadsheet.
Instead of manual searches, CSV exports, and cleanup work, your team gets a continuously updated, enrichment-ready prospect list—built automatically.
Why this works
Prospecting at scale usually means juggling tools: search in one place, enrich in another, then export and clean data before it’s usable.
This play removes friction by keeping the entire workflow automated. Lusha handles discovery and enrichment, while Google Sheets becomes the central place to review, qualify, and route prospects downstream.
What you get
- Automated prospect search using Lusha Prospecting filters
- Batch contact enrichment (email, phone, title, company, LinkedIn where available)
- Direct export to Google Sheets with clean, structured columns
- Repeatable list generation without manual work
- Ready-to-use data for CRM imports, outreach, or analysis
How to set it up
Connect your apps in Make
Ensure active connections for:
- Lusha: API access for prospecting and enrichment
- Google Sheets: permission to create and update spreadsheets
Define your prospecting criteria
Configure Lusha Prospecting filters such as:
- Job title or function
- Seniority level
- Industry
- Company size
- Geography
These filters determine which prospects appear in your sheet.
Configure enrichment fields
Select which data points to enrich and export, for example:
- Work email
- Direct or mobile phone
- Job title and seniority
- Company name and domain
- LinkedIn URL
Tip: Start with core fields and expand once quality is validated.
Map fields to Google Sheets
Create a clean sheet structure with columns like:
- First name / Last name
- Phone
- Title
- Company
- LinkedIn URL
- Source (e.g., “Lusha Automated Prospecting”)
Set cadence and limits
Decide:
- How often the scenario runs (daily, weekly, or manual)
- How many prospects per run (to manage volume and credits)
Test end-to-end
Run the scenario and confirm:
- Prospects are found correctly
- Enrichment completes successfully
- Data is written cleanly into Google Sheets
What to do next
- Add qualification columns: Score or tag prospects in Sheets before pushing them to CRM or outreach tools.
- Deduplicate across runs: Check email or LinkedIn URL to prevent duplicates.
- Push approved prospects downstream: Send high-fit rows into Salesforce, HubSpot, or Outreach using Zapier or Make.
- Create multiple pipelines: Run separate scenarios for different ICPs or regions.
- Track sourcing performance: Measure which prospecting filters generate the best downstream results.
The goal: Prospecting should be systematic, not manual. This play turns Lusha into a repeatable, automated prospecting engine, delivering enriched, sales-ready leads straight into Google Sheets—every time.
No FAQ items available at this time.
Ready to build this?
Get started with Lusha and set up this play in minutes.