This template adds company enrichment to Google Sheets, using a ready-made Apps Script from the Lusha API Hub. Add a company name or domain, run the script, and the sheet fills in firmographics, signals, and tech stack data you can use for targeting and scoring.
Google Sheets company enrichment engine
Why enrich companies in Google Sheets?
Researching companies by hand is slow and hard to keep consistent. One person checks Crunchbase, another checks LinkedIn, someone else guesses the tech stack, and segmentation turns into a debate.
This template gives everyone the same data. You add a company name or domain, and Lusha fills in verified company details, so targeting and routing are based on the same facts every time.
What this workflow does
- Adds firmographics, like industry, employee count, revenue, and headquarters location
- Adds intent signals and recent funding events
- Shows the technologies each company uses
- Lets you enrich all companies, only new or failed rows, or a specific range
- Shows a summary of how many rows were enriched and how many credits were used
Once your list is enriched, you can prioritize accounts showing intent or funding activity, personalize outreach by size, industry, or tech stack, and segment and score accounts faster.
What your sheet needs
One of these columns is enough:
- Company Name (column A)
- Company Domain (column B)
Tip: A domain gives the most accurate match. A company name works too, but results may be less precise.
How to set it up
01
Add the Lusha Apps Script
- Open a new or existing Google Sheet
- Go to Extensions → Apps Script
- Delete any existing code
- In Lusha API Hub (inside your Lusha dashboard), search “Automate Company Data Enrichment” (or a similar Sheets template)
- Copy the full script and paste it into Apps Script
02
Store your API key in Script Properties
- In Apps Script, click the gear icon → Project Settings → Script Properties
- Click Add Script Property
- Property name: api_key
- Value: paste your Lusha API key
- Click Save, return to the sheet, and refresh
03
Run enrichment from the spreadsheet menu
After refresh, you’ll see a new menu: Lusha Company Enrichment, with options like:
- Enrich All Companies
- Enrich New/Failed Companies
- Choose Row Range to Enrich
- Set Max Row for All or New Enrichments
Add a few rows with company names/domains, then run the option you want.
The script fills your sheet automatically and shows a summary (rows enriched + credits used).
What to do next
- Export enriched companies to CSV
- Sync to your CRM using Zapier/Make (or your ops automation tool)
- Use the enriched fields for scoring, segmentation, routing, and personalized outreach
The goal: Stop researching companies by hand and qualify accounts at scale, right from a sheet.
FAQ
Add the Lusha Apps Script from the API Hub to your sheet, save your API key in Script Properties, and run “Enrich All Companies” from the Lusha Company Enrichment menu.
Industry, employee count, revenue, headquarters location, intent signals, funding events, and technologies used.
No. You copy a ready-made script and paste it in. There’s no code to write.
A domain gives the most accurate match. Use a company name if that’s all you have.
Yes. Choose “Enrich New/Failed Companies” to skip rows that are already enriched.
Ready to run this?
One data connection. Works in Claude, ChatGPT, your CRM, or any agent you build.
