Lead Enrichment Template
Enrich leads in Google Sheets with AI: company research with =PERPLEXITY(), emails with Hunter.io functions, Google results with =SERP(). A lightweight Clay alternative.
Turn a bare list of companies into a researched lead table — inside Google Sheets, without per-seat enrichment platforms. This is the lightweight Clay alternative for teams that live in spreadsheets.
Layout
| Column | Content | Formula |
|---|---|---|
| A | Company domain | — |
| B | What they do | =PERPLEXITY("What does this company do? One sentence:", A2) |
| C | Industry | =GPT_CLASSIFY(B2, "SaaS, e-commerce, agency, fintech, other") |
| D | Recent news | =PERPLEXITY("Most recent notable news about "&A2&", one line with year") |
| E | Emails (Hunter.io) | =HUNTER_DOMAIN_SEARCH(your_api_key, A2) |
Verify before outreach
=HUNTER_EMAIL_VERIFIER(your_api_key, E2)
HUNTER_* functions use your own Hunter.io API key; the AI research functions need no keys at all.
Copy the email extraction template to start from a working example.
Get started
- Install GPT for Sheets from the Google Workspace Marketplace (free tier included, no API keys needed).
- Copy the template or paste the formulas into your own sheet.
- Drag the formula down your rows, then use Replace all GPT formulas with results in the sidebar.
Related guides: competitor lists from web search, extract emails from LinkedIn.
FAQ
Is this really a Clay alternative?
For spreadsheet-native enrichment — yes: research, classification and email lookup happen in your sheet with formulas. Clay is stronger for multi-step waterfalls and CRM syncs; GPT for Sheets wins on simplicity and cost for list-based work.
Where does the company data come from?
=PERPLEXITY() answers with live web knowledge and =SERP() returns Google results. Email data comes from your own Hunter.io key via the HUNTER_* functions.
Is scraping LinkedIn allowed?
The template works from public web data and Hunter.io’s index. Respect the terms of service of data sources and applicable privacy laws for outreach.