Ops

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
Built by: Lusha
Difficulty: Medium
Tools: Google Sheets, Lusha, Make

How to set it up

01

Connect your apps in Make

Ensure active connections for:

  • Lusha: API access for prospecting and enrichment
  • Google Sheets: permission to create and update spreadsheets
02

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.

03

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.

04

Map fields to Google Sheets

Create a clean sheet structure with columns like:

  • First name / Last name
  • Email
  • Phone
  • Title
  • Company
  • LinkedIn URL
  • Source (e.g., “Lusha Automated Prospecting”)
05

Set cadence and limits

Decide:

  • How often the scenario runs (daily, weekly, or manual)
  • How many prospects per run (to manage volume and credits)
06

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.