More Resources
Template Ops

Auto-search & enrich companies in Google Sheets

Built by: Lusha
Difficulty: Medium
Tools: Google Apps Script ▪ Google Sheets ▪ Lusha
Copy your API key

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

01

Create your Google Sheet

  • Create a new Google Sheet
  • Name the sheet Sheet1 (or update SHEET_NAME in the script)
02

Add the Apps Script

  • Go to Extensions → Apps Script
  • Delete any existing code
  • Paste in the provided company search + enrich scrip
  • Save
03

Add your Lusha API key

In the script, set:

  • API_KEY = ‘API key here’
04

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.

05

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.

Related Plays

Ready to run this?

One data connection. Works in Claude, ChatGPT, your CRM, or any agent you build.

Start for free Read the Docs