Auto-search & enrich companies in Google Sheets
This play transforms Google Sheets into an automated account prospecting workspace. You define company filters (location, industry IDs, employee size), run Search Companies to pull batches of matching accounts into the sheet, and then run Enrich Companies to retrieve detailed firmographics—industry classification (NAICS/SICS), revenue range, employee count, description, LinkedIn URL, specialties, and more.
Everything is tracked inside the sheet using request IDs, pagination, and structured columns—so you can build and maintain clean, analysis-ready target account lists without exports or manual enrichment.
Why this works
Account targeting typically involves multiple disconnected steps: identify companies, export lists, enrich, reformat, and repeat. It’s slow, error-prone, and hard to track.
This play keeps the full loop inside Google Sheets: Search → Enrich → Analyze. Ops can control filters, sales can review results, and enrichment is repeatable and trackable at scale.
What you get
- Company search in batches (e.g., 40 per page) using Prospecting filters
- Company enrichment with firmographics (industry, revenue, employees, description, LinkedIn, specialties)
- Industry classification fields (NAICS + SICS codes and descriptions)
- Structured location data (country, ISO2, city, state, full address, continent)
- Built-in tracking (request ID + page tracking) for repeatable list building
How to set it up
Create your Google Sheet
- Create a new Google Sheet
- Name the sheet Sheet1 (or update SHEET_NAME in the script)
Add the Apps Script
- Go to Extensions → Apps Script
- Delete any existing code
- Paste in the provided company search + enrich scrip
- Save
Add your Lusha API key
In the script, set:
- API_KEY = ‘API key here’
Customize your company filters (ICP)
In populateCompanies(), update the payload filters to match your targeting needs:
- locations: set target countries/regions
- mainIndustriesIds: update industry IDs based on your focus
- sizes: set employee minimum (and/or ranges, if needed)
This controls which companies are pulled into your sheet.
Run Search → then Enrich
Back in Google Sheets, use the new menu: Lusha Actions
- Search Companies → populates the sheet with matching companies (page-by-page)
- Enrich Companies → fetches detailed company data for the listed results
What to do next
- Add an “ICP Fit” column (Yes/No or score) so teams can qualify before exporting
- Create segment views (by industry, size, location) to route accounts to the right teams
- Deduplicate by domain before exporting to CRM (prevents duplicate accounts)
- Push to CRM or outreach tools once approved (Salesforce/HubSpot via Zapier/Workato)
- Schedule refresh cycles: re-run enrichment monthly/quarterly to keep account lists current
The goal: Stop treating account lists like one-off spreadsheets. This play makes Google Sheets a repeatable, trackable account prospecting system—so you can find target companies, enrich them with verified Lusha data, and export clean lists whenever your team needs them.
No FAQ items available at this time.
Ready to build this?
Get started with Lusha and set up this play in minutes.
