How to Find Anyone's Email from Their LinkedIn Profile — Inside Google Sheets
A practical guide to turning LinkedIn profile URLs into verified work emails without leaving your spreadsheet. No coding required.
You have a LinkedIn profile URL. You need an email address. What you don’t need is another manual copy-paste loop between tabs.
This guide covers exactly how to go from a column of LinkedIn URLs to a column of work emails — inside Google Sheets, with no code.
Why LinkedIn Doesn’t Give You the Email
LinkedIn makes contact information deliberately hard to access. Even first-degree connections often hide their email. InMail has strict limits. The platform’s design incentivizes staying inside LinkedIn, not extracting data from it.
What LinkedIn enrichment providers do instead: they’ve built their own databases of professional contact information, indexed by LinkedIn profile URL. When you submit a URL, you get back whatever they have on file for that person — typically a work email, and sometimes a phone number.
You’re not scraping LinkedIn. You’re querying a B2B data index.
What You Need Before You Start
A column of LinkedIn profile URLs. These must be individual profile URLs — linkedin.com/in/firstname-lastname format. Company pages (linkedin.com/company/...) won’t work and will return no results.
API credentials from at least one provider. The LinkedIn Enricher add-on supports two providers: Datagma and LeadMagic. You can sign up for either (or both) and get API keys. Most providers offer free trial credits.
The LinkedIn Enricher Google Sheets Add-on installed. Available from the Google Workspace Marketplace.
The Process, Step by Step
Step 1 — Prepare Your Sheet
Your LinkedIn URLs should be in a single column. Ensure they’re formatted correctly:
| ✅ Valid | ❌ Invalid |
|---|---|
https://www.linkedin.com/in/jane-doe | linkedin.com/company/acme |
https://linkedin.com/in/john-smith-123abc | Jane Doe (LinkedIn) |
linkedin.com/in/maria-rodriguez | https://www.linkedin.com/posts/... |
Remove duplicates before enriching. Duplicate rows consume credits without adding results.
Step 2 — Add Your API Keys
- Open the add-on from Add-ons → LinkedIn Enricher → Open
- Go to the Settings tab
- Enter your API key for Datagma, LeadMagic, or both
- Click Test Connection to confirm each key is valid
Keys are stored per-user via Google’s PropertiesService — they never leave your Google account.
Step 3 — Configure and Run Enrichment
- Go to the Enrich tab
- Select the column containing your LinkedIn URLs
- Choose your primary provider (Datagma or LeadMagic)
- If you have both keys set up, leave fallback enabled
- Check Skip already-enriched rows if you’ve run this sheet before
- Click Enrich Selected Rows
The add-on processes each row sequentially and writes results directly into your sheet.
Step 4 — Review the Results
The add-on writes four columns per enriched row:
| Column | What it contains |
|---|---|
| Work email address, or blank if not found | |
| Phone | Phone number if available (lower hit rate) |
| Provider | Which provider returned the result |
| Timestamp | When this row was enriched |
Rows where no email was found will show a status indicator. These can be queued for re-enrichment later or contacted via LinkedIn directly.
Realistic Hit Rates
Not every URL will return an email. Here’s what to expect across common scenarios:
| List type | Estimated email hit rate |
|---|---|
| US tech company employees, VP/Director | 65–80% |
| US enterprise, mixed seniority | 60–75% |
| EMEA profiles, any industry | 50–65% |
| Healthcare or regulated industries | 50–62% |
| SMB owners and founders | 55–70% |
Hit rates improve when you use both providers with fallback enabled. In our testing, the dual-provider setup recovers 10–15 percentage points over either provider alone.
What to Do With the “Not Found” Rows
About 25–40% of rows won’t return an email. Options for handling these:
Re-enrich in 60–90 days. Providers update their databases regularly. A profile that returned nothing today may have data in two months.
Try the other provider directly. If Datagma was your primary and returned no result, switch to LeadMagic as primary and re-run just the failed rows.
Contact via LinkedIn. For high-priority contacts, a direct LinkedIn message is often more effective than cold email anyway.
Enrich by domain + name instead. If you know the person’s company domain, some providers offer email-finding via [email protected] pattern matching. This is a different enrichment method, not covered by the LinkedIn URL path.
Email Verification Before Sending
Enrichment finds the email that was indexed — not necessarily the email that’s active today. People change jobs. Email addresses go stale.
Before running any outreach sequence, verify the emails you found:
- For lists older than 30 days: verify all emails
- For EMEA-heavy lists: verify before sending (higher job-change rate)
- For enterprise contacts at large companies: corporate emails are more stable, but still verify at scale
Email verification is a separate step from enrichment. It confirms that the email address exists and will accept messages without bouncing.
Common Mistakes
Enriching company page URLs. If any row has linkedin.com/company/..., it will always fail. Filter these out before running.
Running without fallback when you have both keys. The extra credits spent on fallback rows are almost always worthwhile, especially for targeted lists.
Not checking the “skip already-enriched” box on re-runs. This burns credits on rows that already have results.
Sending immediately after enrichment. Always verify before outreach, especially at scale.
For context on how enrichment providers compare, see our Datagma vs LeadMagic test results →.
Start finding emails from LinkedIn inside Google Sheets. LinkedIn Profile Enricher — install free →