Copy-paste formulas for reverse email lookup and enrichment
Paste a formula into row 2, test it on a few rows, then drag down to run the workflow across your spreadsheet.
Extract domain
A: email
=GPT("Extract only the domain from this email, lowercase, no spaces. If it is a free/personal provider (gmail, yahoo, outlook, icloud, etc.), return PERSONAL. Email: " & A2)
Company summary from domain
A: domain · B: notes
=GPT("Given this company domain, summarize the likely company (what they do, industry, rough size): " & A2 & ". Notes: " & B2 & ". If domain is PERSONAL or unclear, say Needs manual research.")
Industry / size tag
A: domain · B: source text
=GPT("Return a short industry tag and size band for this domain: " & A2 & ". Source: " & B2 & ". Return only tag, size band, and confidence.")
Fit score
A: company · B: ICP · C: source text
=GPT("Score 1-5 for ICP fit. Company: " & A2 & ". ICP: " & B2 & ". Source: " & C2 & ". Return score, reason, confidence, and what to verify.")
Short answer
Reverse email lookup and company enrichment in Google Sheets turns a list of email addresses into researched accounts. With GPT for Sheets you extract the domain from each email, flag personal domains, summarize the likely company, tag industry and size, and score fit, all across rows in the spreadsheet.
Fastest path: Install GPT for Sheets → add your source columns → paste a formula from the formula section → review 10 rows → fill down the sheet.
This page is for SDRs and ops teams who have a raw email list (signups, leads, event scans) and need company context before routing or outreach.
Workflow
A practical sheet for this workflow usually has these columns:
| Column | What to put there | Why it matters |
|---|---|---|
| A | Email address | Source value for each row |
| B | Source notes (optional) | Extra context to ground enrichment |
| C | Offer or ICP | Sharpens relevance and scoring |
| D | Extracted domain / PERSONAL flag | Bridges email to company |
| E | Company summary | Baseline firmographics |
| F | Industry tag and size band | For segmentation and routing |
| G | Fit score and next action | Sorts and routes the list |
| H | QA flag | Stops unsupported claims before outreach |
Step-by-step setup
- Start with 10 representative rows before filling down hundreds.
- Keep raw source fields unchanged so you can audit the AI output.
- Run one formula to create a research summary, then inspect weak rows.
- Add constraints: max length, required format, and what to do when data is missing.
- Add a QA formula that flags missing facts and unsupported assumptions.
- Fill down once the prompt works on your sample rows.
From email to domain to company
Most enrichment starts from a company or domain, but real lists often arrive as just emails. This workflow handles the full chain: extract the domain, flag free/personal providers that cannot be mapped to a company reliably, then enrich and score the rest. It is distinct from domain-only enrichment because it begins one step earlier, at the raw email.
Use cases
- Domain extraction: pull and normalize the domain from each email.
- Personal-domain handling: flag free providers that can’t map to a company.
- Enrichment: summarize the likely company per domain.
- Segmentation: tag industry and size band.
- Prioritization: score fit before routing or outreach.
Best for / not best for
Best for: SDRs and ops teams who only have emails and need company context across the list inside Google Sheets.
Not best for: mapping personal-domain emails to a company (often impossible) or expecting guaranteed-accurate firmographics without review.
Use GPT for Sheets to enrich the business-domain rows and clearly separate personal-domain rows that need manual handling. Verify before outreach.
Internal links and next workflows
- GPT for Sheets product page
- GPT for Sheets pricing
- Enrich company domains from Google Sheets
- Email list company enrichment in Sheets
- Domain enrichment in Google Sheets
- Upgrade GPT for Sheets
Safety, compliance, and data quality
Respect privacy and consent. Personal-domain emails cannot be reliably mapped to a company, so flag and handle them separately. Keep source columns visible, verify firmographics before outreach, and do not infer sensitive attributes.
Frequently Asked Questions
How do I look up a company from an email in Sheets?
Install GPT for Sheets, extract the domain with the domain formula, flag personal domains, then run the company-summary and fit-score formulas across the business-domain rows.
Can it map a Gmail address to a company?
No. Free/personal-domain emails can’t be reliably mapped to a company; the domain formula flags them as PERSONAL for manual handling.
Is the firmographic data guaranteed accurate?
No. Treat summaries and tags as drafts and verify before routing or outreach.
Does my list stay in Sheets?
Yes. Inputs and outputs stay in your spreadsheet columns for review.
Turn a list of emails into researched accounts
Install GPT for Sheets and run the email-to-company chain across your list inside Google Sheets.