Create a column with email addresses.
Find Names & Domains by Email Addresses
Split an email address into its name parts and domain Γ’ΒΒ instantly.
Start splitting emails in Google Sheets βFirst name, last name and domain. Free.
https://app1.derrick-app.com/mcp Call the same enrichment endpoints from your own stack or workflow.
Read the API docs βThat's the demo. Now run it on your data.
Install Derrick in Google Sheets and enrich your own leads - free to start, no credit card.
Install Derrick - it's free βHow to use this feature
Get started in 3 simple steps.
Open the Derrick add-on, choose Find Names & Domains by Email, and select the columns to process.
Your sheet fills with the name parts and domain split from each email.
All the data you can extract
Enrich companies and leads with 3+ data points each.
| Field Name | Description | Example |
|---|---|---|
| π firstName | First name extracted from email address | Jacques |
| ππ½lastName | Last name extracted from email address | Moreau |
| π domain (email) | Domain extracted from email address | acme-corp.com |
Find Names & Domains by Email Addresses
Combine this feature with others to create powerful automation workflows.
Find Names & Domains by Email Addresses use cases
Split a list of work emails into their parts with a simple regex - the local-part tokens plus the domain. For example s.chen@notion.so becomes s / chen / notion.so. It is a deterministic string split, not a lookup, so it is completely free and unlimited - no credits, no API.
- Inbound form clean-up: free-trial signups give email only - split the local part to pre-fill first/last name fields.
- Newsletter list prep: turn a 5,000-row email list into name tokens + company domains for segmentation, instantly.
- CRM dedupe: extract the domain from contact emails to roll personal records up to a single account record.
- Webhook enrichment: any inbound event with an email gets its name tokens + domain split out on the fly, at zero cost.
Use Find Names & Domains by Email Addresses via the API
Find Names & Domains by Email Addresses isn't tied to the Google Sheets sidebar. Every Derrick enrichment - this one included - is also exposed through the REST API and the MCP server, so you can run it from your CRM, your data pipeline, an AI assistant, or any no-code tool (Zapier, Make, n8n). Same credit cost as the add-on, same data. API access is included from the Standard plan up.
Read the API docs βLoved by sales teams worldwide
See what our customers say about Derrick.
"This app saved me so much time and effort. Great for anyone looking to build a contact list or network at scale quickly. As a start-up it's been invaluable."
"Working pretty nifty compared to Snov.Io. Price wise it does give a fair shake, and IMO better interface since it's google sheets."
"Derrick is a very simple and user-friendly app to enrich your contacts database. Best thing: you can test it for free. And then the price is so low, it's a no brainer."
"Super easy to enrich linkedin urls using this tool. Both personal and company url data can be easily enriched with a click of a button."
"Amazing Tool, I would like to advocate this to my colleagues. So that you can get more users. Keep it Up. 5 Stars!"
"This app is fantastic. Brilliantly created to help small and mid sized businesses."
"I have been using other expensive apps or freemium like phantombuster, but Derrick has replaced them all. I love the simplicity of the Google sheet add-in, but what is best is the efficiency it delivers."
"The LinkedIn scraping and email finder combo is incredibly powerful. I can build a complete prospect list with contact info in under an hour. Absolute must-have for outbound."
"Have tested over 10+ LI scraper apps, Derrick beats them all. Simple to use, accurate data, and affordable price."
Reverse email lookup is the inverse of the email finder workflow : you already have the email, you need the real name + company behind it. Most B2B teams hit this when triaging cold-inbound, deduplicating CRM lists, or qualifying webinar / lead-magnet signups. Most enrichment tools (Apollo, Clearbit, Hunter) sell this as a separate API endpoint and meter it per call. Derrick reads the email column directly from your Google Sheet and returns the verified first name + last name + company domain in the next cells - free and unlimited, with no credit consumed.
The main limit is structural : free-mail addresses (gmail / yahoo) where no company can be inferred from the domain itself stay blank - same outcome you'd get from any tool. See where this fits in the Derrick plan grid.
Related : the find full name from email recipe shows the exact Sheets workflow. Comparing tools : top Apollo alternatives by use case, Clearbit review, Hunter vs Derrick head-to-head.
Frequently asked questions
Do I need to install anything to use Find Names & Domains by Email Addresses?
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Find Names & Domains by Email Addresses is one of the workflows available from the Derrick sidebar inside any Sheet. The same feature is also available via REST API and via the Derrick MCP server for Claude / ChatGPT.
Can I use Find Names & Domains by Email Addresses on a list of 1,000+ rows?
Yes - Find Names & Domains by Email Addresses runs as a batch job inside Google Sheets, with progress tracking and per-row credit accounting. The workflow scales linearly: 10 rows or 10,000 rows, the steps are identical and you can step away while it runs.
Where does the data behind Find Names & Domains by Email Addresses come from?
Derrick aggregates 10+ public-data sources (LinkedIn graph, company websites, registry data, web crawl, third-party providers) and runs a multi-source lookup for Find Names & Domains by Email Addresses. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.
Is Find Names & Domains by Email Addresses GDPR-compliant?
Yes. Derrick only enriches public data, doesn't store personal records beyond the duration of the lookup, and supports full deletion on request. The Sheets add-on runs inside Google's OAuth-protected environment so your data stays private to your account.
Can I trigger Find Names & Domains by Email Addresses automatically when I add a row?
Yes - set up a Google Sheets onEdit trigger (Apps Script, takes 2 minutes) so a new row in column A automatically runs Find Names & Domains by Email Addresses into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
Find Names & Domains by Email Addresses is completely free and unlimited feature
Try it for free β