Auto-search & enrich leads in Google Sheets
This play turns a Google Sheet into an automated prospecting engine. You define your ICP filters once (location, company size, etc.), then run Search Contacts to pull batches of contacts into the sheet. When you’re ready, run Enrich Contacts (batch) or Enrich Row (one-off) to retrieve deeper verified data—like LinkedIn, seniority, departments, emails, and phone numbers—while tracking enrichment status and progress inside the sheet.
Why this works
Prospecting usually breaks down into repetitive steps: build lists, export/import CSVs, enrich records, track progress, repeat. That creates delays, duplicates, and messy handoffs.
This play keeps the full workflow in one place: Search → Review → Enrich → Track, all inside Google Sheets. Ops gets control and visibility, SDRs get ready-to-use lead data, and enrichment is only triggered when needed.
What you get
- Search contacts in batches (e.g., 40 at a time) using ICP filters
- Enrich contacts with verified data (emails, phones, LinkedIn, seniority, department)
- Progress tracking built in: Request ID, Contact ID, page tracking
- Enrichment status
- Optional “Enrich Row” button to enrich only selected contacts (credit-efficient)
How to set it up
Create your Google Sheet
- Create a new sheet
Name it Sheet1 (or update the SHEET_NAME variable in the script)
Add the Apps Script
- Go to Extensions → Apps Script
- Replace any existing code with the provided script from the tutorial/template
- Save
Add your Lusha API key
In the script, set:
- API_KEY = ‘YOUR API KEY HERE’
Customize your ICP filters
In the script’s payload for populateContacts(), update filters to match your ICP (examples include location + company size). This controls who gets pulled into the sheet.
Run Search → then Enrich
Back in the sheet, use the new menu: Lusha Actions
- Search Contacts → populates the sheet with contacts from your filters
- Enrich Contacts → enriches those contacts with deeper verified fields
Note: Search + Enrich run in batches (e.g., 40). Enrichment consumes credits when triggered.
Add the “Enrich Row” button
If you want on-demand enrichment for selected rows:
- Insert → Drawing → add a button shape labeled “Enrich Row”
- Assign script: onEnrichRowClick
Now you can enrich only the selected contacts instead of the whole batch.
What to do next
- Add “ICP fit” columns (fit score, persona, priority) to qualify before enriching
- Create a “Ready to import” view: filter for Enriched = Yes + required fields present
- Prevent duplicates: add a check on email/LinkedIn before appending new contacts
- Route to systems: once enriched, push rows into CRM, HubSpot, or outreach tools via Zapier/Workato
- Optimize credit usage: default to batch search, then enrich only the rows you actually want to action
The goal: Stop treating Google Sheets like a static list. Turn it into a controlled prospecting workflow where you can generate leads, enrich only what matters, and track progress—all with verified Lusha data.
No FAQ items available at this time.
Ready to build this?
Get started with Lusha and set up this play in minutes.
